Google Ads to Google Sheets
Send Google Ads data to Google Sheets automatically
Google Ads
- Mammoth
Google Sheets
Campaign Clicks Cost Conversions Brand search 3,204 $1,880 212 Generic shoes 5,911 $6,420 174 Retargeting 1,377 $940 88 Performance Max 4,086 $4,115 139
Shown on sample data.
Set up Google Ads to Google Sheets in three steps
- Step 1
Connect Google Ads
Sign in with Google and pick the Google Ads account to read. There are no keys to copy.
- CampaignsAd groupsAdsBudgetsStep 2
Pick your fields
Tick the tables and columns you want, or ask for a report in plain words.
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 Google Ads data refreshes every day, or only when you ask. You can set a different schedule.
| Campaign | Clicks | Cost | Conversions |
|---|---|---|---|
| Brand search | 3,204 | $1,880 | 212 |
| Generic shoes | 5,911 | $6,420 | 174 |
| Retargeting | 1,377 | $940 | 88 |
Clears the tab, then writes every row again.
Best for a current view, like this month's numbers.
| Campaign | Clicks | Cost | Conversions |
|---|---|---|---|
| Brand search | 3,204 | $1,880 | 212 |
| Generic shoes | 5,911 | $6,420 | 174 |
| Performance Max | 4,086 | $4,115 | 139 |
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 Google Ads data first
Mammoth gets the data ready before it goes to Google Sheets.
Add your other data
Join Google Ads with GA4, Facebook Ads, Shopify or 100+ other sources.
Fix the data first
Remove duplicates, fill blanks and fix formats. The same fixes run every time.
Cost per conversion = Cost ÷ ConversionsAdd the columns you need
Work out cost per conversion, ROAS or week so they arrive ready to use.
What teams use Google Ads in Google Sheets for
Daily spend tracker
Spend and conversions by campaign, current every morning.
Client reports
One tab per client account, ready before the call.
Budget pacing
Spend to date against the monthly budget.
Ways to get Google Ads data into Google Sheets
Mammoth
For Google Ads data in a sheet, joined with GA4 and sales.
- ✓Updates on a schedule
- ✓Clean the data before it reaches the sheet
- ✓Join GA4, Facebook Ads or sales data
- ✓Send the same data to Excel, Power BI or a warehouse
Google Ads add-on
For Google Ads reports in a sheet.
- ~Updates on a scheduleRefresh from the sheet
- ✕Clean the data before it reaches the sheet
- ~Join GA4, Facebook Ads or sales dataGoogle Ads only
- ✕Send the same data to Excel, Power BI or a warehouse
Download a report by hand
For a one-off copy of the numbers.
- ✕Updates on a schedule
- ~Clean the data before it reaches the sheetBy hand
- ~Join GA4, Facebook Ads or sales dataPasted in by hand
- ✕Send the same data to Excel, Power BI or a warehouse
Or turn the same data into a Google Ads dashboard
Describe the dashboard in one sentence and Mammoth builds it from your data.
The template: paste this into Mammoth
Google Ads performance: total spend, conversions, conversion value, ROAS, cost per conversion and CTR as KPIs, a daily spend and conversion value trend, conversion value by campaign, and conversion value by campaign type

Common questions about Google Ads to Google Sheets
How do I connect Google Ads to Google Sheets?
Does Google Sheets update automatically?
Can I add new rows instead of overwriting the sheet?
Is there a size limit?
Which Google Ads accounts can I read?
Step-by-step setup is in our docs for Google Ads and Google Sheets.
Keep Google Sheets up to date with Google Ads data.
Start free, connect Google Ads, and send it to Google Sheets.
- ✓ 14-day Pro trial
- ✓ No credit card
- ✓ Viewers always free