Open navigation

About the query list in Google Sheets

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:

  1. Open the Supermetrics sidebar.
  2. Click the top-left menu icon .
  3. Click Switch back to the old experience.


To enable the query list:

  1. Open the Supermetrics sidebar.
  2. Click the top-left menu icon .
  3. 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.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.