{"product_id":"supply-chain-spof-risk-visualization-with-n8n-groq-notion","title":"Supply Chain SPOF Risk Visualization with n8n, Groq \u0026 Notion","description":"\u003ch3\u003eVisualize Single Points of Failure in your supply chain—automatically, every week\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls supplier, material, plant, and logistics master data from Google Sheets, builds a supplier–material–plant–logistics graph, scores SPOF risk using a VaR proxy, and publishes an executive risk brief (via Groq) to Notion—plus updates in Slack, Gmail, Google Drive, and a Sheets run log.\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:\u003c\/strong\u003e Executes every Monday at \u003cstrong\u003e08:00\u003c\/strong\u003e, setting run configuration such as the \u003cstrong\u003eVaR threshold\u003c\/strong\u003e, \u003cstrong\u003eSPOF count threshold\u003c\/strong\u003e, alert email list, and a unique run ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIngests master data:\u003c\/strong\u003e Reads the \u003cem\u003eSuppliers\u003c\/em\u003e, \u003cem\u003eMaterials\u003c\/em\u003e, \u003cem\u003eLogistics\u003c\/em\u003e, and \u003cem\u003ePlants\u003c\/em\u003e tabs from Google Sheets and combines the datasets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds a supply-chain SPOF graph:\u003c\/strong\u003e Validates the presence of supplier\/material data, normalizes rows into nodes and edges, and scores \u003cstrong\u003esingle points of failure\u003c\/strong\u003e plus an overall severity using a \u003cstrong\u003eVaR proxy\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles data issues:\u003c\/strong\u003e If no usable data\/graph is produced, posts a failure message to \u003cstrong\u003eSlack\u003c\/strong\u003e describing what to fix.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a risk brief with Groq:\u003c\/strong\u003e Sends scored results to a \u003cstrong\u003eGroq-powered agent\u003c\/strong\u003e, parses the returned JSON, and extracts an executive summary, top SPOFs, and mitigations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublishes results:\u003c\/strong\u003e Renders an \u003cstrong\u003eSVG risk map\u003c\/strong\u003e, uploads it to \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e, and creates a \u003cstrong\u003eNotion\u003c\/strong\u003e database page with metrics, summary, mitigations, and the graph link.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlerts when needed:\u003c\/strong\u003e If alert-worthy, posts to \u003cstrong\u003eSlack\u003c\/strong\u003e, emails a \u003cstrong\u003eGmail\u003c\/strong\u003e digest, and appends the outcome to a \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e \u003cem\u003erunlogs\u003c\/em\u003e tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly internal reporting for \u003cstrong\u003esupply chain risk visualization\u003c\/strong\u003e and SPOF governance.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers needing an end-to-end workflow from Sheets data to \u003cstrong\u003eNotion\u003c\/strong\u003e publishing.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators monitoring supplier risk trends with consistent scoring and audit trails.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling:\u003c\/strong\u003e n8n cron (Monday 08:00) with run configuration (VaR and SPOF thresholds, run ID).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets, Google Drive, Notion, Slack, Gmail, and an \u003cstrong\u003eLLM agent via Groq\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow nodes mentioned:\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003emerge\u003c\/em\u003e, \u003cem\u003eslack\u003c\/em\u003e, and \u003cem\u003egmail\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirement:\u003c\/strong\u003e Connect Google Sheets OAuth and update the spreadsheet\/tab IDs for \u003cem\u003eSuppliers\u003c\/em\u003e, \u003cem\u003eMaterials\u003c\/em\u003e, \u003cem\u003eLogistics\u003c\/em\u003e, and \u003cem\u003ePlants\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46172940402867,"sku":"N8N-20591","price":11.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/A4j8HQHC4vI07nsNgY5T9_Awi55AjO.png?v=1791364236","url":"https:\/\/buyflowscripts.com\/products\/supply-chain-spof-risk-visualization-with-n8n-groq-notion","provider":"N8N Commerce","version":"1.0","type":"link"}