AI marketing report (Google Analytics & Ads, Meta Ads), sent via email/Telegram

Description

What this workflow does
This workflow retrieves Online Marketing data (Google Analytics for several domains, Google Ads, Meta Ads) 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 Online Marketing data from the last 7 days (via sub workflows)
assignment and summary of the data
retrieval of Online Marketing data from the same time period 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
Google Ads (via HTTP Request -> Google Ads API):Documentation
Meta Ads (via Facebook Graph 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

You must set up the individual sub-workflows as separate workflows. Then set the “Execute workflow trigger” here. Then select the corresponding sub-workflow in the AI Agent Tools.
You can select the number of domains yourself. If the data queries are not required, simply delete the corresponding tool (e.g. “Analytics_Domain_5).

Feel free to contact me via LinkedIn, if you have any questions!