Skip to content

Google Ads to Google Sheets

Send Google Ads data to Google Sheets automatically

Connect Google 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. Google Ads
  2. Mammoth
  3. Google Sheets
    CampaignClicksCostConversions
    Brand search3,204$1,880212
    Generic shoes5,911$6,420174
    Retargeting1,377$94088
    Performance Max4,086$4,115139

Shown on sample data.

Set up Google Ads to Google Sheets in three steps

  1. Step 1

    Connect Google Ads

    Sign in with Google and pick the Google Ads account to read. There are no keys to copy.

  2. CampaignsAd groupsAdsBudgets
    Step 2

    Pick your fields

    Tick the tables and columns you want, or ask for a report 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 Google Ads14-day Pro trial · No credit card

Choose how Google Sheets updates

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

Google Sheets
CampaignClicksCostConversions
Brand search3,204$1,880212
Generic shoes5,911$6,420174
Retargeting1,377$94088
Replace

Clears the tab, then writes every row again.

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

Google Sheets
CampaignClicksCostConversions
Brand search3,204$1,880212
Generic shoes5,911$6,420174
Performance Max4,086$4,115139
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 Google Ads data first

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

Join

Add your other data

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

Campaign names split into brand and typePaused campaigns filtered out
Clean

Fix the data first

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

Cost per conversion = Cost ÷ Conversions
Calculate

Add 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

Google Ads dashboard built in Mammoth, showing Total spend, Conversions, Conversion value, ROAS, Cost per conversion, CTR
The dashboard Mammoth built from that sentence, on sample data.Open the live dashboard →

See the free Google Ads dashboard template

Common questions about Google Ads to Google Sheets

How do I connect Google Ads to Google Sheets?
Connect Google 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 Google 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.
Which Google Ads accounts can I read?
Any open account your Google sign-in can see. Closed accounts are left out.

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