Google Analytics

Connect Dataworkz to Google Analytics 4 to sync property data, dimensions, and metrics into your pipelines.

Dataworkz supports two authentication methods for Google Analytics: OAuth (recommended) and Service Account OAuth.

Prerequisites

OAuth

Authorize Dataworkz to access your Google Analytics data using your Google account.

Service Account OAuth

1. Follow the Setup Service Account instructions to create a service account.

2. Ensure the service account has access to the Google Analytics property.

3. In Google Cloud Console, go to APIs & Services > Enabled APIs & services and enable both:

   • Google Analytics Data API

   • Google Analytics Admin API

---

Step 1 — Create a Google Analytics Connector

Navigate to Configuration (gear icon) > Integrations > SaaS Applications > Google Analytics.

Google Analytics — list of configured connectors

Click + Add new configuration.

Add New Google Analytics — enter instance name and select OAuth option

Enter a Google Analytics instance name and select an OAuth option.

OAuth

1. With OAuth selected, click Sign in with Google and complete the Google authorization flow.

2. After authorization, select a Workspace and Collection to store synced data.

3. Click Save.

Add New Google Analytics — Workspace and Collection fields appear after authorization

Service Account OAuth

1. Select Service Account OAuth from the OAuth option dropdown.

2. Enter the following credentials from your Google Cloud service account:

Field	Description
Client Id	The service account client ID.
Client email	The service account email address.
Authenticate certificate option	How the certificate is provided — Text to paste directly, or File to upload.
Authenticate certificate type	The certificate format — typically Pem.
Private key id	The ID of the private key from the service account JSON.
Private key	The private key contents from the service account JSON.
Workspace	The Dataworkz workspace to store synced data.
Collection	The collection within the workspace.

1. Click Authenticate. If authentication succeeds, click Save.

Add New Google Analytics — Service Account OAuth fields

The new connector appears in the Google Analytics list. Click the connector name to open its detail view, showing connector Properties and a Configuration tab for managing data sync jobs.

Google Analytics connector — Properties tab showing instance name, Workspace, and Collection

---

Step 2 — Add a Sync Configuration

Click the Configuration tab on the connector detail page, then click + Add new configuration.

Google Analytics — Configuration tab listing sync jobs for this connector

Google Analytics — Configuration form for defining a sync job

Fill in the following fields:

Field	Required	Description
Job name	Yes	A unique name for this sync job.
Account	Yes	The Google Analytics account to sync from.
Property	Yes	The GA4 property to sync.
Dimensions	Yes	The dimensions to include in the report. The date dimension is mandatory. You can select up to 9 dimensions.
Metrics	Yes	The metrics to collect (e.g. sessions, activeUsers, conversions).
First run includes all historical data	Yes	Set to Yes to pull all available historical data on the first run. Set to No to start from the current date.
Enable Recurring Job	No	Toggle on to schedule this job to run automatically on a recurring basis.

Click Add to save the configuration.