Weekly AI marketing report by email
Weekly AI summary of marketing figures versus last year. This free n8n template builds a periodic online marketing report. On a time trigger, for example every Monday at 7 a.m., sub-workflows fetch the last 7 days of Google Analytics, Google Ads and Meta Ads data, then the same period of the previous year. An AI model of your choice puts the figures in a table and writes a short analysis, sent by email over SMTP. An optional step writes a shorter version for Telegram. It suits marketers who follow Google Analytics for several domains. Each sub-workflow is set up as a separate workflow.
Steps
- Trigger: Time trigger, e.g. every Monday 7 a.m.
- Retrieves the last 7 days of marketing data
Google Analytics, Google Ads, Meta Ads, via sub workflows. - Assigns and summarizes the data
- Retrieves the same period last year
- Allocates and summarizes the data
- AI prepares a table and brief analysis
- Sends the report as an emailEmail (SMTP)
- AI prepares a short form for Telegram
Optional. - Output: Sends a Telegram messageTelegram
Limits
- The AI model is not named; you choose the provider.
- Each sub-workflow must be set up as a separate workflow.
- Needs Google, Meta, AI API and SMTP access before it runs.
What it does well
- Compares the last 7 days with the same period a year earlier.
Before you import
The AI provider is left open: the page lists OpenAI, Anthropic, Google or Ollama.
Similar templates
Feedback sentiment alerts in Telegram
Also for scheduling and ops, 6 steps.
Retell AI appointment reminder calls
Also for scheduling and ops, 5 steps.
Google Calendar booking from a form
Also for scheduling and ops, 9 steps.
Send a recurring summary
Other templates that do this task.