Weekly GA4 reports with n8n: week-over-week KPIs and AI insights by email

Description and use

Automated weekly email with key GA4 metrics and AI-generated insights, reducing manual effort.

Problem

Site owners need a concise weekly email summarizing key GA4 metrics and insights, but manual extraction from GA4 takes time and dashboards are often ignored.

Outcome

Automated weekly email delivers key GA4 metrics and AI‑generated insights, reducing manual effort and improving stakeholder engagement.

Workflow

• Schedule Trigger (Monday 08:00)
• Set report settings (property ID, site name, recipient, brand colour)
• Google Analytics: this week’s daily metrics (days -7 to -1)
• Google Analytics: last week’s daily metrics (days -14 to -8)
• Google Analytics: top pages (by page views, limit 10)
• Google Analytics: top traffic sources (by sessions, limit 10)
• Code: compute week‑over‑week totals and % changes
• Basic LLM Chain + Gemini + Structured Output Parser: generate plain‑English summary
• Code: build HTML email
• Gmail: send

Evidence

What most people actually want is one short email on Monday morning: the key numbers, whether they went up or down, and two sentences in plain English about what matters.

Source

The important design rule: the numbers come from GA4 and a Code node, never from the AI.

Source