Access all of your Google Analytics™ 4 data in Google Spreadsheets™.
Listing updated:December 11, 2023
Works with:
22K+
Overview
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
Developer
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
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Sam Holt
October 11, 2023
Fantastic. Thank you. My only suggestion is to add a feature to the date range for a rolling period. For example, the previous 90 days.
Is this review helpful?
Yes
No
Profile Picture
44sunsets
December 4, 2023
Amazing add-on which does exactly everything we need it to do and is actually free, unlike many of the so-called "free" add-ons in the marketplace that expire after a few weeks and then require you to pay a hefty subscription fee. Is well documented and everything makes sense and is easy to use. And it even supports report scheduling (automatic data refreshing)! Thank you to Michele for all your hard work!
Is this review helpful?
Yes
No
Profile Picture
Dmitrii Terzioglo
October 31, 2023
Nice and easy to work with add-on. Thank you!
Is this review helpful?
Yes
No
Profile Picture
Jean Mugisha
November 22, 2023
This is very Useful thank you Michele!
Is this review helpful?
Yes
No
Profile Picture
Michael Chun Pong Cheung
June 1, 2023
This extension is awesome and so useful, even better than the one that you need to pay for.
Is this review helpful?
Yes
No
Profile Picture
Bill Denneen
March 7, 2023
A welcome addition. Thank you! Update: after a few days of using GA4 Magic Reports, I've changed my review to 5 stars. The more I use and understand GA4, the more I see just how valuable this tool is.
Is this review helpful?
Yes
No
Profile Picture
Ragnar Bjartur Gudmundsson
September 8, 2023
Bravissimo! This is just perfect.
Is this review helpful?
Yes
No
Profile Picture
Ben Claflin
July 25, 2023
Really wish you could use Segments with this tool! Otherwise it's great.
Is this review helpful?
Yes
No
Profile Picture
Luigi Ricco
June 29, 2023
This is quickly becoming my best friend. Thank you, Michele
Is this review helpful?
Yes
No
Profile Picture
Thuha Wright
January 15, 2024
Currently using it everyday. Thanks.
Is this review helpful?
Yes
No
1-10 of 13
Search
Clear search
Close search
Google apps
Main menu