“How do I import GA4 data into Google Sheets?”Digital marketer
“How do I export from GA4 to Google Sheets?
“Is there a way to integrate Google Analytics 4 and Google Sheets?
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.
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.
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 on + New then create a new Google Sheets file. Name your Google Sheets as well.
3 – At the top of your file, click on Extensions. Then click on Add-ons. Then click on Get add-ons.
4 – Search for Two Minute Reports. Then install it.
5 – You now have the add-on installed on your Google Sheets file.
Import Google Analytics 4 Data Source
1 – Launch the add-on. A navigation pane on the right side appears.
2 – Click on Add + under Data Sources.
3 – Name your data source. Then select Google Analytics 4.
4 – Sign-in to your Google Analytics 4 account.
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.
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 +.
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.
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.
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.
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 +.
3 – Once inside, you can set the terms of the report schedule.
-Repeats: This is where you set how often the data refresh happens. Two Minute Reports can do hourly refreshes.
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.
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 impact the business. Hire a web analyst to help you.