{"product_id":"lead-intake-webhook-to-airtable-slack-routing-n8n-workflow","title":"Lead Intake Webhook to Airtable + Slack Routing (n8n Workflow)","description":"\u003ch3\u003eTurn every lead submission into an Airtable record and the right Slack alert—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e receives leads via a secured \u003cstrong\u003ewebhook\u003c\/strong\u003e, validates and de-duplicates them against \u003cstrong\u003eAirtable\u003c\/strong\u003e, saves new leads, and then posts to the correct \u003cstrong\u003eSlack\u003c\/strong\u003e channel based on programme—returning clear HTTP responses for each outcome.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives lead data\u003c\/strong\u003e via a POST request to the \u003cstrong\u003e\/lead-intake\u003c\/strong\u003e webhook using \u003cstrong\u003eheader-based authentication\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes and validates fields\u003c\/strong\u003e (from \u003cem\u003ebody\u003c\/em\u003e or root). If required details are missing or invalid, it responds with \u003cstrong\u003eHTTP 400\u003c\/strong\u003e and error details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDe-duplicates leads\u003c\/strong\u003e by searching Airtable for an existing record where the \u003cstrong\u003eEmail\u003c\/strong\u003e field matches the submitted email.\u003c\/li\u003e\n  \u003cli\u003eIf a match is found, it returns \u003cstrong\u003eHTTP 200\u003c\/strong\u003e with a \u003cstrong\u003eduplicate\u003c\/strong\u003e response and stops.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates new leads in Airtable\u003c\/strong\u003e with the submitted details plus routing metadata.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes Slack notifications\u003c\/strong\u003e: enquiries with \u003cstrong\u003e“Computer Science”\u003c\/strong\u003e go to a priority Slack channel; all others go to a general Slack channel, then returns \u003cstrong\u003eHTTP 200\u003c\/strong\u003e for \u003cstrong\u003ecreated\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf the Airtable lookup or create fails, it posts an \u003cstrong\u003ealert to a Slack failure\/monitoring channel\u003c\/strong\u003e and returns \u003cstrong\u003eHTTP 500\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCapture form\/app lead submissions and instantly register them in your Airtable \u003cem\u003eLeads\u003c\/em\u003e table.\u003c\/li\u003e\n  \u003cli\u003ePrevent duplicate lead spam by matching on Email before creating records.\u003c\/li\u003e\n  \u003cli\u003eRoute urgent “Computer Science” enquiries to a priority Slack channel for faster follow-up.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/logic used:\u003c\/strong\u003e webhook, if, set, switch, airtable, slack.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Airtable via \u003cstrong\u003ePersonal Access Token\u003c\/strong\u003e; Slack channel notifications.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements:\u003c\/strong\u003e configure header-auth token, update Airtable base\/table IDs, and ensure Airtable fields include \u003cstrong\u003eName, Email, Phone, Country\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46072075681971,"sku":"N8N-19809","price":73.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/cTMNbeeTsOUCYVoKFL4tS_FogUtwCL.png?v=1790067778","url":"https:\/\/buyflowscripts.com\/products\/lead-intake-webhook-to-airtable-slack-routing-n8n-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}