Connect Google Analytics with Telegram andOpenAI
Workflow Description
Automatically extract Google Analytics data on a schedule, process metrics through calculation tools, generate intelligent summaries using OpenAI, and distribute reports via Telegram and email. Combine analytics insights with AI-powered analysis for actionable business intelligence.
How it works
- 1.Execute workflow on a predefined schedule
- 2.Retrieve analytics data from Google Analytics account
- 3.Perform calculations and data transformations using built-in tools
- 4.Generate AI-powered summaries with OpenAI
- 5.Send formatted reports to Telegram and email recipients
Use cases
- Deliver daily or weekly performance reports to team members automatically
- Receive AI-generated insights about visitor behavior and engagement patterns
- Monitor KPIs and alert teams when metrics exceed predefined thresholds
Requirements
- Connected Google Analytics account with proper permissions
- Valid OpenAI API key and sufficient credit
- Telegram bot token and chat ID for message delivery
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 (14)
Schedule Trigger
Schedule Trigger
Google Analytics Letzte 7 Tage
Google Analytics
Send Email
Email Send
Telegram
Set
Processing for Telegram
OpenAI
Calculator
Tool Calculator
Google Analytics: Past 7 days of the previous year
Google Analytics
Summarize Data
Summarize
Summarize Data1
Summarize
Calculation same period previous year
Code
Assign data
Set
Assign data1
Set
Sticky Note
Sticky Note
Processing for email
OpenAI