GA4 to Google Sheets
Send GA4 data to Google Sheets automatically
GA4
- Mammoth
Google Sheets
Date Channel Sessions Conversions Nov 10 Organic Search 4,812 96 Nov 10 Paid Search 2,140 71 Nov 10 Email 905 38 Nov 11 Organic Search 4,977 102
Shown on sample data.
Set up GA4 to Google Sheets in three steps
- Step 1
Connect GA4
Sign in with Google and pick the GA4 property to read.
- TrafficPagesEventsConversionsStep 2
Pick your fields
Tick the report tables and the dimension and metric columns you want.
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 GA4 data refreshes every day, or only when you ask. You can set a different schedule.
| Date | Channel | Sessions | Conversions |
|---|---|---|---|
| Nov 10 | Organic Search | 4,812 | 96 |
| Nov 10 | Paid Search | 2,140 | 71 |
| Nov 10 | 905 | 38 |
Clears the tab, then writes every row again.
Best for a current view, like this month's numbers.
| Date | Channel | Sessions | Conversions |
|---|---|---|---|
| Nov 10 | Organic Search | 4,812 | 96 |
| Nov 10 | Paid Search | 2,140 | 71 |
| Nov 11 | Organic Search | 4,977 | 102 |
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.
Add your other data
Join GA4 with Google Ads, Facebook Ads, Shopify or 100+ other sources.
Fix the data first
Remove duplicates, fill blanks and fix formats. The same fixes run every time.
Conversion rate = Conversions ÷ SessionsAdd 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

Common questions about GA4 to Google Sheets
How do I connect GA4 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 GA4?
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