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.
What this workflow does
This AI workflow has 13 nodes and runs on a schedule (every week at 07:00). Along the way it connects Google Analytics, Telegram and OpenAI.
How it runs
Trigger: On a schedule (every week at 07:00).
- Google Analytics: uses Google Analytics
- Assign data (Edit Fields (Set)): sets 8 fields: Aufrufe, Nutzer, Sitzungen…
- Summarize: summarizes / groups the items
- Calculation same period previous year (Code): runs custom JavaScript code
- Google Analytics: uses Google Analytics
- Assign data (Edit Fields (Set)): sets 7 fields: Aufrufe, Nutzer, Sitzungen…
- Summarize: summarizes / groups the items
- Processing for email (OpenAI): uses OpenAI, with 1 tool (Calculator)
- Send Email: sends an email over SMTP
- Processing for Telegram (OpenAI): uses OpenAI
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
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
From the author
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…