{"product_id":"classify-supplier-tiers-google-sheets-groq-slack-alerts","title":"Classify Supplier Tiers: Google Sheets + Groq + Slack Alerts","description":"\u003ch3\u003eAutomatically classify your suppliers into actionable tiers—then notify your team\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eClassify Supplier Tiers: Google Sheets + Groq + Slack Alerts\u003c\/strong\u003e is an n8n workflow that runs daily to read supplier records from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, calculate a weighted supplier score, assign each supplier a tier, generate a short \u003cstrong\u003eGroq\u003c\/strong\u003e-powered tier justification, update the sheet + audit log, and send \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eSlack\u003c\/strong\u003e notifications whenever tiers change.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns daily\u003c\/strong\u003e at the configured time.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads supplier rows from Google Sheets\u003c\/strong\u003e and filters to suppliers that have a \u003cstrong\u003esupplier_id\u003c\/strong\u003e and are \u003cstrong\u003enot yet marked as processed\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and normalizes data\u003c\/strong\u003e: fills missing spend, risk, and performance values with defaults, and ensures \u003cstrong\u003eannual spend is greater than 0\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates a weighted score\u003c\/strong\u003e from annual spend, performance score, and risk score, then assigns the tier as \u003cstrong\u003eStrategic\u003c\/strong\u003e, \u003cstrong\u003ePreferred\u003c\/strong\u003e, or \u003cstrong\u003eTransactional\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a 2–3 line JSON tier justification\u003c\/strong\u003e using a \u003cstrong\u003eGroq-hosted LLM\u003c\/strong\u003e (via a LangChain agent), then extracts the \u003cstrong\u003etier_reason\u003c\/strong\u003e text.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets\u003c\/strong\u003e: if the tier is new or changed, it updates the supplier row and \u003cstrong\u003eappends a change record\u003c\/strong\u003e to a \u003cstrong\u003eGoogle Sheets audit log\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends alerts\u003c\/strong\u003e: tier-change notifications go out via \u003cstrong\u003eGmail\u003c\/strong\u003e and \u003cstrong\u003eSlack\u003c\/strong\u003e. If there’s no change, it marks the supplier as processed with a standard “no change” reason and sends a no-change summary.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eOperations teams needing \u003cstrong\u003edaily supplier tiering\u003c\/strong\u003e without manual scoring spreadsheets.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators maintaining governance with a persistent \u003cstrong\u003eGoogle Sheets audit log\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eProcurement stakeholders who want \u003cstrong\u003eSlack alerts\u003c\/strong\u003e (and email updates via Gmail) when suppliers move tiers.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIntegrations\/nodes: \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eGroq\u003c\/strong\u003e (LLM via LangChain agent), \u003cstrong\u003eSlack\u003c\/strong\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eLogic\/automation nodes: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, plus a \u003cstrong\u003esticky note\u003c\/strong\u003e for workflow guidance.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eIdeal for n8n users and automation engineers who want a reliable \u003cstrong\u003esupplier scoring automation\u003c\/strong\u003e with clear tier reasoning and real-time team notifications.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45869885554867,"sku":"N8N-18448","price":66.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/TqDpiN_69-vatXjafsxxu_j47w2IOP.png?v=1787130229","url":"https:\/\/buyflowscripts.com\/products\/classify-supplier-tiers-google-sheets-groq-slack-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}