Analyze Google Analytics Daily and Send AI Insights to Telegram
Workflow Description
Automated workflow that retrieves visitor data and conversion metrics from Google Analytics on a daily schedule, applies OpenAI analysis to extract key insights, and sends actionable reports directly to your Telegram channel for real-time performance monitoring.
How it works
- 1.Set daily execution schedule
- 2.Extract performance metrics from Google Analytics
- 3.Process and calculate data using integrated tools
- 4.Apply AI analysis to identify key insights
- 5.Deliver summary report to Telegram channel
Use cases
- Monitor website performance without manual reporting
- Receive AI-generated summaries of significant traffic changes
- Make data-driven marketing decisions based on automated analysis
- Track conversion and sales rates in real time
Requirements
- Active Google Analytics account connected to your website
- OpenAI API key with appropriate permissions
- Active Telegram account with designated channel or group
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (51)
Schedule Trigger
Schedule Trigger
OpenAI Chat Model
OpenAI
Google_Ads
Tool Workflow
Meta_Ads
Tool Workflow
Analytics_Domain_1
Tool Workflow
Analytics_Domain_3
Tool Workflow
Analytics_Domain_2
Tool Workflow
Analytics_Domain_4
Tool Workflow
Analytics_Domain_5
Tool Workflow
Execute Workflow Trigger
Execute Workflow Trigger
Calculator
Tool Calculator
Sticky Note
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Calculator1
Tool Calculator
Sticky Note4
Sticky Note
Calculator3
Tool Calculator
Call Google Analytics data: Last 7 days
Google Analytics
Call Google Analytics data: Last 7 days (previous year)
Google Analytics
Calculation same period previous year
Code
Format data input (previous year)
Code
Format data input (current year)
Code
Assign data from input (current year)
Set
Summarize input (current year)
Summarize
Assign input (previous year)
Set
Summarize input (previous year)
Summarize
Calculate date format for Google Ads request (last 7 days)
Code
Call Google Ads Data: Last 7 days
HTTP Request
Call Google Ads Data: Last 7 days (previous year)
HTTP Request
Call Meta Ads Data: Last 7 days
Facebook Graph Api
Call Meta Ads Data: Last 7 days (previous year)
Facebook Graph Api
Summarize Meta input (current year)
Summarize
Assign Meta data from input (current year)
Set
Assign Meta data input (previous year)
Set
Summarize Meta data input (previous year)
Summarize
Format all Meta data for LLM
Code
Processing for Google Ads report
OpenAI
Format all Google data for LLM
Code
Assign Google Analytics data input (current year)
Set
Summarize Google Analytics input (current year)
Summarize
Calculate date format for meta ads request s
Code
Calculation same period previous year1
Code
Assign Google Analytics data input (previous year)
Set
Summarize Google Analytics input (previous year)
Summarize
Send mail report
Email Send
Processing for Meta Ads Report
OpenAI
Processing for Google Analytics Report
OpenAI
Processing for Telegram Report
OpenAI
Weekly Report Agent
Agent
Send Telegram report
Set
Sticky Note1
Sticky Note