Import GA4 (Google Analytics 4) Data to Google Sheets

“How do I import GA4 data into Google Sheets?”
“How do I export from GA4 to Google Sheets?
“Is there a way to integrate Google Analytics 4 and Google Sheets?

Digital marketer

In 2020, Google introduced a new version of Google Analytics–Google Analytics 4 or GA4. It will lead the charge in web analytics and Google Analytics 3 (Universal Analytics) might be discontinued in the future. Since GA4 is a newcomer, there aren’t that much tools to integrate it with Google Sheets to export data.

ga4

You CAN import GA4 data from the API to Google Sheets. You do copy and paste, add new rows manually, until your eyes and fingers can’t take it anymore. It’s an unbearable nightmare and sucks the soul of marketers. This article teaches how to automate reporting step-by-step.

Note: This is for GA4 (Google Analytics 4), not Google Analytics 3 (Universal Analytics).

How To Import GA4 (Google Analytics 4) Data to Google Sheets

To connect Google Analytics 4 to Google Sheets, you need a Google Sheets add-on. These add-ons are usually paid add-ons. As mentioned, you can do it manually (for free) to save money. But in perspective, you might want to spend a little bit to save time. You choose.

two minute reports 01

Use Two Minute Reports in this use case. Two Minute Reports imports data from the GA4 API directly to Google Sheets in minutes. No required coding skills.

Installing The Google Sheets Add-on

1 – At the top of your Google Sheet, click on Add-ons. Then click on Get add-ons.

tmr 2

2 – Search for Two Minute Reports. Then install it.

tmr 1

3 – You now have the add-on installed on your Google Sheets file.

tmr 3

Import Google Analytics 4 Data Source

1 – Launch the add-on. A navigation pane on the right side appears.

tmr 15

2 – Click on Add + under Data Sources.

tmr 4

3 – Name your data source. Then select Google Analytics 4.

ga4 to sheets 01

4 – Sign-in to your Google Analytics 4 account.

ga4 to sheets 02

5 – Link your GA4 account to the tool. To be sure, allow and give full access to the tool for seamless integration.

Make sure the account you’re giving access to has access to Google Analytics 4.

6 – Go through the login process until the tool instructs you to close the tab since the sign-in is successful.

ga4 to sheets 03 template

Import Google Analytics 4 Data Query

This point in the process is importing data from the GA4 API to the spreadsheet.

1 – Click on the burger icon. Then click on Data Queries.

2 – Click on Add +.

tmr 11

3 – Name your data query. Then find the Google Analytics 4 data source you imported earlier.

4 – Save on Sheet is the location of the sheet where the data is imported to, so make you know what your tabs are named after. Add A1 under Cell in this example.

ga4 to sheets 04

5 – Under Query, select the GA4 account you want to get data from.

6 – Under Metrics, select the metrics you want to import. In this example, we use Sessions and Conversions.

7 – Under Dimensions, select the dimensions you want to import. In this example, we use Session medium, Session source, and Device category.

8 – Under Date, Select the date range to your use case. In this example, it’s the Last 6 months.

As for the Filters and other Data Options, you may leave them unticked or empty for now.

ga4 to sheets 05

9 – Click on the Run query button.

Viola! You imported your Google Analytics 4 data to Google Sheets much quicker! You can create reporting templates from here depending on your business needs.

ga4 to sheets 06

In this example, we imported data from Google Analytics 4. The number of Sessions and Conversions are now within reach. You can adjust the parameters depending on your use cases like Device category.

Schedule Google Analytics 4 Reports

Two Minute Reports has a scheduling function. This means the spreadsheet refreshes the acquired data from the API. Reports are automated even more.

1 – Click on the burger icon. Then click on Schedule Refresh.

2 – Click on New +.

tmr fb5

3 – Once inside, you can set the terms of the report schedule.

-Name
-Repeats: This is where you set how often the data refresh happens. Two Minute Reports can do hourly refreshes.
-Timezone

tmr li3

4 – You can also set the notification terms. Two Minute Reports can email you a PDF or Excel of the data. You can also decide to have the email contain the sheet content in the email body.

tmr fb7
tmr fb8

5 – Click on Save.

Scheduling helps when you need to report on GA4 events and engagements overtime. No more copy and paste every day, or every week, or every month.

More articles on automation:
Import GA4 data to Google Sheets
Import Shopify data to Google Sheets
Import Google Ads data to Google Sheets
Import WooCommerce data to Google Sheets
Import Google Analytics data to Google Sheets
Import Facebook Page Insights to Google Sheets
Import LinkedIn Ads API data to Google Sheets
Import Facebook Ads data to Google Sheets
Import Mailchimp data To Google Sheets
Export Gmail to Google Sheets
Import JSON to Google Sheets

Conclusion: Create Google Analytics 4 Reports Quicker

This is one of the options to connect data from GA4 to Google Sheets. These are the current methods (more in the future) to do API integrations between tools. These add-ons cost money, but the benefits outweigh more.

Avoid import and export spreadsheet hell. Maintain everything step-by-step in Google Sheets with tools if needed. Stop wasting time on repetitive tasks and start focusing on important things that impacts the business. Hire a web analyst to help you.


About The Author

Francis Angelo Reyes

Francis is the owner and runs Lupage Digital. With 5 years of experience, Francis writes everything he knows about digital marketing. There’s a large knowledge gap between developers and digital marketers. Francis is the middleman between where the non-technical and technical meet.