The Supermetrics sidebar in Google Sheets organizes your queries into an accessible list designed to make query management as simple as possible.
Benefits
With the query list, you can:
- See every query in a spreadsheet in one place
- Quickly select, refresh, modify, and delete queries
- More easily navigate complex spreadsheets
- Filter and sort queries
- Easily identify queries with errors
Disable or re-enable the query list
You can switch between the query list view and an older version of the Supermetrics sidebar at any time.
If you've run into a problem with the new experience, please contact our support team for help resolving it. We really appreciate general feedback, too.
To turn off the query list:
- Open the Supermetrics sidebar.
- Click the top-left menu icon
. - Click Switch back to the old experience.
To enable the query list:
- Open the Supermetrics sidebar.
- Click the top-left menu icon .
- Click Try the new sidebar experience.
Keep in mind
A query list shows all of the queries that are currently in your spreadsheet. It’s not a list of queries you’ve run, for example. It’s just a list of everything Supermetrics is pulling to your spreadsheet.
You might see queries in the list that you can’t see in the spreadsheet. This can happen when a query’s data is removed but the query itself isn’t deleted from the spreadsheet.
- To delete one query, click the three-dot menu in the query list and select Delete query.
- To delete multiple queries at once, open the SupermetricsQueries tab (this is hidden by default — navigate to Extensions → Supermetrics → Manage queries to show it) and delete the rows for any queries you want to remove.