Weekly Client Performance Reports with n8n + Google Sheets

Automatically generate weekly client performance reports (Meta Ads, Google Ads, GA4) with n8n—then deliver them via Gmail and/or Slack

This n8n workflow runs every Monday at 09:00, pulls weekly metrics from your Google Sheets configuration, computes week-over-week changes, uses OpenAI to write a concise narrative, and sends branded HTML reports through Gmail and/or Slack. It also logs delivery to Google Sheets for idempotency—so you get consistent, repeatable reporting.

What this workflow does

• Schedule + configuration: Runs on a Monday schedule (workflow timezone) and loads client settings from the Google Sheets config tab, including previously processed dedupe_key values from the reports tab.
• Validation and alerts: Validates each client row, skips disabled clients, and flags missing sources or delivery targets as alerts during the run.
• Fetch weekly metrics: For each enabled source, retrieves data from Meta Marketing API, Google Ads API, and/or Google Analytics Data API (GA4), normalizing results into a shared metric format.
• Compute deltas + anomalies: Calculates week-over-week percentage deltas and flags anomalies when a metric’s absolute change meets the per-client alert_threshold_pct.
• Prevent duplicates: Skips duplicates for the same ISO week using client_id + ISO week.
• AI narrative + branded output: Uses OpenAI to generate a short narrative referencing only the precomputed metrics table, then renders a branded HTML report.
• Deliver + log: Sends a report via Gmail (send or draft using delivery_mode) and/or posts to Slack, then upserts a delivery record to the reports tab and emails a run digest to the operator.

Use cases

• SaaS operators who need consistent weekly KPI reporting across multiple clients.
• Agency teams consolidating Meta Ads, Google Ads, and GA4 performance into one branded email/Slack update.
• Automation engineers deploying idempotent, metrics-driven reporting with AI-written insights.

Technical details

• n8n nodes/logic: if, code, gmail, merge, open ai, switch
• Integrations: Google Sheets (config, reports), Meta Marketing API, Google Ads API, GA4 (Google Analytics Data API), Gmail, Slack, OpenAI