Google now supports Google Analytics 4 (GA4) as the standard analytics platform, and Etlworks offers a dedicated connector for extracting GA4 data and loading it into any destination—such as databases, files, or APIs.
This article explains how to set up a connection, authenticate using OAuth2 or a service account, and build ETL flows that read data from GA4 properties.
Note: While Etlworks still provides connectors for Universal Analytics, Google has deprecated the platform, and most users should migrate to GA4. Universal Analytics references are kept for legacy purposes only.
What You Can Do with GA4 in Etlworks
-
Extract report and user activity data from GA4 using the Google Analytics Reporting API
-
Load GA4 data into:
-
Relational databases
-
Files (CSV, JSON, XML, etc.)
-
Web services and SaaS apps
-
-
Combine data from GA4 with other sources in multi-step flows.
-
Schedule and automate your analytics workflows.
Authentication
Etlworks supports both OAuth2 and Google Service Account authentication methods.
-
Use OAuth2 for quick, interactive setup.
-
Use a Service Account for production-grade server-to-server integration.
Learn how to connect to Google Services for detailed instructions on authentication options.
Step-by-Step: Create an ETL Flow with Google Analytics
Create a Google Analytics 4 Connection
Go to Connections, click +, and search for Google Analytics 4.
Example Flow: Google Analytics to Database
1. Go to Flows and click +.
2. In the gallery, search for Well-known API to..., for example Well-known API to Database.
3. Select the Well-known API to database flow type.
4. Configure the transformation:
-
-
FROM: Your GA4 connection.
-
TO: Destination (e.g., Postgres, Snowflake, MySQL, etc.).
-
5. Optionally:
-
-
Add SQL filters or parameters.
-
Use Mappings to rename or convert fields.
-