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](https://workspace.google.com/u/0/marketplace/app/ga4_reports_builder_for_google_analytics/589269949355)
   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](https://sheets.new/). You will find the add-on
   under *Extensions \> GA4 Report Builder for Google Analytics™* in the menu.

   ![Activate the add-on](https://developers.google.com/static/analytics/devguides/reporting/data/v1/sheets-addon/images/activate.png)

## 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](https://developers.google.com/static/analytics/devguides/reporting/data/v1/sheets-addon/images/create-report-menu.png)

#### 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](https://developers.google.com/static/analytics/devguides/reporting/data/v1/sheets-addon/images/select-data-source.png)

#### 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](https://developers.google.com/static/analytics/devguides/reporting/data/v1/sheets-addon/images/report-name.png)
- **Date Range:** Select from presets like *NdaysAgo* or *today*, or enter
  specific dates.

  ![Date Range](https://developers.google.com/static/analytics/devguides/reporting/data/v1/sheets-addon/images/date-range.png)
- **Dimensions:** Add dimensions like `Country` or `Browser` to categorize
  your data.

  ![Dimensions](https://developers.google.com/static/analytics/devguides/reporting/data/v1/sheets-addon/images/dimensions.png)
- **Metrics:** Add quantitative metrics like `activeUsers` or `screenPageViews`.

  ![Metrics](https://developers.google.com/static/analytics/devguides/reporting/data/v1/sheets-addon/images/metrics.png)
- **Order By:** (Optional) Choose to sort your results by a specific
  metric or dimension in ascending or descending order.

  ![Order By](https://developers.google.com/static/analytics/devguides/reporting/data/v1/sheets-addon/images/order-by.png)
- **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](https://developers.google.com/static/analytics/devguides/reporting/data/v1/sheets-addon/images/dimension-filters.png)
- **Metric Filters:** (Optional) Add logic to show only those rows that meet
  certain numerical thresholds.

  ![Metric Filters](https://developers.google.com/static/analytics/devguides/reporting/data/v1/sheets-addon/images/metric-filters.png)

#### 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](https://developers.google.com/static/analytics/devguides/reporting/data/v1/sheets-addon/images/report.png)