GA4 Magic Reports: Google Sheets add-on

GA4 Magic Reports is a Google Sheets add-on that helps you to view and edit Google Analytics 4 data more easily in Google Sheets.

GA4 Magic Reports
GA4 Magic report – Configuration sheet

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.

GA4 Magic Reports – Report Status

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.
GA4 Magic Reports – Schedule reports

The schedule uses the time zone of the spreadsheet.


This Google Sheets add-on uses the Google Analytics data API. The use of this API is limited by Google. Here you can see which quotas apply:

GA4 Magic Reports – Report showing Quotas

Report configuration options

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


You can use this Google Sheets add-on for free. For more information please visit our terms and conditions and privacy policy.

Having trouble with the add-on?

Try to find the solution here: GA4 Magic Reports: FAQs, biases and common errors