How to Connect Google Analytics (GA4) to Google Sheets

Published on

Google offers a free and official plugin, GA4 Reports Builder for Google Analytics™, available in the Google Workspace Marketplace. This plugin allows you to easily import Google Analytics 4 (GA4) data into Google Sheets, enabling more advanced data manipulation and visualization.

In this tutorial, you’ll learn how to install the GA4 Reports Builder plugin and import useful data, such as the Pages and Screens Engagement Report.

With Google Analytics, you can view reports, but importing data into Google Sheets offers more flexibility.

Why Import GA4 Data into Google Sheets?

Importing GA4 data into Google Sheets lets you:

  • Apply custom filters and sorting.
  • Create visualizations like heat maps and custom charts.
  • Use functions and pivot tables for more advanced analysis.
  • Automate reports and share them with your team.

Step 1: Install the GA4 Reports Builder for Google Analytics Plugin

Follow these steps to install the plugin:

  1. Open a new Google Sheets file by visiting sheets.new.
  2. Navigate to the Extensions menu and click Add-ons > Get add-ons.
  3. In the “Search apps” field, enter Google Analytics and press Enter.
  4. Find and select GA4 Reports Builder for Google Analytics™.
  5. Click the Install button and follow the on-screen instructions to complete the installation.

Step 2: Accessing the menu options in the GA4 Reports Builder for Google Analytics

Once the plugin is installed, follow these steps to access it:

  1. Navigate to the Extensions menu.
  2. Look for the newly added GA4 Reports Builder for Google Analytics menu item.
  3. Click it to see options like:
    • Create New Report
    • Run Reports
    • Schedule Reports
    • Help

Tip: If you don’t see the new menu item, try reloading the Google Sheets file.

Menu options for GA4 Reports Builder in Google Sheets

Step 3: Create a Report (Example: Last 10 Days of New Users by Page Title and Country)

To demonstrate how to use the plugin, we’ll create a report that shows the number of new users by page title and country for the last 10 days.

Report Configuration

Configured report from the GA4 Reports Builder in Google Analytics

The most important step in connecting Google Analytics GA4 to Google Sheets is configuring the report. Here’s how:

  1. Go to Extensions > GA4 Reports Builder for Google Analytics > Create New Report. This will open the Create Report sidebar.
  2. In the Report Name field, enter a name (e.g., “InfoInspired2”).
  3. From the Account drop-down, select the Google Analytics account you want to pull data from.
  4. Select the appropriate Property (the GA4 property for your website).
  5. In the Start Date field, select NdaysAgo, and enter 10 in the field below. This will fetch data from the last 10 days.
  6. In the End Date field, select Yesterday to ensure you’re getting data up to the most recent complete day.
  7. In the Dimensions drop-down, select Country and PageTitle to view data for each individual page on your site, categorized by country name.
  8. In the Metrics drop-down, select NewUsers to see the number of new users.
  9. You can leave the Filters section empty unless you want to narrow down the data further (e.g., filtering for specific pages or user demographics).
  10. Click the Create Report button.
GA4 Report Builder configuration settings to import new users by country for the last N days

Running the Report

Now that you’ve configured the report, it’s time to generate it:

  1. Go to Extensions > GA4 Reports Builder for Google Analytics > Run Reports.
  2. The plugin will create a new tab in your Google Sheet with the name you specified earlier (e.g., “InfoInspired2”), and the report will display data for the last 10 days.
Imported GA4 report displayed in Google Sheets

This is how you can easily import new users by page title and country from Google Analytics into Google Sheets.

Step 4: Scheduling Reports

One of the key features of the GA4 Reports Builder is the ability to schedule reports. This feature automates the process of running reports at regular intervals, so you don’t need to manually run them every time you want updated data.

How to Schedule Reports

  1. Go to Extensions > GA4 Reports Builder for Google Analytics > Schedule Reports.
  2. Choose how frequently you’d like the report to run:
    • Every Month
    • Every Week
    • Every Day
    • Every Hour
  3. After selecting the frequency, click Save.

This will ensure that your reports are automatically refreshed with the latest data based on your schedule, saving you time and ensuring up-to-date information for your analysis.

Summary

With the GA4 Reports Builder for Google Analytics plugin, you can seamlessly connect GA4 to Google Sheets, allowing you to create custom reports, automate data fetching, and perform in-depth analysis using Sheets’ advanced functions and visualization tools.

By following this tutorial, you’ve learned how to:

  • Install the GA4 Reports Builder plugin.
  • Configure and run reports.
  • Schedule reports for automated updates.

With these steps, you’re ready to take full advantage of Google Sheets to explore and analyze your GA4 data.

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Lookup Values Under Categories in Excel and Google Sheets

We can use a combination of XLOOKUP and VLOOKUP in both Excel and Google...

Extract Items Under a Category from the Same Column in Excel

In Excel, you can use a combination of the XLOOKUP and DROP functions to...

How to Create a Searchable Table in Excel Using the FILTER Function

Finding specific records, or rows containing the required information, is straightforward in Excel using...

Time Sequences in Excel by Minute, Hour, or Second Increments

Creating time sequences, whether by hour, minute, or second increments in Excel, can be...

More like this

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

Limit Formula Expansion to a Specific Row in Google Sheets

In this tutorial, I’ll explain how to limit the expansion of an array formula...

3-D Referencing Structured Data Tables in Google Sheets

When you have several tables within a single sheet—not across multiple sheets in a...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.