Skip to main content
The Whathead add-on for Google Sheets pulls ad, analytics and attribution data into your spreadsheets. You build a query in the sidebar (source, accounts, dates, metrics, dimensions and filters), Whathead writes the results at the cell you choose, and you can refresh by hand or on a schedule that runs on Whathead’s servers. It works with 14 sources and any Whathead plan with an active trial or subscription.

Key facts

Before you start

  • Connect the ad platforms and data sources you want to report on in Whathead (Integrations). The add-on can only read accounts your workspace has connected.
  • Your workspace needs an active trial or subscription. Without one, queries return a subscription-required error.

Install and sign in

1

Install the add-on

Open the Whathead Google Sheets page and follow the install link, or search for Whathead on the Google Workspace Marketplace.
2

Open the sidebar

In a spreadsheet, open Extensions, choose the Whathead add-on, then Launch sidebar.
3

Sign in with Whathead

Click Sign in with Whathead. A browser tab opens to confirm the sign-in with your Whathead account. The sidebar then connects automatically.
The sidebar session lasts 12 hours. The session token is stored in your browser’s local storage for that spreadsheet.

Build a query

The sidebar walks through these sections: You can also add a comparison period: previous period, same period last year (optionally matching weekdays) or a custom range, shown as % change, absolute change or the comparison value. Ratios such as CTR, CPC, CPM and ROAS are recalculated from their parts, so totals and grouped rows are correct rather than averaged. Queries are saved inside the spreadsheet, in a hidden tab, so they stay with the file.

Refresh

From the Extensions menu you can Refresh all, Refresh queries in this sheet, Manage queries or Schedule refresh & emailing.

Scheduled refresh

  • Frequency: every 1, 2, 3, 4, 6, 8 or 12 hours; daily; weekly on the weekdays you choose; or monthly on a day from 1 to 28 or the last day of the month.
  • Limit: up to 5 schedules per spreadsheet.
  • Where it runs: on Whathead’s servers, so the spreadsheet doesn’t need to be open.
  • One-time setup: the first time you schedule a refresh, Whathead asks you to connect Google Sheets in Whathead so its servers can write to the file.
  • Emails: you can add up to 20 extra recipients. Emails are sent when a scheduled refresh fails or partly fails, not as report deliveries.
  • Auto-pause: a schedule is switched off after 5 failed runs in a row.

Limits

Looker Studio connector

The same sources in Looker Studio dashboards.

Platform capability matrix

Which platforms are reporting sources.

Pricing & limits

Plans and trial details.

Ad reporting with Claude & ChatGPT

Ask your AI assistant for reports instead.
Last modified on November 18, 2026