Automated GA4 analytics data backfill to BigQuery with Telegram alerts

This workflow automates the daily backfill of Google Analytics 4 (GA4) data into BigQuery. It fetches 13 essential pre-processed reports (including User Acquisition, Traffic, and E-commerce) and uploads them to automatically created tables in BigQuery, and then send an alert in telegram. How it works Configuration: You define your Project ID, Dataset, and Date Range in a central "Config" node. Parallel Fetching: The workflow runs 13 parallel API calls to GA4 to retrieve key reports (e.g., ga4trafficsources, ga4ecommerceitems). Dynamic Tables: It automatically checks if the target BigQuery table exists and creates it with the correct schema if it's missing. Telegram Alerts: After execution, it sends a summary message to Telegram indicating success or failure for the day's run. Set up steps 1. Google Credentials (OAuth): This workflow uses n8n's built-in "Google OAuth2 API" credential. You do not need a Service Account key. Connect your Google account and ensure you grant scopes for Google Analytics API and BigQuery API. 2. Config Node: Open the "Backfill Config" node and fill in: GA4 Property ID Google Cloud Project ID BigQuery Dataset ID 3. Telegram Setup (Optional): If you want alerts, configure the Telegram node with your Bot Token and Chat ID. If not, you can disable/remove this node. 4. Schedule: By default, this is set to run daily. It is recommended to use a date expression (e.g., Today - 2 Days) to allow GA4 time to process data fully before fetching.