Qualify and route consulting leads with OpenAI, Airtable, and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 49 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Airtable, Gmail and OpenAI.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Normalize Intake (Code): runs custom JavaScript code
- Find Pending Lead Deliveries (Airtable): search
- Claim Submission (Code): runs custom JavaScript code
- Build Pending Lead Deliveries (Code): runs custom JavaScript code
- Claim Duplicate? (If): checks a condition and branches into true / false
- Send Pending Lead Delivery (Gmail): uses Gmail
- Respond Duplicate (Respond to Webhook): sends the response back to the webhook caller
- Invalid Input? (If): checks a condition and branches into true / false
- Build Reconciled Delivery Confirmation (Code): runs custom JavaScript code
- Build Dead Letter Record (Code): runs custom JavaScript code
…plus 37 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Airtable
n8n-nodes-base.airtable - Respond to Webhook
n8n-nodes-base.respondToWebhook - Gmail
n8n-nodes-base.gmail - OpenAI
@n8n/n8n-nodes-langchain.openAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview This workflow captures inbound SME leads via a webhook, validates and deduplicates submissions, classifies the request with OpenAI, stores results in Airtable, and sends internal notifications through Gmail, with an hourly reconciliation sweep…