Download Google Analytics™ 4 data to Google Sheets™. Easily configure, edit and schedule your GA4 reports. Simplify your data analysis process with our user-friendly add-on.
Listing updated:February 27, 2024
Works with:
74K+
Overview
This Google Sheets™ add-on offers the easiest way to view and edit Google Analytics 4 data in Google Sheets™. Simplify your data analysis process with our user-friendly add-on.

Key features of this Google Sheets™ add-on:
✔ Easy-to-use Google Analytics 4 report configurator.
✔ Schedule your reports to update automatically.
✔ Receive an email when your report is ready.
✔ Compare two periods and sort by the delta of the metrics.
✔ Create complex and nested filters in the sidebar.
✔ Edit reports with the sidebar or in the sheet with our easy-to-use syntax.

This add-on provides support for unlimited GA4 properties and reports, up to hourly automated refreshes, and email support. Only Google's quotas and Sheets limits apply. 

► Create GA4 reports
Reports can be created manually in the configuration sheet or using the add-ons sidebar. To use the sidebar, select "Extensions'' > "Reporting for Google Analytics 4" > "Create report" in the menu bar.
This will display a sidebar on the right side with which you can easily create a report configuration. The sidebar helps with the following:
✔ Look up Google Analytics™ 4 account and property information.
✔ Selecting dimensions and metrics. Including custom metrics, dimensions,  events and conversions.
✔ Apply metric and dimension filters.
✔ Determine the sorting of the report.

When you are done, click on the button "Add report to sheet" and your report configuration will appear in the sheet called “Configuration GA4 reports” (if this sheet does not already exist, it will be created).

You can go through these steps again to add another GA4 report. You can also edit the reports in the sheet or copy the information in the sheet to a new column to create a new report.

► Edit Google Analytics™ 4 reports
There are two ways to edit reports after you have created them. Through the add-on menu, you can select 'Manage reports'. A sidebar will open with a list of the reports currently in your sheet. You can click the edit option for the report you wish to edit and the sidebar will display your current report configuration. You can make adjustments in the sidebar and save the report configuration to the sheet.
Another option is to edit the report configuration directly in the sheet.

► Delete Google Analytics™ 4 reports
There are two ways to delete reports after you have created them. Through the add-on menu, you can select 'Manage reports'. A sidebar will open with a list of the reports currently in your sheet. You can click the delete option for the report you wish to delete. After you confirm your intention to delete the report, the report configuration will be removed from your sheet.
Another option is to delete the report configuration directly in the sheet.

► Easy to use filter expressions
You can create filters with the sidebar. But you can also create or edit filters directly in the spreadsheet:

Example 1: sessions__>__30
This will filter you report to only include rows with more than 30 sessions.

Example 2: sessionSource__contains__google
This will filter your report to only include rows with google in the sessionSource.

Visit this url for the full documentation on writing filters: https://adformatic.com/en/reporting-for-google-analytics-4/#filter-as-text-expression

► Run GA4 reports
Go to "Extensions" > "Reporting for Google Analytics 4" > "Run reports" in the menu to run all the reports you have created.

► Schedule Google Analytics™ 4 reports to run automatically
Reports can be scheduled to run automatically. To do this, go to "Extensions" > "Reporting for Google Analytics 4" > "Schedule Reports".
A dialog will open in which you can indicate three things:

✔ Turning a schedule on and off.
✔ Choose the frequency, day and time.
✔ Set whether you want to receive an email if the execution of a report fails.


► Compare date ranges in Google Analytics™ 4
You can compare two date ranges. The add-on will show the results sorted on the delta of the first metric. The delta is the difference between the periodes.
You can add a minimum for the delta, which acts as a filter on the delta column. For instance, you can choose to only include rows where the difference of the sessions between the two periods is higher than 100. 
Or only include rows where the sales of a product dropped by more than 10.
You can then enter your email address to receive an email (e.g.) each monday that gives you the top products that lost sales compared to the week before.


