Create a Google Analytics Data Report with AI and sent it to E-Mail and Telegram
n8n template #2673Summary
Use templateWhat this workflow does This workflow retrieves Google Analytics data from the last 7 days and the same period in the previous year. The data is then prepared by AI as a table, analyzed and provided with a small summary. The summary is then sent by email to a desired address and, shortened and summarized again, sent to a Telegram account. This workflow has the following sequence: time trigger (e.g. every Monday at 7 a.m.) retrieval of Google Analytics data from the last 7 days assignment and summary of the data retrieval of Google Analytics data from the last 7 days of the previous year allocation and summary of the data preparation in tabular form and brief analysis by AI. sending the repor
How to set it up
- Open template #2673 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
- Create 4 credentials under Credentials → Add credential: Send Email, Telegram, Google Analytics, OpenAI. Then open each of those nodes and pick the credential.
- Check the model in the OpenAI node. The template may point at a model your account can't use; swap it for one you have access to.
- Click Execute workflow and step through each node's output to confirm the data looks right.
- Toggle the workflow to Active so its trigger runs on its own.
Hand off to your agent
Prompt
Help me set up the n8n workflow "Create a Google Analytics Data Report with AI and sent it to E-Mail and Telegram" (https://n8n.io/workflows/2673). It uses: Send Email, Telegram, Google Analytics, Code, Calculator, OpenAI. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.
Paste into Claude Code and it will do the rest.
Apps and nodes
Questions
Yes. Friedemann Schuetz published it free on n8n.io as a verified creator, and it has 9,529 views. It runs on n8n Cloud or a self-hosted n8n instance.
Send Email, Telegram, Google Analytics, OpenAI. The other 2 nodes are built into n8n.
Similar workflows
NameViews
- AI marketing report (Google Analytics & Ads, Meta Ads), sent via email/Telegram36K
- ✨🤖Automate Multi-Platform Social Media Content Creation with AI205K
- Clone Viral TikToks with AI Avatars & Auto-Post to 9 Platforms using Perplexity & Blotato84K
- Generate Instagram Content from Top Trends with AI Image Generation72K
- Automated Stock Analysis Reports with Technical & News Sentiment using GPT-4o37K
- Auto-create and publish AI social videos with Telegram, GPT-4 and Blotato26K
- AI Email Analyzer: Process PDFs, Images & Save to Google Drive + Telegram21K
- AI-Powered Social Media Amplifier17K