Create a Google Analytics data report with AI and sent it to e-mail and Telegram
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Analytics
n8n-nodes-base.googleAnalytics - Send Email
n8n-nodes-base.emailSend - Telegram
n8n-nodes-base.telegram - OpenAI
@n8n/n8n-nodes-langchain.openAi - Calculator
@n8n/n8n-nodes-langchain.toolCalculator - Summarize
n8n-nodes-base.summarize - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set
What it does
What 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: 1. time trigger (e.g. every Monday at 7 a.m.) 2. retrieval of Google Analytics data from the last 7 days 3. assignment and summary of the data 4. retrieval of Google Analytics data from the last 7 days of the previous year 5. allocation and summary of the data 6. preparation in tabular form and brief analysis by AI. 7. sending the report as an email 8. preparation in short form by AI for Telegram (optional) 9. sending as Telegram message. Requirements The following accesses are required for the workflow: - Google Analytics (via Google Analytics API): Documentation - AI API access (e.g. via OpenAI, Anthropic, Google or Ollama) - SMTP access data (for sending the mail) - Telegram access data (optional for sending as Telegram message): Documentation Feel free to contact me via LinkedIn, if you have any questions!