Google Analytics 4 Export Setup Guide

Follow our setup guide to connect Google Analytics 4 Export to Fivetran.

Prerequisites

To connect your Google Analytics 4 Export account to Fivetran, you need:

• A Google Analytics 4 account
• A Google Cloud Platform role with sufficient permissions to provision IAM roles for BigQuery access and Storage Object creation (Bigquery Job User role for Project, BigQuery Data Viewer role for DatasetId, and Storage Object Admin role for BucketName)

Setup instructions

Find Fivetran email

In your connector setup form, make a note of the unique auto-generated email address at the bottom of the setup form (for example, g-generated-account@fivetran-production.iam.gserviceaccount.com). You will need this email to configure your source system to sync with Fivetran.

NOTE: The auto-generated email is tied to your account. If you close and re-open the setup form, the email will remain the same. You may wish to keep the tab open in the background while you configure your source for convenience, but closing it is also OK.

Configure BigQuery export for GA4Export

Follow Google's step-by-step instructions to configure BigQuery export for Google Analytics 4 Export.

Find BigQuery Project ID and Dataset ID

1. In your Google Cloud Console, go to your projects list.

2. Find the Project ID of the project you created in Step 2 and make a note of it. You will need it to configure Fivetran.

   

3. Under the project, find the dataset that you created in Step 2 and make a note of it. You will need it to configure Fivetran.

Grant permissions to Fivetran

1. Go to your Google Cloud Platform project principals list.

2. Click + GRANT ACCESS to create a new user. The Add principals form appears.

   

3. In the New principals field, enter the auto-generated email address you copied in Step 1.

   

4. Select the Bigquery Job User, BigQuery Data Viewer, and Storage Object Admin roles for the Fivetran account. These roles provide permissions to:

   • Run, enumerate, and cancel our own jobs (updates)
   • Enumerate the dataset and tables within a project

   Fivetran must have these permissions to access Google Analytics 4 Export tables and create the jobs necessary to query the BigQuery tables. Use a separate project for datasets that you do not want Fivetran to be able to query.

5. Click Save.

Set up a Google Cloud Platform bucket

You must host a Google Cloud Platform bucket that Fivetran can use temporarily as a staging environment while we perform your syncs. Using a GCP bucket reduces sync times for large data sets, which are common in Google Analytics 4 Export connectors.

IMPORTANT: The GCP bucket must be in the same Google Cloud Project as your Google Analytics 4 Export export destination.

1. Go to the Google Cloud Console Storage browser.
2. Click Create Bucket.
3. Name and configure your bucket. Make a note of your bucket name. You will need it to configure Fivetran.
4. After you create your bucket, click the bucket name to see the Bucket details page, then go to the Permissions tab. In the Permissions section, click Add.
5. Enter the auto-generated email address you copied in Step 1 as a new principal and assign it the "Storage Object Admin" role, then click Save.

Finish Fivetran configuration

1. Enter your chosen destination schema name in your connector setup form.
2. Enter the Project ID that you found in Step 3.
3. Enter the Dataset ID that you found in Step 3.
4. In the Bucket Name field, enter the name of the bucket you set up in Step 5.
5. Select your Sync Mode: Columns or JSON.
6. Click Save & Test. Fivetran will take it from here and sync your data from Google Analytics 4 Export.

Related articles

description Connector Overview

account_tree Schema Information

assignment Release Notes

settings API Connector Configuration

home Documentation Home