Allowing ETL access to my Google Analytics 4 (GA4) ETL can read Google Analytics 4 (GA4) data from your Google accounts. This article details creating the Google Analytics 4 (GA4) connection in ETL.

To create a Google Analytics 4 connection in ETL:

  1. Click the Connections icon (lightning bolt) on the top left menu.
  2. To create a connection, click New connection. thumbnail image
  3. Choose "Google Analytics - GA4" under "Services" connection typethumbnail image
  4. In the new connection window, enter the name of the connection and then upload the service account JSON key.
  5. To make sure the credentials is valid and has sufficient permission, click Test Connection. Once test connection successful, click Create Connection.

To generate Service Account JSON key and enable required permissions

Generate a new JSON Key

  1. Access your Google Cloud Console.
  2. Click the project name for which you want to grant ETL access.
  3. On the sidebar, choose IAM & Admin -> Service Accounts
  5. Select & click the service account that has been created in previous step, click "KEYS" tab on the top and then click "ADD KEY" -> "Create new key" -> choose "JSON" -> click "CREATE"
  6. A JSON-key file will be automatically downloaded to your machine.

thumbnail image

Enable required permissions

  1. The associated Google's account has at least "Viewer" role for corresponding Google Analytics 4's account(s).
  2. Enable Google Analytics Admin APIthumbnail image
  3. Enable Google Analytics Data APIthumbnail image