Getting data into Google Sheets

Get Google Analytics 4 data into Google Sheets

Four ways, from a one-off export to a report that keeps itself current.

Last checked 25 Sep 2026

About the Google Analytics 4 connector

There are four ways to get GA4 data into a Google Sheets spreadsheet. Three are free and built by Google. The fourth keeps itself up to date.

1. Export a report from GA4

1. Open a report in GA4.
2. Click Share this report, at the top right.
3. Click Download File, then Export to Google Sheets.

If you've customised the report, save it first: the export option doesn't appear until you do. Exports go up to 100,000 rows, you need at least Viewer access to the property, and what you get is a snapshot that won't update.

Source: GA4 report export, Google Analytics Help.

GA4 can also email a report on a schedule, from Share this report, then Schedule email. That sends a PDF or CSV file, not an updated spreadsheet.

Source: Scheduled emails, Google Analytics Help.

2. Export an exploration

Explorations are where you build your own tables in GA4, with the dimensions and metrics you choose.

1. Open the exploration.
2. Click Export data, at the upper right, and choose Google Sheets.

It exports everything in the visualisation, which can be more than you can see on screen. Explorations over 10 million events are based on a sample rather than every event. Again, it's a snapshot.

Source: Exploration export, Google Analytics Help.

3. Google's free Reports Builder add-on

Google publishes a free add-on that pulls GA4 data into a spreadsheet when you ask it to.

1. In Google Sheets, click Extensions, then Add-ons, then Get add-ons.
2. Search for Reports Builder for Google Analytics, and install it.
3. From Extensions, open the add-on and create a new report: pick the property, date range, dimensions and metrics.
4. Run the report from the same menu whenever you want fresh figures.

It's a solid option if you're happy to press run yourself each time.

Source: Reports Builder for Google Analytics, Google Workspace Marketplace and Google Analytics developer documentation.

4. A report that keeps itself current, with Fresh Sheets

Fresh Sheets writes a GA4 report into a tab of its own and refreshes it on the schedule you choose, so the figures are already there when you open the file.

1. Add Fresh Sheets and connect. Install Fresh Sheets from the Google Workspace Marketplace, open a spreadsheet, and choose Fresh Sheets, then Open sidebar. Click Connect this spreadsheet and sign in with your Google account. That's all GA4 needs; there's no separate key.
2. Build the report. In the sidebar, choose Google Analytics 4. Your GA4 property is picked for you; if you have several, check it's the right one. Pick your fields, including your own custom dimensions, custom metrics and key events, or start from a template.
3. Choose the date range, the tab, and how often it refreshes. Date ranges can roll forward (last 7 days, last complete month and so on), stay fixed, or be read from cells in your spreadsheet.

Fresh Sheets replaces that tab's contents on every refresh, so keep your own formulas on another tab. If a report is too large to fetch in one go, the tab says so rather than quietly leaving rows out, and if Google samples the data or rolls rows into (other), your Reports page says so.

Before you trust the numbers

Whichever route you use, GA4 has a few habits worth knowing.

• Sampling. Large explorations are based on a sample of events, not every one.
• The (other) row. When a report has too many different values, GA4 groups the rest into a single row called (other).
• Thresholding. With Google signals turned on, GA4 can hold back small numbers to protect people's identity.
• Freshness. Daily data takes around 12 hours to process, and figures can keep changing for 24 to 48 hours. Yesterday isn't quite final until the day after.

Sources: sampling, the (other) row, thresholding and data freshness, Google Analytics Help.

More on what Fresh Sheets reads from GA4 is on the Google Analytics 4 connector page.