1. Fetch your GA Account hierarchy by selecting the "1. Build Google Analytics hierarchy" menu item.

2. Select rows in the hierarchy by adding "x" or "X" in the final, empty column.

3. Fetch Custom Dimension name, scope, and active status for the selected rows by selecting the "2. Run validator" menu item.

4. In the new "GA Dimensions" sheet, select any cell in any data column, and click "3. Fetch last 7 days data for selected view" to populate the "LAST 7 DAYS" column with hit data for each ACTIVE Custom Dimension in the property.

See: https://www.simoahava.com/tools/google-analytics-validator/