This automation template automatically delivers a structured weekly analytics report based on Google Analytics data. It includes year-over-year comparison and uses AI to generate insightful analysis. The full HTML version is sent via email, while a concise summary is delivered through Telegram.
## Who it´s for
- Marketers tracking weekly traffic and conversion trends
- Website owners who want automated reports without manual exports
- Analysts needing quick comparisons between current and historical performance
- Teams using Telegram for real-time business metric updates
## What the automation does
- Triggers every Monday at 7:00 AM via cron schedule
- Fetches Google Analytics data for the last 7 days and the same period last year
- Aggregates key metrics: views, users, sessions, purchases, and others
- Sends aggregated data to OpenAI for analytical insights and HTML formatting
- Delivers a complete HTML report via email using SMTP
- Converts key takeaways into plain text and sends them via Telegram
## What´s included
- Ready-to-use n8n workflow
- Cron-based trigger logic and date range handling
- Integrations with Google Analytics API, OpenAI, SMTP, and Telegram API
- Basic written instructions for setup and adaptation
## Requirements for setup
- n8n account (cloud or self-hosted)
- Google Analytics access with read permissions
- OpenAI API key
- Configured SMTP server for email delivery
- Telegram bot token and chat ID
## Benefits and outcomes
- Saves time on manual data collection and report formatting
- Enables automatic year-over-year performance comparison
- Enhances data interpretation with AI-generated insights
- Provides instant visibility via Telegram notifications
- Delivers professional-looking HTML reports by email
- Automates recurring analytics tasks reliably
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.
weekly Google Analytics report
year-over-year metrics comparison
Google Analytics automation
website traffic report
key metrics analysis
HTML analytics report
Telegram report delivery
email report automation
n8n workflow
AI data analysis
Google Analytics API
OpenAI text generation
Telegram bot for reports
automated data aggregation
marketing analytics dashboard
No feedback yet