What it does
A reporting sidebar for Google Sheets, built for media buyers and agencies who report across several ad platforms.
- Create queries from a sidebar: pick a data source, accounts, metrics, dimensions, a date range and optional filters.
- Each query writes its table at the cell you selected. Add as many queries per spreadsheet as you need.
- Refresh one query, every query in the current sheet, or the whole spreadsheet from the Extensions menu.
- Schedule refreshes (hourly, daily, weekly or monthly, up to 5 per spreadsheet). Schedules run on Whathead servers, so the spreadsheet does not need to be open.
- Ratios such as CTR, CPC, CPM and ROAS are recalculated from their parts, so totals stay correct.
Data sources
You connect these platforms once in your Whathead workspace. The add-on can only read accounts your workspace already has access to.
- Meta Ads (Facebook & Instagram)
- Google Ads
- TikTok Ads
- Snapchat Ads
- LinkedIn Ads
- X Ads
- Reddit Ads
- Display & Video 360
- Microsoft Advertising
- Apple Ads
- Amazon Ads
- Google Analytics 4
- Adjust
- AppsFlyer
Install and sign in
- Create a Whathead account at whathead.com/register (free trial) and connect your ad platforms under Integrations.
- Install the add-on. In Google Sheets open Extensions → Add-ons → Get add-ons, search for Whathead and click Install. You can also install it from the Google Workspace Marketplace.
- Review the permissions Google shows (explained below) and click Allow.
- Open the sidebar from Extensions → Whathead for Google Sheets → Launch sidebar.
- Sign in. Click Sign in with Whathead. A whathead.com tab opens; approve access there and the sidebar signs in by itself.
Build and refresh queries
- Select the cell where the table should start, then click Create query.
- Choose a data source and accounts, then metrics, dimensions (split by) and dates. Optional: filters and a comparison period.
- Click Get data. The rows are written at the selected cell.
- Use Refresh all or Refresh queries in this sheet from the menu, or add a schedule in the Schedules tab. Scheduled refreshes ask you to connect Google Sheets in Whathead once (see below).
Query settings are saved in a hidden tab called WhatheadQueries inside the same spreadsheet, so anyone you share the spreadsheet with sees the same queries.
Permissions explained
The add-on asks for three Google permissions, the minimum it needs. It does not request access to Google Drive, Gmail or your other spreadsheets.
| Permission (OAuth scope) | Why Whathead needs it |
|---|---|
View and manage spreadsheets that this application has been installed inhttps://www.googleapis.com/auth/spreadsheets.currentonly | Reads and writes only the spreadsheet you open the add-on in: the selected cell, the query tables it writes, and the hidden WhatheadQueries tab that stores your query settings. |
Display and run third-party web content in prompts and sidebars inside Google applicationshttps://www.googleapis.com/auth/script.container.ui | Shows the Whathead sidebar and the refresh progress dialog inside Google Sheets. |
Connect to an external servicehttps://www.googleapis.com/auth/script.external_request | Calls the Whathead API (www.whathead.com only) to sign you in, list your connected accounts and fields, run queries and return the report rows. |
Optional, only for scheduled refreshes: because schedules run on Whathead servers while the spreadsheet is closed, Whathead asks you to connect Google Sheets in the Whathead web app. That separate Google consent requests spreadsheets (to write the query tables into the spreadsheet you scheduled) and drive.file (files you use with Whathead), plus your basic profile and email to identify the connection. You can skip it and refresh by hand instead.
How your data is used
Whathead's use of information received from Google APIs adheres to the Google API Services User Data Policy, including the Limited Use requirements.
Sent from the spreadsheet to Whathead
- The spreadsheet's ID, name, URL and timezone, to link the spreadsheet to your Whathead workspace.
- For each query: its settings, the sheet name and anchor cell, and the value of any cell a date setting refers to.
Written into the spreadsheet
- Report rows from the platforms connected to your Whathead workspace, and the query settings in the hidden WhatheadQueries tab.
Not accessed or not sent
- Other spreadsheets, Google Drive, Gmail and your Google contacts are never accessed.
- Cells where a query will write are checked inside the spreadsheet so your own data is not overwritten without asking. Their contents are not sent to Whathead.
Storage and retention
- Your Whathead session token is kept in your browser's local storage for this spreadsheet, not in Google or the spreadsheet.
- Query definitions and schedules are stored in your Whathead workspace until you delete them or the workspace.
- Run results are cached for up to 7 days (the latest successful result of each query is kept so it can be rewritten), then deleted.
Whathead does not sell this data, does not use it for advertising, does not let people read it except for support you request, security or legal reasons, and does not use it to train AI models. Full details are in the Privacy Policy.
Disconnect or uninstall
- Sign out from the profile menu in the sidebar. This deletes the session token from your browser.
- Uninstall from Extensions → Add-ons → Manage add-ons in Google Sheets.
- Remove the add-on's Google access at myaccount.google.com/permissions.
- Delete the WhatheadQueries tab to remove saved query settings from the spreadsheet.
Support and legal
Questions, errors or permission issues: whathead.com/support or [email protected]. We reply within one business day.
Google Sheets™ and Google Workspace™ are trademarks of Google LLC.