How to Automate a Weekly Marketing Report with GA4 + AI (n8n)

Marketing reports eat a predictable hour every week: open the dashboard, copy the numbers, write the same “here’s how we did” note, send. None of it needs you, only the judgment does. This workflow does the gathering and the first-draft writing, so you just review and hit send.

What this workflow does

1. It runs automatically every week.
2. It pulls your key numbers from Google Analytics 4.
3. Claude writes a short, plain-English summary of what changed and why it matters.
4. The report is emailed to you or your client.

What you’ll need

• n8n (cloud or self-hosted).
• A Google Analytics 4 property you can authorize.
• A Claude (Anthropic) API key.
• A Gmail account (or a Google Docs / Notion node if you’d rather publish it).

Build it step by step

Step 1, Schedule it

Add a Schedule Trigger set to run weekly, Monday at 7am is a good slot so the report is waiting when the week starts:

0 7 * * 1

Step 2, Pull the numbers

Add a Google Analytics node and request your key metrics for the last 7 days, sessions, users, top channels, conversions. Add a second call for the previous 7 days too. That second pull is what lets the report talk about change instead of raw totals.

Step 3, Write the summary with Claude

Add the Anthropic (Claude) node and feed it both weeks:

You are my marketing analyst. Write a short weekly report from these numbers.
Lead with the 2-3 things that actually matter, describe changes week-over-week
in plain English, and end with one thing to look into. No jargon, no fluff.

This week: {{ $json.thisWeek }}
Last week: {{ $json.lastWeek }}

You get a crisp narrative, “Organic traffic rose 18% while paid dipped; sign-ups followed organic. Worth checking which post drove it.”. Not a wall of figures.

Step 4, Send it

Add a Gmail node to email the summary to yourself or your client. Prefer a polished doc? Use a Google Docs or Notion node instead and share the link.

Step 5, Activate

Flip it to Active. Your weekly report now writes and sends itself.

Make it yours

• Multi-source: add Search Console, Stripe, and ad spend for one report that covers everything.
• Per-client loop: run it across every client property and send each a branded version. This is a real productized service.
• Threshold alerts: ping yourself immediately if traffic or conversions drop sharply, not just weekly.

This one quietly turns into income: clients pay for clear reporting they don’t have to think about. Want it built across your full stack, or recorded as a build-along? Add it to the request queue.