Skip to content

GA4 to Google Sheets

Send GA4 data to Google Sheets automatically

Connect GA4 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. GA4
  2. Mammoth
  3. Google Sheets
    DateChannelSessionsConversions
    Nov 10Organic Search4,81296
    Nov 10Paid Search2,14071
    Nov 10Email90538
    Nov 11Organic Search4,977102

Shown on sample data.

Set up GA4 to Google Sheets in three steps

  1. Step 1

    Connect GA4

    Sign in with Google and pick the GA4 property to read.

  2. TrafficPagesEventsConversions
    Step 2

    Pick your fields

    Tick the report tables and the dimension and metric columns you want.

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

Choose how Google Sheets updates

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

Google Sheets
DateChannelSessionsConversions
Nov 10Organic Search4,81296
Nov 10Paid Search2,14071
Nov 10Email90538
Replace

Clears the tab, then writes every row again.

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

Google Sheets
DateChannelSessionsConversions
Nov 10Organic Search4,81296
Nov 10Paid Search2,14071
Nov 11Organic Search4,977102
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 GA4 data first

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

Join

Add your other data

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

Channel names grouped into 6Test traffic filtered out
Clean

Fix the data first

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

Conversion rate = Conversions ÷ Sessions
Calculate

Add the columns you need

Work out conversion rate, week or month so they arrive ready to use.

What teams use GA4 in Google Sheets for

  • Weekly traffic report

    Sessions and conversions by channel, current every Monday.

  • Landing page tracking

    Top pages by conversions, added to the sheet each day.

  • Marketing ROI

    GA4 conversions next to ad spend, in one tab.

Ways to get GA4 data into Google Sheets

Mammoth

For GA4 data in a sheet, joined with your ad spend and sales.

  • ✓Updates on a schedule
  • ✓Clean the data before it reaches the sheet
  • ✓Join ad spend or sales data
  • ✓Send the same data to Excel, Power BI or a warehouse

GA4 Reports Builder

Free, made by Google. For GA4 reports in a sheet.

  • ✓Updates on a schedule
  • ~Clean the data before it reaches the sheetWith filters
  • ~Join ad spend or sales dataGA4 only
  • ✕Send the same data to Excel, Power BI or a warehouse

Export from GA4 by hand

For a one-off copy of a report.

  • ✕Updates on a schedule
  • ~Clean the data before it reaches the sheetBy hand
  • ~Join ad spend or sales dataPasted in by hand
  • ✕Send the same data to Excel, Power BI or a warehouse

Or turn the same data into a GA4 dashboard

Describe the dashboard in one sentence and Mammoth builds it from your data.

The template: paste this into Mammoth

GA4 website performance: sessions, engaged sessions, engagement rate, key events, conversion rate and revenue as KPIs, a daily sessions and key events trend, sessions by channel, and key events by landing page

GA4 dashboard built in Mammoth, showing Sessions, Engaged sessions, Engagement rate, Key events, Conversion rate, Revenue
The dashboard Mammoth built from that sentence, on sample data.Open the live dashboard →

See the free GA4 dashboard template

Common questions about GA4 to Google Sheets

How do I connect GA4 to Google Sheets?
Connect GA4 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 GA4 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 GA4?
GA4 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 GA4 and Google Sheets.

Keep Google Sheets up to date with GA4 data.

Start free, connect GA4, and send it to Google Sheets.

  • ✓ 14-day Pro trial
  • ✓ No credit card
  • ✓ Viewers always free