Access all of your Google Analytics™ 4 data in Google Spreadsheets™.
Listing updated:June 22, 2024
Works with:
GA4 Magic Reports add-on helps you view and edit Google Analytics™ 4 data more easily in Google Sheets™.

★ Install the Google Sheets™ add-on
To use the GA4 Magic Reports add-on, you must first add it to your Spreadsheet.
You can go directly to the add-on in the Google Workspace™ Marketplace and install the add-on.

The add-on is then available in every Google Spreadsheet™ under “Extensions” menu.

★ Create GA4 reports
Select “Extensions” > “GA4 Magic Reports” > “Create new report” in the menu bar. This will display a sidebar on the right side with which you can easily create a report configuration selecting:

→ Google Analytics™ 4 Account and Property among those linked to your account;
→ Metics and Dimensions;
→ Metric filters;
→ Dimension filters;
→ Sorting information.

Then, click on the button “Create Report”, your report configuration will appear in the sheet called “GA4 Reports Configuration” (if this sheet does not already exist, it will be created).

You can go through these steps again to add another report or copy the information in the sheet to a new column and edit it in the sheet.
Not all cells are filled by the sidebar. The fields that are not filled by the sidebar can be entered in the sheet.

★ Run reports
Go to “Extensions” > “GA4 Magic Reports” > “Run reports” in the menu to run all the reports you have created.

★ Schedule reports to run automatically
Reports can be scheduled to run automatically. To do this, go to “Extensions” > “GA4 Magic Reports” > “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.

The schedule uses the time zone of the spreadsheet.

★ Report configuration options
Each field in the configuration file contains a note explaining what that feature is and how it can be used.

Google Analytics™ 4 is a trademark of Google LLC
Additional information
PricingFree of charge
Privacy policy
Terms of service
GA4 Magic Reports will ask for the permissions shown below. Learn more
GA4 Magic Reports will need access to your Google account
This will allow GA4 Magic Reports 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
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
Clear search
Close search
Google apps
Main menu