{"product_id":"n8n-workflow-triage-project-requests-with-airtable-openai","title":"n8n Workflow: Triage Project Requests with Airtable + OpenAI","description":"\u003ch3\u003eTriage incoming project requests automatically—using Airtable + OpenAI—with optional Slack approval and weekly email summaries\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives project requests via a webhook, validates the minimum brief, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to generate a triage summary and classification, scores risk\/urgency, and stores the results in \u003cstrong\u003eAirtable\u003c\/strong\u003e. If items are high-risk, it can route them to \u003cstrong\u003eSlack\u003c\/strong\u003e for approval and update the Airtable record with the decision and next steps.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAccepts requests via POST webhook\u003c\/strong\u003e (or uses a manual test payload) and normalizes incoming fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates required brief details\u003c\/strong\u003e; if missing, returns a \u003cstrong\u003e400\u003c\/strong\u003e response with which fields are absent and clarification questions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls OpenAI\u003c\/strong\u003e to produce a triage summary and classification, extracting risks, dependencies, decisions, and a recommended owner type.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApplies deterministic scoring\u003c\/strong\u003e to compute risk and urgency and determine the triage route.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a new Airtable triage record\u003c\/strong\u003e containing the request details, summary, score, and routing information.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes approvals when needed\u003c\/strong\u003e: if the score exceeds the approval threshold, it prepares an approval message (optionally posts to \u003cstrong\u003eSlack\u003c\/strong\u003e), records the approval outcome, and assigns or marks as declined.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFinalizes the structured delivery handoff\u003c\/strong\u003e, updates Airtable with owner\/status\/next action, and responds to the webhook caller with the triage result.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly schedule support\u003c\/strong\u003e: loads open triage records, builds an operational summary, and can send an optional weekly summary email.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCentralize project intake from a form into a consistent triage pipeline.\u003c\/li\u003e\n  \u003cli\u003eStandardize how SaaS teams evaluate risks and urgency before assigning owners.\u003c\/li\u003e\n  \u003cli\u003eRequire Slack-based approval for high-risk work while keeping Airtable as the source of truth.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook, if, set, code, no op\u003c\/strong\u003e for validation, routing, and data shaping.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e for triage summary, classification, and extracted fields (risks\/dependencies\/decisions\/owner type).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAirtable\u003c\/strong\u003e for storing triage records and updating status\/next actions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e for optional approval routing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e for the optional weekly summary email.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45837465682099,"sku":"N8N-18253","price":29.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7KJAiq4xmK-L4P0XRW76M_2kaHqhxX.png?v=1786794723","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-triage-project-requests-with-airtable-openai","provider":"N8N Commerce","version":"1.0","type":"link"}