Automate Weekly Performance Reports with n8n: GA4 + Google Ads + HubSpot to AI Narrative
Every Monday a marketer or agency account manager opens four dashboards, copies numbers into a deck, and writes the same "here's how last week went" summary. It's predictable, repetitive work — exactly what should be automated. This n8n workflow pulls the data, computes the deltas, and writes the executive narrative for you.
The problem with raw dashboards
GA4, Google Ads, and HubSpot each tell part of the story, but none of them say what it means. A client doesn't want "sessions: 12,430." They want "traffic is up 18% week-over-week, driven by the new blog content, and it converted into 6 more qualified leads." Turning numbers into narrative is the job — and it's automatable.
Collecting the metrics on a schedule
A weekly cron trigger kicks off three parallel pulls:
- GA4 Data API — sessions, users, conversions, top channels.
- Google Ads API — spend, clicks, CPA, ROAS for the week.
- HubSpot — new contacts, deals created, pipeline movement.
The workflow also fetches the prior week so it can compute week-over-week change for every metric.
Skip the build — get the ready-to-import template
This is the weekly AI report workflow described above, ready to run. Import it into n8n in minutes, connect your credentials, and go live today.
Get the n8n template on Gumroad →
Letting AI write the executive summary
The combined metrics and deltas go to an LLM with a tight brief: write a concise executive summary, call out what moved and why it likely moved, flag anything that needs attention, and recommend next steps. The output reads like a human analyst wrote it — because it's reasoning over real, current numbers.
Delivering a report people read
The narrative plus a clean metrics table gets formatted and sent — as an email, a Slack post, a Notion page, or a branded PDF for clients. Schedule it for early Monday and the report is waiting before anyone asks for it.
Scaling across clients
For agencies, the real win is multiplication. Parameterize the workflow by client account and one build produces every client's weekly report automatically. That's hours back every week and a more consistent deliverable than anyone copying numbers by hand.
Ready to automate this?
You can wire every node above by hand — or import a tested workflow and be running in minutes. The template ships with the full n8n JSON, setup notes, and the exact prompts used in this guide.
