Every time you pull data from a data source, the Supermetrics Google Sheets add-on creates and runs a query in the background. 

So if you pulled data from four different data sources (say Google Analytics, Google Ads, Facebook Ads, and Google Search Console) into Google Sheets, the Supermetrics Google Sheets add-on ran four different queries in the background. Therefore by extracting data from multiple data sources into one Google Sheet, we ran multiple queries in one Google Sheet.

However, you should avoid running more than one query per Google Sheet.

How to view query information in Google Sheets via Supermetrics

There are two ways to view query information in Google Sheets via Supermetrics Google Sheets Add-on:

1. Via the Supermetrics sidebar
2. Via a SupermetricsQueries sheet

#1 Viewing query information via Supermetrics sidebar

Follow the steps below:

Step-1: Click on any cell in the data table in your Google Sheet whose query information you want to see. For example in the screenshot below I clicked on a cell of the data table which shows data from Google Analytics:

Step-2: Navigate to  ‘Add-ons’ menu > Supermetrics and then click on the ‘Launch Sidebar’ link:

You should now be able to see the query information:

Similarly, if you click on any cell in another data table, you should be able to see the query information related to that data table. For example in the screenshot below I clicked on a cell of the data table which shows data from Google Ads:

---

Get the ebook on Google Data Studio (50+ Pages)

---

#2 Viewing query information via a SupermetricsQueries sheet

Follow the steps below:

Step-1: Navigate to ‘Add-ons’ menu > Supermetrics and then click on the ‘Manage Queries’ link:

As soon as you click on the ‘Manage Queries’ link, Supermetrics will create a new sheet in your Google Sheet document named SupermetricsQueries:

Step-2: Click on the ‘SupermetricsQueries’ sheet tab. All the queries created by supermetrics are stored here:

If you remember, we pulled data from four different data sources (Google Analytics, Google Ads, Facebook Ads, and Google Search Console) into Google Sheets. In other words, we ran four different queries via Supermetrics Google Sheets add-on. That’s why the SupermetricsQueries sheet shows data for four different queries:

Each query is uniquely identified by an ID called the ‘Query ID’.

Through a SupermetricsQueries sheet you can:

1. Modify the parameters of a query. Any changes will be visible when you run a refresh.
2. Remove a query by deleting its row.
3. Add new queries: type a range address and query parameters, leave the query ID empty. The query will be added when you run a refresh. (Of course, it’s much easier to use the Supermetrics sidebar to add new queries.)
4. Add queries that point to other spreadsheets: follow step 3, but also add a spreadsheet ID (you can see the ID in the URL when you have a file open)

How to modify queries in Google Sheets via Supermetrics

Every time you pull data from a data source (like Google Search Console), the Supermetrics Google Sheets add-on creates and runs a query in the background. 

Supermetrics run queries at a specific location in Google Sheets. This location is specified by you when you click on a particular cell.

There are two methods to modify a query:

1. Via Supermetrics Sidebar (recommended)
2. Manually modify the query via the SupermetricsQueries sheet

#1 Modifying query via Supermetrics sidebar

Step-1: Click on any cell in the data table in your Google Sheet whose query information you want to see. 

For example in the screenshot below I clicked on a cell of the data table which shows data from Google Analytics:

Step-2: Navigate to  ‘Add-ons’ menu > Supermetrics and then click on the ‘Launch Sidebar’ link:

You should now be able to see the query information:

Step-3: Click on the ‘Modify’ button to modify your query:

Step-4: Change one or more settings (like ‘Data Source’, ‘Views’, ‘Dates’ etc): 

When you change these settings, supermetrics is modifying the query in the background.

Step-5: Once you have made all the necessary changes, click on the ‘Get Data To Table’ button:

#2 Manually modify the query via the SupermetricsQueries sheet

Step-1: Click on the ‘SupermetricsQueries’ sheet tab.

Step-2: Manually change one or more fields (like ‘Range Address’, ‘Date Range Type’, ‘Start Date’, ‘End Date’ etc) of a query:

You need to have a very good knowledge of Google Sheets and its formulas if you want to modify the queries directly via the SupermetricsQueries sheet. Otherwise, you are likely to make a lot of mistakes and your queries may not run. That’s the reason, I don’t recommend modifying queries manually.

Step-3: Once you have made all the necessary changes to your query then click on the ‘Refresh All’ link (under (Add-ons > Supermetrics menu):

You would then see a message box like the one below:

Followed by:

That’s how you can modify queries in Google Sheets.

Refreshing queries automatically in Google Sheets

If you want the latest data in your Google Sheets all the time then you should schedule query refreshes via Supermetrics Google Sheets Add-on. 

When you schedule refreshes, Supermetrics automatically refresh queries after a certain time has elapsed. 

For example, you can set Supermetrics to automatically refresh queries every hour. In this way, the data in your Google Sheets will always remain up to date. Otherwise, you would have to remember to manually update the query, every time you choose to use that data either in Google Sheets or Google Data Studio.

Follow the steps below to schedule query refreshes:

Step-1: Click on ‘Schedule refresh & emailing’ (under ‘Add-ons > Supermetrics):

Step-2: Select the action you want Supermetrics to take from the ‘Action’ drop-down menu:

Following is a short description of various actions you can select:

Refresh hourly – Supermetrics will automatically refresh/run queries every hour:

Refresh daily – Supermetrics will automatically refresh/run queries once every day at a specified time:

Refresh weekly – Supermetrics will automatically refresh/run queries once every week on a specified day and time:

Refresh monthly – Supermetrics will automatically refresh/run queries once a month on a specified day and time:

Refresh & Email daily – Supermetrics will automatically refresh/run queries once every day at a specified time and then automatically email the report in the format you specified:

Here is how the email notification from Supermetrics may look like:

Refresh & Email weekly – Supermetrics will automatically refresh/run queries once every week on a specified day and time and then automatically email the report in the format you specified.

Refresh & Email monthly – Supermetrics will automatically refresh/run queries once every month on a specified day and time and then automatically email the report in the format you specified:

Step-3: Once you have selected the action you want Supermetrics to take from the ‘Action’ drop-down menu, click on the ‘Store Trigger’ button:

Step-4: If you want Supermetrics to take another scheduled action then click on the ‘+Add trigger’ button:

Step-5: Configure your second trigger and then click on the ‘Store Trigger’ button:

Step-6: Click on the ‘Close’ button.