Connect Google Analytics 4 Data to Google Sheets


Automate your workflow and run your business on autopilot. Build custom apps in minutes with no code!

“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 Connect and Import GA4 Data to Google Sheets

You need a Google Sheets add-on. These add-ons are usually paid tools. 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.

This article shows three options on how to import Google Analytics to Google Sheets:
Option 1 is a FREE Google Sheets add-on.
Option 2 is a PAID Google Sheets add-on.
Option 3 is another PAID option that uses a third-party connector.

To connect GA4 to Google Sheets, most approaches use similar workflows:
Step 1: Install a Google Sheets Add-On
Step 2: Configure Settings
Step 3: Run the Configuration
Step 4: Save Data on Google Sheets

Option 1: Free Official Google Sheets Add-on

First option is to use the official GA4 Reports Builder for Google Analytics. This is free and is the only free option in this article.

Installing The Google Sheets Add-on

1 – Go to your Google Drive workspace.

2 – Click on + New then create a new Google Sheets file. Name your Google Sheets as well.

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 GA4 Reports Builder for Google Analytics. Then install it.

ga4 to sheets official 01

5 – Once installed, the add-on should be under Extensions.

ga4 to sheets official 02

Set Up GA4 Data Source

1 – Launch the add-on. Click on Extensions. Then click on GA4 Reports Builder for Google Analytics. Then click on Create new report. A navigation pane on the right side appears.

ga4 to sheets official 03

2 – Name your report.

3 – Select the Google Analytics Account and Property where you want to get data from.

4 – Select the appropriate dates from the dropdown.

Note: Make sure you’re familiar with the names and hierarchy of your GA4 setup.

ga4 to sheets official 04

4 – Under Dimensions, select the dimensions you want to import. In this example, add defaultChannelGroup.

5 – Under Metrics, select the metrics you want to import. In this example, add sessions and conversions.

ga4 to sheets official 05

5 – Click on Create Report.

Note: This doesn’t create the actual report just yet. This section only syncs up the data sources. The results looks like this:

ga4 to sheets official 06

Running GA4 Reports

This allows the API (application programming interface) to get data from GA4 without errors.

1 – At the top of your file, click on Extensions. Then click on GA4 Reports Builder for Google Analytics, then click on Run reports.

ga4 to sheets official 07

2 – If setup is correct, the API runs the query. You get a success notification. Click on OK.

ga4 to sheets official 08

A new Google Sheets tab is created, and that contains the report.

ga4 to sheets official 09

Running Other Google Analytics Reports

Of course there are cases where you want to run reports for other dimensions and metrics. This part becomes tricky since you need to replace some of the fields.

1 – Go back to Report Configuration sheets tab. This is where you replace some of the fields.

2 – For Start Date, change it based on your use case in YYYY-MM-DD format. In this example, use 2022-01-01 for January 01, 2022.

3 – For End Date, same thing. Change it based on your use case in YYYY-MM-DD format. In this example, use 2022-12-31 for December 31, 2022.

ga4 to sheets official 10

For Metrics and Dimensions, you need to consult and understand the API schema documentation of GA4.

4 – Under Metrics, you may add total users and bounce rate. These parameters are separated by comma.

sessions
conversions
totalUsers
bounceTate

5 – Under Dimensions, you may add Device category. These parameters are separated by comma.

defaultChannelGroup
deviceCategory

You may leave the Order and other fields untouched for now.

ga4 to sheets official 11

6 – At the top of your file, click on Extensions. Then click on GA4 Reports Builder for Google Analytics, then click on Run reports again.

ga4 to sheets official 07

7 – If setup is correct, the API runs the query. You get a success notification again. Click on OK.

ga4 to sheets official 08

8 – Go back to the sheets tab that contains the report. The sheet is now updated with new data points.

ga4 to sheets official 12

Viola! You imported your GA4 data to Google Sheets!

Option 2: Paid Google Sheets Add-On

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.

two minute reports 01

Installing a 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 GA4 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 GA4 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 GA4.

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 GA4 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 GA4 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 GA4 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 GA4. The number of Sessions and Conversions are now within reach. You can adjust the parameters depending on your use cases like Device category.

Schedule GA4 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.

Option 3: Third-Party Integration Tool

You’ll use Make for this option. Make is a powerful integration platform that allows you to visualize, design, and automate your work in minutes. In other words, it lets apps talk to each other so that you can remove repetitive tasks.

make 01c

Create a Make account and get started.

Getting Started

1 – Click on + Create a new scenario. This is where you start building the connection between tools.

make 02b

2 – Once inside, click on the HUGE circle with a PLUS SYMBOL.

make 03

3 – Search for Mailchimp. Then select Generate a Report. Then select Create a connection.

ga4 to sheets make 02

Take Note of Your GA4 Property ID

Before anything else, take note of your GA4 property ID. This is needed to integrate the scenarios in Make. Decide on your end which GA4 property you want to use.

Go to your GA4 account.

1 – Under ADMIN, click on Property Settings.

