{"product_id":"n8n-lead-routing-workflow-openai-airtable-gmail","title":"n8n Lead Routing Workflow: OpenAI + Airtable + Gmail","description":"\u003ch3\u003eRoute and qualify inbound SME leads automatically with n8n—OpenAI, Airtable, and Gmail in one workflow\u003c\/h3\u003e\n\u003cp\u003eThis n8n Lead Routing Workflow captures incoming SME lead submissions via webhook, validates and deduplicates them to prevent double-processing, classifies the request using OpenAI (gpt-4o-mini), stores outcomes in Airtable, and notifies your ops team through Gmail—plus an hourly sweep to reconcile and retry any pending email deliveries.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives and normalizes submissions:\u003c\/strong\u003e Accepts a POST request on a webhook endpoint, normalizes payload fields into consistent lead data, generates a submission ID, and runs validation and sensitive-content checks.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents concurrent duplicates:\u003c\/strong\u003e Claims the submission using workflow static data; if the same submission is already in progress, it short-circuits with a \u003cem\u003e“duplicate”\u003c\/em\u003e response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles validation failures:\u003c\/strong\u003e If validation fails, it checks Airtable for an existing submission ID; if needed, it creates a \u003cem\u003e“Dead Letter”\u003c\/em\u003e lead record and replies to the webhook with the rejection reason.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects existing leads:\u003c\/strong\u003e If the lead already exists in Airtable, it records the existing status in the claim store and responds as a \u003cem\u003eduplicate\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalates sensitive content:\u003c\/strong\u003e When sensitive patterns are detected, it creates a \u003cem\u003e“Needs Review”\u003c\/em\u003e record in Airtable, emails ops via Gmail with review details, updates Airtable with delivery confirmation, and responds as \u003cem\u003eneeds_review\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQualifies with OpenAI:\u003c\/strong\u003e For non-sensitive leads, it sends the lead’s “needs” text to OpenAI (gpt-4o-mini) for structured qualification, validates the model output, and creates either an \u003cem\u003eApproved\u003c\/em\u003e or \u003cem\u003eNeeds Review\u003c\/em\u003e record in Airtable.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReconciles email delivery hourly:\u003c\/strong\u003e An hourly process sweeps for pending deliveries and retries as needed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTurning inbound SME inquiries into structured, auditable lead records in Airtable\u003c\/li\u003e\n  \u003cli\u003eAutomating human review for sensitive or ambiguous submissions via Gmail notifications\u003c\/li\u003e\n  \u003cli\u003eProtecting your workflow from duplicate webhook submissions with submission-level claiming\u003c\/li\u003e\n  \u003cli\u003eEnsuring email delivery reliability with an hourly reconciliation sweep\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/blocks:\u003c\/strong\u003e webhook, if, code, gmail, airtable, sticky note\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLLM:\u003c\/strong\u003e OpenAI (gpt-4o-mini) for structured qualification\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStorage:\u003c\/strong\u003e Airtable records for Dead Letter, Needs Review, and Approved outcomes\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifications:\u003c\/strong\u003e Gmail ops emails with delivery confirmation updates in Airtable\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45756676243635,"sku":"N8N-17741","price":60.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ya2roSo6szgYK5pGJUmUz_Vq22rlNd.png?v=1785748089","url":"https:\/\/buyflowscripts.com\/products\/n8n-lead-routing-workflow-openai-airtable-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}