Skip to main content

How to connect Google Sheets sources

Learn more about the integration and how to import your analytics data from Google Sheets.

Before you connect

  • The sheet's date column is advised to be formatted as YYYY-MM-DD. This is how Whatagraph identifies the date range and ensures correct data mapping.

  • The date column is essential not only for recognizing the date range but also for ensuring successful data mapping and connectivity between Google Sheets and Whatagraph; ensure that columns are formatted correctly as dates.

  • If your sheet contains non-date-based data, such as a media plan or a targets table, you can turn off date filtering in the source's settings during connection. When disabled, all rows are returned regardless of the report date range you select.

  • The sheet must have at least one column containing only numeric values - this is what gets recognized as a metric.

  • If you need to report on percentage or currency values, use the FORMAT function in Google Sheets to set the number type before connecting.

  • If you need to add new columns after connecting, add them at the end of the sheet. Columns are mapped by position; moving existing columns may break your widget configuration.

Here's an example of how the formatting could look in the sheet:

Download a sample Google Sheet template here.
​

Connecting Google Sheet sources

Step 1. In the "Data" space, select "Sources", then click on "+Connect new source" and find Google Sheets integration.
​

Step 2. Once you connect your source, do not forget to set the same date range as in your Google Sheets when creating new widgets.
​​

Step 3. If the connected sheet doesn't have a date column, and you wish for it to be ignored in your reports, edit the source directly in the Sources tab:
​

How columns are recognized

The column type is inferred automatically from cell values.

  • Text columns (e.g., "March TOFU campaign", or "March 2026 campaign") are automatically recognized as dimensions. If a column isn't being recognized correctly, you can append wg:dimension to the column name — e.g. Category wg:dimension.

  • Number columns (e.g., 165) are automatically recognized as metrics. If a column isn't being recognized correctly, append wg:metric to the column name — e.g. Clicks wg:metric.

Tip: If a number column contains any text values, it will be treated as a dimension. Make sure numeric columns contain only numbers.

Good to know

  • Reports refresh every hour. To pull in changes immediately, manually refresh the report.

  • Formulas work fine. Whatagraph reads the visible cell value, not the underlying formula.

Related Articles
Did this answer your question?