< All Topics
Print

Importing Google Analytics (GA4) Data

PostedFebruary 1, 2025
UpdatedFebruary 3, 2025
ByAnas Kakuwala

Importing Google Analytics (GA4) Data into Google Sheets

This guide will walk through how to pull data from the Google Analytics (GA4) API and put it directly into Google Sheets.
No API Key necessary. Use OAuth to seamlessly connect to Google Analytics via Phlorin’s built-in integration in Google Sheets

Getting Started

Install the API solution add-on from Google Marketplace.

Begin by connecting your Google Analytics (GA4) Data with Phlorin Google

To request data from Google Analytics you must first connect your account with Phlorin. This can be done directly with Phlorin’s built in integration. Begin by opening up the Phlorin extension in Google Sheets.

1. In your desired Sheets document, open Phlorin and create a new request: Extensions > Phlorin > Open > Create a request

2. In the Application dropdown select or search for Google Analytics (GA4).

3. From here we will begin with Authorization. Click Connect to Google Analytics.

4. A new window will open and you will be asked to authorize the connection. Click Allow.

5. After the connection is established you can return to Google Sheets to begin pulling data.

Pull Google Analytics (GA4) Data into Google Sheets

While connected you can now use Phlorin to pull data seamlessly into Google Sheets. To do so we need to select an endpoint, path parameters, and body parameters.

1. For Endpoint select “Run Google Analytics (GA4 report).”

2. Under Path parameters you may select up to several properties from a built-in dropdown list. These are the G4 properties listed under your Analytics account.

3. Next, under body parameters input data for dataRTanges, dimensions, and metrics:

dateRanges; input the date range for data you are reporting.

dimensions; Check out GA4’s documentation for Dimensions

This examples uses eventName, date, and sessionDefaultChannelGroup.

metrics; Check out GA4’s documentation for Metrics

This examples uses eventCount.

4. Optionally, you may set the other parameters (filter, limit, orderBys) to manipulate how or what data is viewed. This is not required.

5.Lastly, make sure your desired sheet is selected, name the report, and click Run.

Need help creating your request?

Reach out to us: Contact support or join our community forum.

Documentation

Google Analytics Data (GA4) documentation: https://developers.google.com/analytics/devguides/reporting/data/v1/basics

Google Analytics Admin documentation: https://developers.google.com/analytics/devguides/config/admin/v1

Phlorin