{"product_id":"n8n-workflow-b2b-churn-risk-alerts-from-google-sheets-to-slack","title":"n8n Workflow: B2B Churn Risk Alerts from Google Sheets to Slack","description":"\u003ch3\u003eDetect B2B churn risk anomalies from Google Sheets and alert reps in Slack (with Gemini)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow scans new B2B order rows in Google Sheets every day, compares them against account baseline metrics, and triggers churn-risk alerts to \u003cstrong\u003eSlack\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e—with a structured risk assessment generated by \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily at 2:00 AM\u003c\/strong\u003e on a schedule.\u003c\/li\u003e\n  \u003cli\u003eReads \u003cstrong\u003eunprocessed orders\u003c\/strong\u003e from the Google Sheets sheet \u003cstrong\u003eOrders_Ingest\u003c\/strong\u003e, and proceeds only when an \u003cstrong\u003eorder_id\u003c\/strong\u003e is present.\u003c\/li\u003e\n  \u003cli\u003eLoads account baseline metrics from \u003cstrong\u003eAccount_Baselines\u003c\/strong\u003e, joins each order to its \u003cstrong\u003eaccount_id\u003c\/strong\u003e baseline, and \u003cstrong\u003eignores Tier-3 accounts\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCalculates churn-signal anomaly checks (e.g., \u003cstrong\u003evolume\u003c\/strong\u003e, \u003cstrong\u003ecadence\u003c\/strong\u003e, and \u003cstrong\u003ecore-SKU-mix\u003c\/strong\u003e mix anomalies) and keeps only orders that match \u003cstrong\u003eat least one\u003c\/strong\u003e anomaly rule.\u003c\/li\u003e\n  \u003cli\u003eSuppresses repeat alerts when the account’s \u003cstrong\u003elast alert date\u003c\/strong\u003e is within a configured \u003cstrong\u003ecooldown window\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFor qualifying accounts, sends order + baseline context to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to \u003cstrong\u003eclassify risk\u003c\/strong\u003e, propose a \u003cstrong\u003eprimary hypothesis\u003c\/strong\u003e, and return \u003cstrong\u003etwo sales talking points\u003c\/strong\u003e as \u003cstrong\u003estructured JSON\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003ePosts the alert to \u003cstrong\u003eSlack\u003c\/strong\u003e, emails the \u003cstrong\u003eassigned rep\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e, appends an audit entry to \u003cstrong\u003eAlert_Audit_Log\u003c\/strong\u003e, updates \u003cstrong\u003elast_alert_date\u003c\/strong\u003e in \u003cstrong\u003eAccount_Baselines\u003c\/strong\u003e, and marks the order as processed in \u003cstrong\u003eOrders_Ingest\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCatch early churn risk after sudden drops in order volume or cadence.\u003c\/li\u003e\n  \u003cli\u003eFlag account changes in core SKU mix before customer outcomes worsen.\u003c\/li\u003e\n  \u003cli\u003eSend targeted churn alerts to sales with AI-generated talking points and auditability.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: Service Account credentials + sheet reads\/writes (Orders_Ingest, Account_Baselines, Alert_Audit_Log)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e: Chat model for structured churn risk assessment (JSON output)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e: Alert posting\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: Emailing the assigned rep\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore workflow logic\u003c\/strong\u003e: \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003eno op\u003c\/em\u003e, and \u003cem\u003elimit\u003c\/em\u003e nodes\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eIdeal for n8n automation engineers and SaaS operators building churn monitoring and B2B risk alerts pipelines.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192814129331,"sku":"N8N-20689","price":23.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/2pVLSyxqwWwmwa3LNOhb8_7YmWm25b.png?v=1791536582","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-b2b-churn-risk-alerts-from-google-sheets-to-slack","provider":"N8N Commerce","version":"1.0","type":"link"}