Facebook Ads to Google Sheets
Send Facebook Ads data to Google Sheets automatically
Facebook Ads
- Mammoth
Google Sheets
Campaign Impressions Spend Purchases Winter sale 182,400 $2,310 141 Lookalike 1% 96,050 $1,190 62 Retargeting 41,780 $640 57 New arrivals 120,300 $1,560 73
Shown on sample data.
Set up Facebook Ads to Google Sheets in three steps
- Step 1
Connect Facebook Ads
Sign in to Facebook from Mammoth. There are no API keys to manage.
- CampaignsAd setsAdsInsightsStep 2
Pick your fields
Tick the Ads Manager tables and columns you want, or ask for the data 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 Facebook Ads data refreshes every day, or only when you ask. You can set a different schedule.
| Campaign | Impressions | Spend | Purchases |
|---|---|---|---|
| Winter sale | 182,400 | $2,310 | 141 |
| Lookalike 1% | 96,050 | $1,190 | 62 |
| Retargeting | 41,780 | $640 | 57 |
Clears the tab, then writes every row again.
Best for a current view, like this month's numbers.
| Campaign | Impressions | Spend | Purchases |
|---|---|---|---|
| Winter sale | 182,400 | $2,310 | 141 |
| Lookalike 1% | 96,050 | $1,190 | 62 |
| New arrivals | 120,300 | $1,560 | 73 |
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 Facebook Ads data first
Mammoth gets the data ready before it goes to Google Sheets.
Add your other data
Join Facebook Ads with Google Ads, GA4, Shopify or 100+ other sources.
Fix the data first
Remove duplicates, fill blanks and fix formats. The same fixes run every time.
ROAS = Purchase value ÷ SpendAdd the columns you need
Work out ROAS, cost per purchase or week so they arrive ready to use.
What teams use Facebook Ads in Google Sheets for
Daily spend tracker
Spend and purchases by campaign, current every morning.
Client reports
One tab per ad account, ready before the call.
All ads in one sheet
Facebook next to Google Ads, with one total.
Ways to get Facebook Ads data into Google Sheets
Mammoth
For Facebook Ads data in a sheet, joined with your other channels.
- ✓Updates on a schedule
- ✓Clean the data before it reaches the sheet
- ✓Join Google Ads, GA4 or store data
- ✓Send the same data to Excel, Power BI or a warehouse
Export from Ads Manager by hand
For a one-off copy of a report.
- ✕Updates on a schedule
- ~Clean the data before it reaches the sheetBy hand
- ~Join Google Ads, GA4 or store dataPasted in by hand
- ✕Send the same data to Excel, Power BI or a warehouse
Or turn the same data into a Facebook Ads dashboard
Describe the dashboard in one sentence and Mammoth builds it from your data.
The template: paste this into Mammoth
Meta Ads performance: amount spent, purchases, purchase value, ROAS, cost per purchase and CTR as KPIs, a daily spend and purchase value trend, purchase value by campaign, and purchase value by ad set

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