{"product_id":"n8n-contract-renewal-tracker-google-sheets-slack-alerts","title":"n8n Contract Renewal Tracker: Google Sheets + Slack Alerts","description":"\u003ch3\u003eAutomatically review contract renewals and alert your team in Slack—every week\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n Contract Renewal Tracker\u003c\/strong\u003e workflow scans your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e contract list weekly, calculates days to expiry and a renewal priority score, then sends \u003cstrong\u003eSlack alerts\u003c\/strong\u003e with AI-generated renewal recommendations for high-priority contracts—while updating each row as processed.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly\u003c\/strong\u003e using a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads contract rows\u003c\/strong\u003e from your Google Sheets contract tracker and keeps only rows that are \u003cstrong\u003enot marked as processed\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates required fields\u003c\/strong\u003e—specifically \u003cem\u003eContractID\u003c\/em\u003e, \u003cem\u003eSupplierName\u003c\/em\u003e, and \u003cem\u003eExpiryDate\u003c\/em\u003e. If validation fails, it sends a \u003cstrong\u003eSlack message\u003c\/strong\u003e and marks the row as \u003cstrong\u003eProcessed = Yes\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates urgency\u003c\/strong\u003e by computing \u003cem\u003eDaysToExpiry\u003c\/em\u003e and assigning a `PriorityLevel` based on contract value, risk level, performance score, and expiry urgency.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates renewal strategy for High priority\u003c\/strong\u003e items by using a \u003cstrong\u003eGroq-hosted chat model\u003c\/strong\u003e via \u003cstrong\u003eLangChain\u003c\/strong\u003e, then posts a formatted renewal alert to your Slack channel.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets\u003c\/strong\u003e for each processed row with \u003cem\u003eProcessed = Yes\u003c\/em\u003e, the computed \u003cem\u003ePriorityLevel\u003c\/em\u003e, and either the \u003cstrong\u003eAI recommendation\u003c\/strong\u003e (high priority) or a \u003cstrong\u003e“monitor for now”\u003c\/strong\u003e recommendation (non-high priority).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who need weekly visibility into expiring supplier or customer agreements.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers consolidating contract tracking in Google Sheets and routing actions to Slack.\u003c\/li\u003e\n  \u003cli\u003eTeams prioritizing renewal outreach based on risk, performance, and time-to-expiry.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/credentials:\u003c\/strong\u003e Google Sheets, Slack, Groq (via LangChain chat model).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes referenced:\u003c\/strong\u003e \u003cem\u003eif\u003c\/em\u003e, \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003eslack\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, \u003cem\u003egoogle sheets\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup steps:\u003c\/strong\u003e configure spreadsheet ID + sheet name, set Slack channel for renewal\/invalid-data alerts, add Groq API credentials for the chat model.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45923043115187,"sku":"N8N-18897","price":37.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/DdbDbm8oHdrdvqXLOcmKk_YNpDwnAH.png?v=1788167158","url":"https:\/\/buyflowscripts.com\/products\/n8n-contract-renewal-tracker-google-sheets-slack-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}