--- title: "About the Queries tab in Google Sheets" slug: "about-the-queries-tab-in-google-sheets" description: "Manage your queries effortlessly in Google Sheets with Supermetrics. Edit, refresh, and organize all your queries in one accessible list." updated: 2026-09-24T10:46:58Z published: 2026-09-24T10:46:58Z canonical: "docs.supermetrics.com/about-the-queries-tab-in-google-sheets" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt > Use this file to discover all available pages before exploring further. # About the Queries tab in Google Sheets The Supermetrics sidebar in Google Sheets organizes your queries into an accessible list on the ![Icon representing a document with a graph, indicating Supermetrics queries in Google Sheets sidebar.](https://cdn.document360.io/a13cead5-eaae-456f-9bd1-0941d590c0e3/Images/Documentation/google-sheets-queries-tab-icon.png) **Queries** tab. It's designed to make query management as simple as possible. ## Benefits On the ![Icon representing a document with a graph, indicating Supermetrics queries in Google Sheets sidebar.](https://cdn.document360.io/a13cead5-eaae-456f-9bd1-0941d590c0e3/Images/Documentation/google-sheets-queries-tab-icon.png) **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](/v1/docs/about-the-supermetricsqueries-tab-advanced). ## More resources - [About the Home tab in the Supermetrics sidebar in Google Sheets](/v1/docs/about-the-home-tab-in-the-supermetrics-sidebar-in-google-sheets) - [How to connect to a Supermetrics data source in Google Sheets](/v1/docs/how-to-connect-to-a-supermetrics-data-source-in-google-sheets) - [How to reauthenticate a data source connection](/v1/docs/how-to-reauthenticate-a-data-source-connection)