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) will be discontinued on July 1, 2023. Since GA4 is a newcomer, there aren’t that many 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).

Why Pay for Automation at All?

Automations solve huge problems in organizations. So, most automation tools are paid products. Yes, you can do everything manually for free to save money. But in perspective, you might want to spend a little to save time. The number of hours that you take back to avoid hellish and repetitive work is worth the price.

busy desktop

I hate a super cluttered desktop. You ever experienced a desktop full of spreadsheet files? I hate them. It increases stress and productivity comes to an all-time low. The amount of time I clicked the Export CSV button is unbearable. Automation avoids all of this and is useful when you’re tracking marketing campaigns.

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. Another Google Sheets add-on to use is Supermetrics.

Installing The Google Sheets Add-on

1 – Go to your Google Drive workspace.

2 – Click + New then create a new Google Sheets file.

tmr 0
tmr 00

3 – At the top of your file, click on Extensions. Then click on Add-ons. Then click on Get add-ons.

sheets 01

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

tmr 1

5 – You now have the extension installed on your Google Sheets file.

sheets tmr 01

Import Google Analytics 4 Data Source

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

sheets tmr 02

2 – Click on Add + under Data Sources.

tmr 16

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 overtime. No more copy and paste manual reports every day, or every week, or every month.

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 impact the business. Hire a web analyst to help you.


About The Author