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., ga4t
At a glance
Automated GA4 analytics data backfill to BigQuery with Telegram alerts is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Telegram. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Telegram
- Modules
- 32
- Price
- Free
- Version
- v1.0

About this workflow
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.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Create a Telegram reply message for new AI-generated chat completions
Send Telegram messages for new leads generated by Happierleads
Ai-powered Telegram task manager with MCP server
Transfer Manychat contacts to KlickTipp
Send Telegram messages for new Hive actions
Weekly business & home task planner with Notion, email digests and Telegram
Generate and share professional PDFs with OpenAI, Google Docs, and Slack
Generate comprehensive business analysis reports with Gemini AI & Firecrawl
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you