Reports Builder Google Sheets add-on Stay organized with collections Save and categorize content based on your preferences.

Use the Reports Builder for Google Analytics Google Sheets add-on to create and run reports for Google Analytics properties using Google Sheets. This add-on lets you pull Google Analytics data directly into your spreadsheet using either natural language or manual configuration.

Install the add-on

Here's what you'll need before you can start using the add-on.

1. Install the Reports Builder for Google Analytics Google Sheets add-on from the Google Workspace Marketplace.

   You can also access the add-on store listing through the Google Sheets menu by selecting Extensions > Add-ons > Get add-ons, and searching for Reports Builder for Google Analytics.

2. Open the add-on listing, and click Install to install the add-on.

3. Follow the prompt to complete the installation process.

4. After you've finished installing the add-on, create a new Google Sheet. You will find the add-on under Extensions > GA4 Report Builder for Google Analytics in the menu.

   [Activate the add-on]

How the tool works

After you've installed the Google Sheets add-on, you can create a report configuration and run the report.

Create a new report

To invoke the report configuration dialog, select the Create new report option from the add-on menu.

[Create a new report]

Select your data source

Account: To begin the report configuration, select an account from the Account drop-down menu, which is prepopulated with the list of Google Analytics accounts available to the signed-in user.

Property: Use the Property dropdown to select the specific web or app property you want to analyze.

[Select a Data Source]

Configure your report (two methods)

Method A: Use Gemini (AI-assisted)

1. Locate the Natural language query box.

2. Type your request in your language. For example:

Visitors by country and browser for the past quarter, in descending order. Limited to the USA, Germany, and Brazil

1. Click Create Query with Gemini. The add-on will automatically populate the dimensions, metrics, and date ranges for you.

[Gemini]

Method B: Manual Setup

• Report Name: Give your report a brief descriptive title.

  [Report Name]

• Date Range: Select from presets like NdaysAgo or today, or enter specific dates.

  [Date Range]

• Dimensions: Add dimensions like Country or Browser to categorize your data.

  [Dimensions]

• Metrics: Add quantitative metrics like activeUsers or screenPageViews.

  [Metrics]

• Order By: (Optional) Choose to sort your results by a specific metric or dimension in ascending or descending order.

  [Order By]

• Dimension Filters: (Optional) Limit your data to specific criteria. For example, only show data where the Country is "United States, Germany, or Brazil".

  [Dimension Filters]

• Metric Filters: (Optional) Add logic to show only those rows that meet certain numerical thresholds.

  [Metric Filters]

Finalize and run

Save Report Configuration: Saves your settings so you can run this specific report again later. A new report configuration will be added to the "Report Configuration" sheet.

Run Report: Executes the query and imports the data directly into your Google Sheet. If a sheet matching the report's name does not exist, it will be created by the add-on.

Reset: Clears all current fields to start a new configuration from scratch.

Run all stored reports

You can run all reports from the "Reports configuration" sheet using the Run reports option from the add-on menu. A new sheet is created for each report configuration and updated every time the report is run.

[Report output]