Fresh Sheets
Start free trialAdd to Google Sheets

Your marketing reports in BigQuery, as well as Sheets

The same report, defined once, written to its spreadsheet, to a table in your own BigQuery dataset, or both, on every refresh.

Start free trialOr install the Google Sheets add-on

30 days of Plus, free from sign-up. No card needed.

  • Google Analytics 4
  • Search Console
  • Google Ads
  • Meta Ads
  • Microsoft Advertising
  • TikTok Ads
  • Apple Ads
  • Klaviyo
  • Mailchimp
  • Shopify
BigQuery
  • Google Analytics 4
  • Search Console
  • Google Ads
  • Meta Ads
  • Microsoft Advertising
  • TikTok Ads
  • Apple Ads
  • Klaviyo
  • Mailchimp
  • Shopify
BigQuery
What it does

One report, two places, the same numbers

06:01

Google Ads, written to ads_spend

27 Sep 1,204.00
26 Sep 1,388.00
25 Sep 1,019.00
24 Sep 1,112.00
  • Where a report has a spreadsheet, every refresh writes it first, then the BigQuery table, from the same run.
  • Each run writes the report's own date range, so a report broken down by day builds up history in the table.
  • It works with every source Fresh Sheets reads, Google and non-Google alike.
  • Sending to BigQuery uses no extra refreshes.
Setup

Three steps, done once

  1. Share a dataset with Fresh Sheets. In Google Cloud, give Fresh Sheets' service account the BigQuery Data Editor role on the dataset you want to use.
  2. Add the label. Give the dataset the freshsheets label your account shows you, so nobody else can point Fresh Sheets at your dataset.
  3. Choose a report and a table. Under Destination, pick your dataset and name the table. Fresh Sheets creates it.
Your dataset

What Fresh Sheets touches

Fresh Sheets creates and writes only tables it has labelled as its own, plus a temporary table that is deleted after each write. It never reads the contents of any other table, or changes or deletes one.

How we handle your data
Plans

Included in every paid plan

BigQuery is part of every paid plan, and you can try it during your 30 days of Plus. One run counts once, however many places it writes to.

See what the paid plans include
By source

BigQuery, one source at a time

Analytics

Advertising

Email

Ecommerce

Questions

Which location does my dataset need to be in?

Any location. Fresh Sheets writes to your dataset wherever it is.

What happens if I stop sending a report to BigQuery?

The table and everything in it stay in your dataset. The report keeps refreshing its spreadsheet.

What happens to my tables if I move to Free?

Fresh Sheets stops writing to them, and nothing in them changes. Move to any paid plan to start sending again.

Can I send a report to a table that already exists?

Only one Fresh Sheets made for this report. It won't write to any other table.

Send your first report to BigQuery

Sign in, add your BigQuery dataset, then build a report and send it there on a schedule.

Start free trialOr install the Google Sheets add-on

30 days of Plus, free from sign-up. No card needed.