App Icon
Download Google Analytics 4 data to Google Sheets. Schedule your Google Analytics 4 reports. You can also compare data from two periods and receive an email if major differences are found.
Listing updated:November 21, 2022
Works with:
50,334
Overview
This Google Sheets add-on helps you view and edit Google Analytics 4 data more easily in Google Sheets.

✔ Easy to use report configurator
✔ Schedule your reports to run and update automatically.
✔ Compare two periods and sort by the delta of the metrics.
✔ Receive an email when your report is ready.
✔ Easily create reports with data from multiple Google Analytics 4 properties.


► Create Google Analytics 4 reports
Reports can be created manually in the configuration sheet or using the add-on's 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 simple 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 report. You can also copy the information in the sheet to a new column and edit it in the sheet.

► Run Google Analytics 4 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
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 were the sales of a product dropped by more then 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 send email as you. This is only used to give you the possibility to automatically send delta reports to yourself or others by email. 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. We might introduce a subscription model in the future.

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/
Additional information
PricingNot available
Privacy policy
Terms of service
Reporting for Google Analytics 4 will ask for the permissions shown below. Learn more
Reporting for Google Analytics 4 will need access to your Google account
This will allow Reporting for Google Analytics 4 to :
See, edit, create, and delete all your Google Sheets spreadsheets
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
Send email as you
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
Loading
Search
Clear search
Close search
Google apps
Main menu