{"product_id":"automate-purchase-requisition-triage-with-n8n-airtable-groq-slack","title":"Automate Purchase Requisition Triage with n8n, Airtable, Groq \u0026 Slack","description":"\u003ch3\u003eInstantly triage purchase requisitions with n8n—using Groq scoring and Slack routing\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors new purchase requisitions in \u003cstrong\u003eAirtable\u003c\/strong\u003e, automatically determines urgency using \u003cstrong\u003eGroq\u003c\/strong\u003e (LLM + keyword rules + department thresholds), logs every decision to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, updates the requisition status in Airtable, and notifies the right team in \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers on submission in Airtable\u003c\/strong\u003e when a requisition is created\/updated, using the \u003cem\u003esubmitted_at\u003c\/em\u003e field.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls Groq LLM\u003c\/strong\u003e with the requisition description to return \u003cstrong\u003estrict JSON\u003c\/strong\u003e: an \u003cstrong\u003eurgency score (1–5)\u003c\/strong\u003e plus short reasoning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApplies critical keyword checks\u003c\/strong\u003e by scanning the requisition description and business justification (e.g., terms like “outage” or “breach”) to produce a keyword-based urgency score.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads department routing rules from a separate Airtable base\u003c\/strong\u003e and computes a \u003cstrong\u003efinal priority score\u003c\/strong\u003e. Cost thresholds can force escalation to a \u003cstrong\u003eVP approval\u003c\/strong\u003e path.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes the request\u003c\/strong\u003e into the appropriate path: \u003cstrong\u003eVP approval\u003c\/strong\u003e, \u003cstrong\u003eauto fast-track\u003c\/strong\u003e, or the standard queue.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates an audit trail\u003c\/strong\u003e by logging scores, routing decision, reason, cost, and metadata to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Airtable\u003c\/strong\u003e with the new status and routing note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends Slack notifications\u003c\/strong\u003e for VP-approval and fast-tracked requisitions to the appropriate channel.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWhen an “outage” or “breach” purchase request arrives, route it immediately to VP approval with documented scoring and rationale.\u003c\/li\u003e\n  \u003cli\u003eReduce manual triage by automatically fast-tracking low-risk, cost-appropriate requests to the standard reviewers.\u003c\/li\u003e\n  \u003cli\u003eEnsure consistent department handling by centralizing routing rules in Airtable.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Nodes:\u003c\/strong\u003e airtable, slack, switch, set, code, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLLM scoring:\u003c\/strong\u003e Groq-hosted model returning strict JSON (urgency 1–5 + reasoning)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRouting logic:\u003c\/strong\u003e Airtable-based department rules + keyword urgency + cost thresholds\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAudit logging:\u003c\/strong\u003e decision details written to Google Sheets\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192856072371,"sku":"N8N-20534","price":52.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Kh28lhtWAMqE7_EQpJOkK_npTxD3r6.png?v=1791537470","url":"https:\/\/buyflowscripts.com\/products\/automate-purchase-requisition-triage-with-n8n-airtable-groq-slack","provider":"N8N Commerce","version":"1.0","type":"link"}