Connection Setup
Step 1: Create a Service Account within your GCP project
Create a Service Account
Generate a private key for your service account
Navigate to IAM & Admin > Service Accounts.
Step 2: Enable the APIs
Enable Google Analytics Admin API

Enable Google Analytics Data API

Step 3: Grant Google Analytics 4 Property Access to Service Account
Navigate to Google Analytics and click on the “Admin” cog in the left sidebar.
Ensure that you are in the correct Account and Property, and then click on “Property Access Management”.
Step 4: Create GA4 Connection on Integrate.io ETL

Connection
Select an existing Google Analytics 4 (GA4) connection or create a new one.Source Properties

- Api Version - Select api version Google Analytics 4 API. See list of available APIs from Google here
- Date range - Select a date range from the dropdown list of ranges. If you select
custom date range..., you will be prompted to enter From date and To date. Click on either inputs and select the dates from the calendar. You can also use variables as values for the custom date range in the formatyyyy-MM-dd. - Include custom dimensions and metrics - Fetch list of custom dimensions and metrics from selected accounts and show it on tables of dimensions and metrics in schema section
- Property IDs - Leave empty to read data for all accessible Google Analytics 4 properties or type in the IDs of your Google Analytics properties (or tables) in the form of properties/xxx. You can enter multiple ids separated by comma or use a variable too. Source Schema






