Description
Automate your weekly analytics reporting using AI. This n8n workflow fetches Google Analytics data, compares it year-over-year, summarizes it using an AI model, and delivers insights via both email and Telegram.
Perfect for marketers, analysts, or founders who want smart, digestible web analytics without manual number-crunching every week.
🧠 How It Works:
✅ ⏰ Time trigger (e.g., every Monday at 7 AM) ✅ 📊 Retrieve Google Analytics data from the past 7 days ✅ 📉 Retrieve data from the same week in the previous year ✅ 🔄 AI organizes and compares the two datasets ✅ 🧠 AI analyzes the data, highlighting key changes and trends ✅ 📋 Format the data into a readable table and concise summary ✅ 📧 Email the full report to one or more recipients ✅ ✂️ Summarize the report again into a shorter format ✅ 📲 Send the short version to your Telegram account
🔍 It Automates:
✅ Pulling web analytics data from two time periods ✅ Structuring the data into meaningful tables ✅ Generating summaries and explanations with AI ✅ Delivering a detailed report via email ✅ Sending a condensed insight via Telegram (optional)
💡 Why Choose This Workflow:
✅ No need to manually log into GA or build spreadsheets ✅ Automatically identifies YoY traffic shifts and trends ✅ Provides context-rich summaries with AI commentary ✅ Keeps both executives and marketers in the loop ✅ Sends data in two formats: comprehensive (email) and quick digest (Telegram)
👤 Who Is This For:
✅ Digital marketers monitoring campaign performance ✅ Founders tracking growth metrics regularly ✅ SEO teams comparing performance year over year ✅ Agencies preparing recurring client reports ✅ Analysts needing summarized traffic data in their inbox
🔗 Integrations:
✅ Google Analytics API (for traffic data) ✅ OpenAI / Anthropic / Ollama / Gemini (for AI summarization) ✅ SMTP (for sending report emails) ✅ Telegram Bot API (for optional digest delivery)
📬 Turn Analytics into Actionable Summaries — Sent to You Automatically Every Week Just import, connect your APIs, and let the data storytelling begin. Never miss critical traffic trends again.
Link : [https://lovable.dev/projects/31d645da-6cd6-440c-9cb9-36dbd955b3f3]
