{"product_id":"n8n-weekly-kpi-executive-summary-gemini-sheets-to-gmail-slack","title":"n8n Weekly KPI Executive Summary: Gemini + Sheets to Gmail \u0026 Slack","description":"\u003ch3\u003eAutomate your weekly KPI exec update—Gemini + Google Sheets to Gmail \u0026amp; Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically reads your weekly KPI rows from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, enriches them with benchmark KPI data from an \u003cstrong\u003eHTTP API\u003c\/strong\u003e, generates an executive-style summary using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, then delivers it via \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eSlack\u003c\/strong\u003e—and logs the result back to Google Sheets.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly on a schedule\u003c\/strong\u003e to start your reporting cycle.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls KPI input data\u003c\/strong\u003e from a Google Sheets spreadsheet (including fields such as \u003cem\u003eweek_start\u003c\/em\u003e, \u003cem\u003echannel\u003c\/em\u003e, \u003cem\u003emetric_name\u003c\/em\u003e, \u003cem\u003ecurrent_value\u003c\/em\u003e, \u003cem\u003eprevious_value\u003c\/em\u003e, \u003cem\u003etarget_value\u003c\/em\u003e, and \u003cem\u003enotes\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches benchmark KPIs\u003c\/strong\u003e from a configurable \u003cstrong\u003eHTTP endpoint\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and merges\u003c\/strong\u003e the KPI sources into a consistent structure for reporting.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates week-over-week movement\u003c\/strong\u003e: absolute change, percentage change, trend direction, and whether each metric is above\/below target.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Google Gemini (PaLM)\u003c\/strong\u003e to create a concise executive summary from the consolidated KPI results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats and distributes\u003c\/strong\u003e the AI summary, then sends it via \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends a copy to a KPI log sheet\u003c\/strong\u003e in Google Sheets for historical tracking.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who need a weekly exec update without manually compiling KPI tables.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an internal performance reporting pipeline for KPIs.\u003c\/li\u003e\n  \u003cli\u003eTeams comparing internal performance vs benchmarks and sharing results in email + Slack.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e for weekly execution.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for KPI input and KPI logging.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP endpoint\u003c\/strong\u003e for benchmark KPI data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCode \/ Set \/ Merge\u003c\/strong\u003e steps to normalize, merge, and calculate KPI movement metrics.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini (PaLM)\u003c\/strong\u003e to generate the executive summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eSlack\u003c\/strong\u003e for delivery.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSticky Note\u003c\/strong\u003e nodes for workflow documentation\/clarity.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003ePerfect for anyone looking to streamline \u003cstrong\u003eGoogle Sheets KPI reporting\u003c\/strong\u003e, \u003cstrong\u003eAI-generated weekly summaries\u003c\/strong\u003e, and \u003cstrong\u003eSlack + Gmail distribution\u003c\/strong\u003e with n8n.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45978933100723,"sku":"N8N-19312","price":51.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/PXf3Wtfs6r1OtYXbpn0Tt_Eltu1gM3.png?v=1788859886","url":"https:\/\/buyflowscripts.com\/products\/n8n-weekly-kpi-executive-summary-gemini-sheets-to-gmail-slack","provider":"N8N Commerce","version":"1.0","type":"link"}