This add-on requires access to your Google Analytics™ 4 property. Your Google Analytics data is safe with Google and is never seen by Adformatic.  This add-on asks permission to run when you're not there. This only happens on the schedule you set. If you don't set a schedule the add-on only runs when you manually run it.

Note: You can use this Google Sheets™ add-on "Reporting for Google Analytics 4" for free for 14 days. If you wish to continue using the add-on after the free trial period, please subscribe here: https://portal.adformatic.com/subscribe/reporting-for-google-analytics-4

By installing this add-on, you agree to Adformatic's:
- Terms and conditions: https://adformatic.com/en/terms-and-conditions/
- Privacy Statement: https://adformatic.com/en/privacy/


Google Analytics™ is a trademark of Google LLC
Google Sheets™ is a trademark of Google LLC
Additional information
PricingFree of charge trial
Privacy policy
Terms of service
GA4 - Reporting for Google Analytics 4 will ask for the permissions shown below. Learn more
GA4 - Reporting for Google Analytics 4 will need access to your Google account
This will allow GA4 - Reporting for Google Analytics 4 to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
See and download your Google Analytics data
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Gordon Tebbutt
October 5, 2023
Best thing since Google Analytics took away the Google Sheets plugin. Works flawlessly and has saved me a massive headache with GA4. Highly recommended.
Is this review helpful?
Yes
No
Profile Picture
Robert Knasmüller
January 16, 2024
Wenn man in GA-4 gute Reports erstellen will, muss man sowohl leidensfähig als auch geduldig sein. Ich bin das nicht in ausreichender Form, daher bin ich von der Adformatic-Lösung begeistert. Mit dieser Extension kann man auch Search Console Daten auswerten und mit GA-4-Daten verbinden. Da rund 50 Prozent der User das Tracking via Cookie Consent ablehnen, ist GA-4 als alleinige Quelle nicht zielführend. Nur in Verbindung mit den Daten der Search Console kann die realistische Anzahl von Sitzungen, Seitenaufrufen etc. ermittelt werden. Mit der GA-4 Extension von Adformatic geht das hervorragend.
Is this review helpful?
Yes
No
Profile Picture
M Gray
August 29, 2023
THIS IS NOT A FREE APP, DO NOT INSTALL UNLESS YOU ARE WILLING TO PAY. This app uses extremely deceptive tactics to hide that it is only free for 14 days after that you have to pay to use it.
Is this review helpful?
Yes
No
Profile Picture
Daniela Patta
September 28, 2023
WORKS GREAT! AND SUPER, FAST SUPPORT TEAM. LOVE IT!!!!
Is this review helpful?
Yes
No
Profile Picture
Aditi Singh
January 16, 2024
the only useful app for GA4 with sheets. works perfectly!
Is this review helpful?
Yes
No
Profile Picture
Keir Gibson
January 15, 2024
Really useful tool with great customer support
Is this review helpful?
Yes
No
Profile Picture
Intergrowth Admin
June 15, 2023
We're using this tool to cut the time it takes to audit client metrics in half. Their team is extremely responsive and has built a high-quality app. We highly recommend it!
Is this review helpful?
Yes
No
Profile Picture
Alfredo Silva
December 19, 2022
I used the add-on for Google Sheets and I have to say that I'm extremely impressed. The easy-to-use report configurator makes it a breeze to create custom reports, and the ability to schedule these reports to run and update automatically is a game changer. The option to compare two periods and sort by the delta of metrics is particularly useful for tracking performance over time. I also appreciate that I can receive an email notification when my report is ready, which saves me the hassle of constantly checking for updates.
Is this review helpful?
Yes
No
Profile Picture
Matt Howard
July 10, 2023
Help? The add on always gives me an error in google sheets when trying to do anything that says: "403. That’s an error. We're sorry, but you do not have access to this page. That’s all we know." Thanks.
Is this review helpful?
Yes
No
Profile Picture
Sumit Sarkar
August 1, 2023
It's providing the same data as the google query explorer. But getting the actual GA4 complete data is still remaining. Moreover this tool provide good interface with better UI than others.
Is this review helpful?
Yes
No
1-10 of 21
Search
Clear search
Close search
Google apps
Main menu