{"product_id":"weekly-client-performance-reports-with-n8n-google-sheets","title":"Weekly Client Performance Reports with n8n + Google Sheets","description":"\u003ch3\u003eAutomatically generate weekly client performance reports (Meta Ads, Google Ads, GA4) with n8n—then deliver them via Gmail and\/or Slack\u003c\/h3\u003e\n\u003cp\u003eThis 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 \u003cstrong\u003eGmail\u003c\/strong\u003e and\/or \u003cstrong\u003eSlack\u003c\/strong\u003e. It also logs delivery to Google Sheets for idempotency—so you get consistent, repeatable reporting.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule + configuration:\u003c\/strong\u003e Runs on a Monday schedule (workflow timezone) and loads client settings from the Google Sheets \u003ccode\u003econfig\u003c\/code\u003e tab, including previously processed \u003ccode\u003ededupe_key\u003c\/code\u003e values from the \u003ccode\u003ereports\u003c\/code\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidation and alerts:\u003c\/strong\u003e Validates each client row, skips disabled clients, and flags missing sources or delivery targets as alerts during the run.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetch weekly metrics:\u003c\/strong\u003e For each enabled source, retrieves data from \u003cstrong\u003eMeta Marketing API\u003c\/strong\u003e, \u003cstrong\u003eGoogle Ads API\u003c\/strong\u003e, and\/or \u003cstrong\u003eGoogle Analytics Data API (GA4)\u003c\/strong\u003e, normalizing results into a shared metric format.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompute deltas + anomalies:\u003c\/strong\u003e Calculates week-over-week percentage deltas and flags anomalies when a metric’s absolute change meets the per-client \u003ccode\u003ealert_threshold_pct\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevent duplicates:\u003c\/strong\u003e Skips duplicates for the same ISO week using \u003ccode\u003eclient_id + ISO week\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI narrative + branded output:\u003c\/strong\u003e Uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to generate a short narrative referencing only the precomputed metrics table, then renders a branded HTML report.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDeliver + log:\u003c\/strong\u003e Sends a report via Gmail (send or draft using \u003ccode\u003edelivery_mode\u003c\/code\u003e) and\/or posts to Slack, then upserts a delivery record to the \u003ccode\u003ereports\u003c\/code\u003e tab and emails a run digest to the operator.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who need consistent weekly KPI reporting across multiple clients.\u003c\/li\u003e\n  \u003cli\u003eAgency teams consolidating Meta Ads, Google Ads, and GA4 performance into one branded email\/Slack update.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers deploying idempotent, metrics-driven reporting with AI-written insights.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, \u003ccode\u003emerge\u003c\/code\u003e, \u003ccode\u003eopen ai\u003c\/code\u003e, \u003ccode\u003eswitch\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (\u003ccode\u003econfig\u003c\/code\u003e, \u003ccode\u003ereports\u003c\/code\u003e), Meta Marketing API, Google Ads API, GA4 (Google Analytics Data API), Gmail, Slack, OpenAI\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192851779763,"sku":"N8N-20661","price":73.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/9J7s15yjh9v8p1SSNyzb6_ebYOFql4.png?v=1791537305","url":"https:\/\/buyflowscripts.com\/products\/weekly-client-performance-reports-with-n8n-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}