n8n Lead Routing Workflow: OpenAI + Airtable + Gmail

Route and qualify inbound SME leads automatically with n8n—OpenAI, Airtable, and Gmail in one workflow

This 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.

What this workflow does

• Receives and normalizes submissions: 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.
• Prevents concurrent duplicates: Claims the submission using workflow static data; if the same submission is already in progress, it short-circuits with a “duplicate” response.
• Handles validation failures: If validation fails, it checks Airtable for an existing submission ID; if needed, it creates a “Dead Letter” lead record and replies to the webhook with the rejection reason.
• Detects existing leads: If the lead already exists in Airtable, it records the existing status in the claim store and responds as a duplicate.
• Escalates sensitive content: When sensitive patterns are detected, it creates a “Needs Review” record in Airtable, emails ops via Gmail with review details, updates Airtable with delivery confirmation, and responds as needs_review.
• Qualifies with OpenAI: 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 Approved or Needs Review record in Airtable.
• Reconciles email delivery hourly: An hourly process sweeps for pending deliveries and retries as needed.

Use cases

• Turning inbound SME inquiries into structured, auditable lead records in Airtable
• Automating human review for sensitive or ambiguous submissions via Gmail notifications
• Protecting your workflow from duplicate webhook submissions with submission-level claiming
• Ensuring email delivery reliability with an hourly reconciliation sweep

Technical details

• Nodes/blocks: webhook, if, code, gmail, airtable, sticky note
• LLM: OpenAI (gpt-4o-mini) for structured qualification
• Storage: Airtable records for Dead Letter, Needs Review, and Approved outcomes
• Notifications: Gmail ops emails with delivery confirmation updates in Airtable