Skip to content

Facebook Ads to Google Sheets

Send Facebook Ads data to Google Sheets automatically

Connect Facebook Ads 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. Facebook Ads
  2. Mammoth
  3. Google Sheets
    CampaignImpressionsSpendPurchases
    Winter sale182,400$2,310141
    Lookalike 1%96,050$1,19062
    Retargeting41,780$64057
    New arrivals120,300$1,56073

Shown on sample data.

Set up Facebook Ads to Google Sheets in three steps

  1. Step 1

    Connect Facebook Ads

    Sign in to Facebook from Mammoth. There are no API keys to manage.

  2. CampaignsAd setsAdsInsights
    Step 2

    Pick your fields

    Tick the Ads Manager tables and columns you want, or ask for the data in plain words.

  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 Facebook Ads14-day Pro trial · No credit card

Choose how Google Sheets updates

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

Google Sheets
CampaignImpressionsSpendPurchases
Winter sale182,400$2,310141
Lookalike 1%96,050$1,19062
Retargeting41,780$64057
Replace

Clears the tab, then writes every row again.

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

Google Sheets
CampaignImpressionsSpendPurchases
Winter sale182,400$2,310141
Lookalike 1%96,050$1,19062
New arrivals120,300$1,56073
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 Facebook Ads data first

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

Join

Add your other data

Join Facebook Ads with Google Ads, GA4, Shopify or 100+ other sources.

Campaign names split into audience and offerSpend set to one currency
Clean

Fix the data first

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

ROAS = Purchase value ÷ Spend
Calculate

Add 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

Meta Ads dashboard built in Mammoth, showing Amount spent, Purchases, Purchase value, ROAS, Cost per purchase, CTR
The dashboard Mammoth built from that sentence, on sample data.Open the live dashboard →

See the free Facebook Ads dashboard template

Common questions about Facebook Ads to Google Sheets

How do I connect Facebook Ads to Google Sheets?
Connect Facebook Ads 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 Facebook Ads 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.
Why don't recent days match Ads Manager?
Facebook keeps correcting the last few days after it first reports them. Choose Replace all data so each refresh picks up the corrections.

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