The Supermetrics sidebar in Google Sheets organizes your queries into an accessible list on the 
Queries tab. It's designed to make query management as simple as possible.
Benefits
On the Queries tab, you can:
See every query in a spreadsheet in one place.
Quickly edit and refresh queries.
Duplicate and delete queries. Click the three-dot menu next to the query name to duplicate and delete queries as well as manage the data source connection.
More easily navigate complex spreadsheets. To focus only on queries on the current sheet, click In current sheet.
Filter and search queries.
Sort queries by data updated, data source name, or query creation time.
Easily identify queries with errors. To view queries with errors, click Errors.
You can switch between two views on the Queries tab by scrolling down to the bottom of the tab, where you have the following options:
Enable query builder view: The query builder view displays only the side menu of each query, hiding the query card list.
Enable query list view: The query list view shows all queries in query cards.
Troubleshooting query errors
If a query fails or returns no data, its card in the query list shows a short description of the problem and a way to resolve the issue.
Most common issues you’ll get troubleshooting instructions for:
Empty results: Date ranges, comparison date ranges are invalid, or there’s a filter excluding matching results. Follow the guidance to resolve.
Expired connection: Your connection to the data source needs to be renewed. Follow the steps to reconnect.
Subscription issues: A data source that isn't included in your current plan, or a suspended subscription. Follow the steps to check your subscription settings.
Service and connection outages: A temporary outage at the data source or a failed database connection. Follow the steps to retry, check the service status, or reconnect to the data source.
Account and permission problems: No account selected, an account that's no longer available, or missing permissions on a property. Follow the steps to select an account again or confirm your permissions.
Spreadsheet and query limits: For example, reaching Google Sheets' 10,000,000-cell limit, a data source's rate limit, a broken cell reference, or a query pointing to a deleted range. Follow the steps for a specific fix for each case.
Discontinued data sources: If a data source is no longer supported, the panel explains this clearly and gives you the option to delete the query.
Keep in mind
The 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 into your spreadsheet.
You might see queries in the list that you can't see on 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 but leave the data on the spreadsheet, click the three-dot menu in the query list and select Delete query and leave data on the sheet.
To delete one query and its data, click the three-dot menu and select Delete query with data.
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. Learn more about using the SupermetricsQueries tab.