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

说明与用途

自动化的每周电子邮件，包含关键 GA4 指标和 AI 生成的洞察，减少手动工作。

问题

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.

结果

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

工作流

• 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

证据

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.

来源

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

来源