Skip to content

BigQuery to Google Sheets

Send BigQuery data to Google Sheets automatically

Connect BigQuery to Mammoth, pick the fields you want and send them to Google Sheets. Mammoth keeps Google Sheets up to date on a schedule, so nobody exports a report by hand.
  1. BigQuery
  2. Mammoth
  3. Google Sheets
    WeekRegionOrdersRevenue
    2026-W45North1,284$96,300
    2026-W45South1,019$74,880
    2026-W45West1,552$118,410
    2026-W46North1,331$99,020

Shown on sample data.

Set up BigQuery to Google Sheets in three steps

  1. Step 1

    Connect BigQuery

    Upload a Google Cloud service account key with read access to your tables.

  2. TablesViewsYour SQL
    Step 2

    Pick your fields

    Pick a table, or write your own SQL. Mammoth shows the rows before you save.

  3. Updated
    Step 3

    Send it to Google Sheets

    Pick a new or existing spreadsheet and a tab. Mammoth writes the rows after every refresh.

Start free and connect BigQuery14-day Pro trial · No credit card

Choose how Google Sheets updates

Your BigQuery data refreshes every day, or only when you ask. You can set a different schedule.

Google Sheets
WeekRegionOrdersRevenue
2026-W45North1,284$96,300
2026-W45South1,019$74,880
2026-W45West1,552$118,410
Replace

Clears the tab, then writes every row again.

Best for a current view, like this month's numbers.

Google Sheets
WeekRegionOrdersRevenue
2026-W45North1,284$96,300
2026-W45South1,019$74,880
2026-W46North1,331$99,020
Append

Adds new rows under the ones already there.

Best for a running log, like results by week.

A spreadsheet holds up to 10 million cells. For bigger data, use a Live link or a CSV file.

Clean and combine your BigQuery data first

Mammoth gets the data ready before it goes to Google Sheets.

Join

Add your other data

Join BigQuery with Salesforce, HubSpot, Xero or 100+ other sources.

Rows grouped by week and regionOld regions mapped to new names
Clean

Fix the data first

Remove duplicates, fill blanks and fix formats. The same fixes run every time.

Average order value = Revenue ÷ Orders
Calculate

Add the columns you need

Work out average order value, growth or share so they arrive ready to use.

What teams use BigQuery in Google Sheets for

  • Weekly business review

    The numbers leadership reads, in a sheet they already use.

  • Team trackers

    Each team's slice of the warehouse, in its own tab.

  • Finance models

    Warehouse totals feeding the planning spreadsheet.

Ways to get BigQuery data into Google Sheets

Mammoth

For BigQuery data in a sheet, joined with CRM or finance data.

  • ✓Updates on a schedule
  • ~Rows in the sheetUp to 10 million cells
  • ✓Join CRM or finance data that isn't in BigQuery
  • ✓Send the same data to Excel, Power BI or another warehouse

Connected Sheets

Made by Google. For working with BigQuery inside Sheets.

  • ✓Updates on a schedule
  • ~Rows in the sheetUp to 500,000 rows extracted
  • ✕Join CRM or finance data that isn't in BigQuery
  • ✕Send the same data to Excel, Power BI or another warehouse

Common questions about BigQuery to Google Sheets

How do I connect BigQuery to Google Sheets?
Connect BigQuery to Mammoth and pick the fields you want. Then export them to Google Sheets, and Mammoth keeps it up to date.
Does Google Sheets update automatically?
Yes. Your BigQuery data refreshes every day, or only when you ask. You can set a different schedule. After each refresh, Mammoth sends the new data to Google Sheets.
Can I add new rows instead of overwriting the sheet?
Yes. Choose Append and Mammoth adds rows under the data already in the tab. Replace clears the tab first.
Is there a size limit?
Google Sheets holds up to 10 million cells in a spreadsheet. For more than that, use a Live link or a CSV file.
What access does Mammoth need in BigQuery?
A service account with the BigQuery Data Viewer and BigQuery Job User roles. You upload its JSON key when you connect.

Step-by-step setup is in our docs for BigQuery and Google Sheets.

Keep Google Sheets up to date with BigQuery data.

Start free, connect BigQuery, and send it to Google Sheets.

  • ✓ 14-day Pro trial
  • ✓ No credit card
  • ✓ Viewers always free