ga api python 23

2 – Remember and take note of the property ID from the right side. The number should be 9 digits. This is what you enter in Make.

ga api python 24

Setting Up GA4 Connection

1 – Under Connection click on Create a connection.

2 – Under Connection name, name the connection. The name is arbitrary so it’s up to you. But I suggest writing a descriptive name for later use.

3 – Under Property ID, enter the GA4 property ID of your choice.

4 – Click on Save.

A pop-up window appears.

ga4 to sheets make 03

5 – Inside the pop-up window, sign-in to the Google or Gmail account to give Make access to your Google Analytics data.

ga4 to sheets make 01

Back in Make, enter all necessary Dimensions and Metrics from GA4.

6 – Under Date Ranges, select the date range you need.

7 – Under Dimensions, select the data you need. Keep things simple and only get the important data.

Select the following for this example:
Session default channel group
Session source

8 – Under Metrics, select the data you need. Keep things simple and only get the important data.

Select the following for this example:
Sessions
Conversions

There are other advanced filters like Action attribution windows and Action breakdowns. For now, ignore these to proceed with the automation. You may go back to them later.

9 – Click on OK.

ga4 to sheets make 04

Done! At this point, you’re finished with the GA4 connection. Go back to the canvas and press right-click. Then select Add a module.

Setting Up Google Sheets Connection

Next is setting up the Google Sheets connection. But first, you need to go to Google Drive and create a new Google Sheets file.

1 – Go to your Google Drive workspace.

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

tmr 0
tmr 00

3 – Name the Google Sheets file. The name is arbitrary so it’s up to you. But I suggest writing a descriptive name for later use.

integromat 07 sheets

4 – Name the tab or sheet on the bottom. The name is arbitrary so it’s up to you. But I suggest writing a descriptive name for later use.

integromat 07 sheets2

5 – Name the headers. It’s helpful to map out the correct data point in the integration process later.

Column A
Column B
Column C
Column D

integromat 07 sheets3

The first steps are done! Go back to Make.

1 – Press right-click. Click on + Add a module. Or you can double-click then click on the HUGE circle with a PLUS SYMBOL.

2 – Search for Google Sheets. Then select Add a Row.

mailchimp sheets integromat 06

3 – Under Connection, click on Add or Create a connection.

4 – Name the connection. The name is arbitrary so it’s up to you. But I suggest writing a descriptive name for later use.

make 06 sheets

5 – Click on Continue or Sign-In. A pop-up window appears.

6 – Inside the pop-up window, select the Gmail account that stores the Google Sheets file.

make 04

7 – Click on Allow. Make asks permission to access your Google account. This is standard procedure. The window closes after clicking it.

make 05

Back in Make you add the additional parameters.

8 – Under Choose a Method, choose Select by path.

9 – Under Choose a Drive, select My Drive. The spreadsheet you created earlier is likely located here.

10 – Under Spreadsheet ID, select the Google Sheets file you created earlier. Find the name you gave it.

11 – Under Sheet Name, select the Google Sheets tab from earlier. Find the name you gave it.

12 – Under Table contains headers, select Yes.

After which, the Values are created.

make 07 sheets

13 – Under Values is where it gets tricky. The headings from the Google Sheets file are the parameters where you decide the values. Once you click on the field, you’re presented with different parameters. Don’t be overwhelmed. Read the context of the parameters to know which one is mapped to which.

integromat 07 sheets7

Under (A), select Session default channel group.
Under (B), select Session source.
Under (C), select Sessions.
Under (D), select Conversions.

The parameters that appear here are from the connection you added earlier. Other parameters are also available. Make sure to add an extra column and name it on the Google Sheets spreadsheet so on and so forth.

The parameters that appear here are from the connection you added earlier. Other parameters are also available. Make sure to add an extra column and name it on the Google Sheets spreadsheet so on and so forth.

14 – Click on Ok. Now it’s time to run and process the integration.

15 – Click on Run once with a play button icon.

make 08

A spinning wheel and a Log on the bottom right appear. Wait for the integration to finish. How long the integration takes depends on the Maximum number of results you select. It’s finished when a) green checkmarks appear, and when b) The scenario run was completed appears in the Log.

ga4 to sheets make 05

Go to your Google Sheets file and you now see the campaign data successfully exported from GA4. Viola! Congratulations you imported GA4 data to Google Sheets with complete information! You may also add other parameters or fields if you need them.

Schedule Automation and Reports

Make can schedule the automation based on cycles. The schedule is up to you.

1 – On the screen, click on the Scheduling button and turn it on.

make 08

2 – Under Run scenario, select the schedule you need. What you select on this parameter dictates the next ones.

If you select At regular intervals, you need to select the minutes that Make processes the automation.

If you select Once, you need to select the date.

If you select Every day, you need to select the time.

If you select Days of the week or Days of the week, you need to select the days.

make 09

3 – Click on Ok. Ignore any advanced settings for now.

Conclusion: Create GA4 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