Google Sheets (data source) connection guide

This guide contains all permissions and requirements for connecting your Google Sheets data to Supermetrics.

You can connect to data sources from the Data sources page on the Supermetrics Hub. On the Hub, you can also share an authentication link to connect to a data source you don't have direct access to.

After you connect to the data source on the Hub, you can use the data source connection in all available destinations.

Required permissions

To connect to Google Sheets, you need a Google account with access to the Google Sheet you want to fetch data from.

Sheet structure

Overall structure: The connected sheet must be a table of data, where each field is represented as a column and each data point is a row.
Column header: The dataset must have a header row. The header row is used to label the dimensions and metrics in your Supermetrics destination, but is always excluded from the query results. Column headers should contain meaningful names - columns with empty headers or with headers not containing at least one letter or number character are ignored.
Location of the data: The data must start from cell A1, or you have to define a named range for the data to be fetched. The named range must cover the whole area from which data is fetched, and the first row of the named range will be treated as the header row.
Date range filtering: If you want to filter data in your sheet based on Date, please include data for the Date in the first column (A) of your sheet. If column A does not have Date data, all rows from the selected columns in the sheet or named range will be transferred to your destination.

Field List

The list of fields is always fetched dynamically for the selected sheet or named range. Therefore, you can only query data from one sheet or named range at a time. When changing the sheet or range you want to fetch data for, you must re-select all the fields after they have been loaded for that specific sheet or named range.
Note that for data warehouse transfers, this means creating a separate table for each sheet or named range you want to fetch data for.
Data Type:
- The connector scans all columns from the Google Sheet file and determines whether it’s a dimension or metric based on the value formatting.
- Columns with string, date, or boolean values will be listed as dimensions in your destination, and columns with numerical values as metrics.
- If you want to fetch numerical values as dimensions, please format the entire column as Plain text in your Google Sheet file.
- If the connected sheet or named range is modified, it can take up to 1 hour for the new data to be available through the connector due to caches.

If prompted, you need to select a query type to pull data.

When connecting to Google Sheets, you need to log in to Google and select the accounts to use when prompted.

Select the Google sheets data source on the Supermetrics Hub or in the data destination.
Enter the URL to your Google Sheet file.
If prompted, choose to make this connection shared or private.
Click Start.
Sign in with the Google Account you use with this data source. This doesn’t have to be the same as the Google account you use with Supermetrics.
Click Allow, and click continue.
Select all access scopes and click Allow. Failure to select all may result in the data source not functioning correctly.
In your data destination, select the sheet to pull data from.

You can also connect to Google Sheets from these destinations: