📊 Create a Google Analytics data report with AI and sent it to e-mail and Telegram
⚡ 12,524 views · 📊 Market Research & Insights
Description
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:
- 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 report as an email
- preparation in short form by AI for Telegram (optional)
- 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!
🔗 Nodes Used
Send Email, Telegram, Google Analytics, Schedule Trigger, Calculator, Summarize
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File