{"product_id":"supplier-contract-renewal-risk-in-n8n-sheets-groq-slack","title":"Supplier Contract Renewal Risk in n8n: Sheets + Groq + Slack","description":"\u003ch3\u003eWeekly Supplier Contract Renewal Risk Checks — Powered by Sheets + Groq + Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically evaluates supplier contracts every week by merging Google Sheets contract and performance data, calculating a renewal risk score, generating Groq LLM insights, and alerting high-risk suppliers in Slack—while logging results back to Google Sheets.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cp\u003eDesigned for supplier renewal decision-making, the workflow follows a clear pipeline:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly on a schedule\u003c\/strong\u003e to keep contract risk monitoring up to date.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls data from two Google Sheets spreadsheets\u003c\/strong\u003e—one for supplier contracts and one for supplier performance metrics.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMatches and combines records by \u003cem\u003esupplier_name\u003c\/em\u003e\u003c\/strong\u003e to produce a single evaluation per supplier contract.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates\u003c\/strong\u003e days to renewal, a \u003cstrong\u003erisk score\u003c\/strong\u003e, and a \u003cstrong\u003e“silent value leakage”\u003c\/strong\u003e indicator based on usage, SLA breaches, delivery, quality, and pricing changes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls a Groq-hosted LLM\u003c\/strong\u003e to produce human-readable output: risk level, decision rationale, and negotiation guidance for each contract.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlags high risk (score ≥ 40)\u003c\/strong\u003e, posts a detailed alert to a \u003cstrong\u003eSlack\u003c\/strong\u003e channel, and appends the contract plus a suggested action to a “High Risk” tab in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends lower-risk contracts\u003c\/strong\u003e to a separate Google Sheets tab for ongoing tracking with suggested actions and status.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRenewal teams want early warnings on supplier contracts that may lead to value leakage or SLA concerns.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators and procurement managers need a repeatable \u003cstrong\u003esupplier contract risk scoring\u003c\/strong\u003e process.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers want a practical \u003cstrong\u003en8n workflow\u003c\/strong\u003e that combines Sheets data, LLM reasoning, and Slack notifications.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Sheets (source, merge, and “Contract Insights” output), Slack\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLLM:\u003c\/strong\u003e Groq-hosted LLM for risk level and negotiation guidance\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e if, set, code, merge, slack, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eKey requirement:\u003c\/strong\u003e both source sheets must share a common key field named \u003ccode\u003esupplier_name\u003c\/code\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSet it up once, then rely on consistent weekly supplier contract renewal risk insights—with Slack alerts for the contracts that need attention first.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45869891715251,"sku":"N8N-18445","price":2.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/S05TB5D0n5SNoOpHiWYXi_1X1jSZGr.png?v=1787130329","url":"https:\/\/buyflowscripts.com\/products\/supplier-contract-renewal-risk-in-n8n-sheets-groq-slack","provider":"N8N Commerce","version":"1.0","type":"link"}