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.

n8nRead on 2026-11-169 steps

Steps

  1. Trigger: Time trigger, e.g. every Monday 7 a.m.
  2. Retrieves the last 7 days of marketing data
    Google Analytics, Google Ads, Meta Ads, via sub workflows.
  3. Assigns and summarizes the data
  4. Retrieves the same period last year
  5. Allocates and summarizes the data
  6. AI prepares a table and brief analysis
  7. Sends the report as an emailEmail (SMTP)
  8. AI prepares a short form for Telegram
    Optional.
  9. 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