{"product_id":"n8n-workflow-supplier-late-delivery-risk-alerts-sheets-slack","title":"n8n Workflow: Supplier Late-Delivery Risk Alerts (Sheets + Slack)","description":"\u003ch3\u003eCatch supplier late-delivery risk early with automated Sheets + Slack alerts\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003eSupplier Late-Delivery Risk Alerts (Sheets + Slack)\u003c\/strong\u003e n8n workflow scans your Google Sheets purchase orders and shipment signals every 6 hours, scores each open order for lateness risk, logs flagged items to a \u003cstrong\u003eRisk Register\u003c\/strong\u003e, and sends a clear \u003cstrong\u003eSlack\u003c\/strong\u003e alert—so you can escalate before delays impact customers.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule every 6 hours\u003c\/strong\u003e using a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads data from Google Sheets\u003c\/strong\u003e tabs: \u003cstrong\u003ePurchase Orders\u003c\/strong\u003e, \u003cstrong\u003eSupplier History\u003c\/strong\u003e, \u003cstrong\u003eCustomer Commitments\u003c\/strong\u003e, and \u003cstrong\u003eCarrier Tracking\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eJoins datasets and calculates risk indicators\u003c\/strong\u003e, including delay indicators, supplier reliability metrics, impact scores, and an overall \u003cstrong\u003erisk level\u003c\/strong\u003e per open purchase order.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters to at-risk orders\u003c\/strong\u003e (and exits the alert path when no risks are found).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends at-risk orders\u003c\/strong\u003e to the \u003cstrong\u003eRisk Register\u003c\/strong\u003e sheet, including a \u003cstrong\u003eprewritten supplier escalation email draft\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Slack alert\u003c\/strong\u003e with a summary message to your configured channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRecords every run\u003c\/strong\u003e in a \u003cstrong\u003eRun Log\u003c\/strong\u003e Google Sheets tab, including counts checked, at-risk items, and high\/critical items.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eProactively identify suppliers likely to miss delivery commitments using purchase order, supplier history, and carrier tracking.\u003c\/li\u003e\n  \u003cli\u003eCentralize late-delivery triage by automatically maintaining a \u003cstrong\u003eRisk Register\u003c\/strong\u003e and providing escalation email drafts.\u003c\/li\u003e\n  \u003cli\u003eKeep operations teams aligned with real-time \u003cstrong\u003eSlack\u003c\/strong\u003e notifications on newly flagged high\/critical orders.\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 integration\u003c\/strong\u003e via a Service Account (share the spreadsheet with the service account email and provide the spreadsheet ID in the config).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack integration\u003c\/strong\u003e to post alerts to a configured channel.\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic uses nodes such as \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eno op\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46248917139635,"sku":"N8N-21200","price":21.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/CZ7gd9nj_DmYyGvHn7KLL_XlE2OD7t.png?v=1792487491","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-supplier-late-delivery-risk-alerts-sheets-slack","provider":"N8N Commerce","version":"1.0","type":"link"}