Contributed by Sabrina Ramonov 🍄. From the community directory at agents.sabrina.dev, republished with permission and full credit.
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 a Telegram message.
Requirements
The following accesses are required for the workflow:
- Google Analytics (via Google Analytics API)
- 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 a Telegram message)
Feel free to contact me via LinkedIn if you have any questions!
Tools used: Google Analytics, OpenAI, SMTP Email
Download the workflow template (JSON)
Want this running in your business? KOBA42 builds and operates automations like this one.