Before you connect
The sheet must have a date column 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 recognising 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.
The sheet must have at least one column containing only numeric values - this is what gets recognised 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.
How columns are recognised
The column type is inferred automatically from cell values.
Text columns (e.g. "March TOFU campaign", or "March 2026 campaign") are automatically recognised as dimensions. If a column isn't being recognised correctly, you can append
wg:dimensionto the column name — e.g.Category wg:dimension.Number columns (e.g. 165) are automatically recognised as metrics. If a column isn't being recognised correctly, append
wg:metricto the column name — e.g.Clicks wg:metric.
Note: 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.