📊 AI marketing report (Google Analytics & Ads, Meta Ads), sent via email/Telegram
⚡ 51,720 views · 📊 Market Research & Insights
💡 Pro Tip — If you’ve run into Facebook’s Graph API permission restrictions, ScraperNode is a community node that scrapes pages, groups, posts, and comments directly — no app review needed.
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!
🔗 Nodes Used
Send Email, HTTP Request, Telegram, Facebook Graph API, Google Analytics, Execute Workflow Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File