BigQuery to Google Sheets
Send BigQuery data to Google Sheets automatically
BigQuery
- Mammoth
Google Sheets
Week Region Orders Revenue 2026-W45 North 1,284 $96,300 2026-W45 South 1,019 $74,880 2026-W45 West 1,552 $118,410 2026-W46 North 1,331 $99,020
Shown on sample data.
Set up BigQuery to Google Sheets in three steps
- Step 1
Connect BigQuery
Upload a Google Cloud service account key with read access to your tables.
- TablesViewsYour SQLStep 2
Pick your fields
Pick a table, or write your own SQL. Mammoth shows the rows before you save.
Updated
Step 3Send it to Google Sheets
Pick a new or existing spreadsheet and a tab. Mammoth writes the rows after every refresh.
Choose how Google Sheets updates
Your BigQuery data refreshes every day, or only when you ask. You can set a different schedule.
| Week | Region | Orders | Revenue |
|---|---|---|---|
| 2026-W45 | North | 1,284 | $96,300 |
| 2026-W45 | South | 1,019 | $74,880 |
| 2026-W45 | West | 1,552 | $118,410 |
Clears the tab, then writes every row again.
Best for a current view, like this month's numbers.
| Week | Region | Orders | Revenue |
|---|---|---|---|
| 2026-W45 | North | 1,284 | $96,300 |
| 2026-W45 | South | 1,019 | $74,880 |
| 2026-W46 | North | 1,331 | $99,020 |
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.
Add your other data
Join BigQuery with Salesforce, HubSpot, Xero or 100+ other sources.
Fix the data first
Remove duplicates, fill blanks and fix formats. The same fixes run every time.
Average order value = Revenue ÷ OrdersAdd 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?
Does Google Sheets update automatically?
Can I add new rows instead of overwriting the sheet?
Is there a size limit?
What access does Mammoth need in BigQuery?
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