OpenAI + Airtable: qualify leads, route, reply fast
Leads come in fast, but follow-up doesn’t. And when you’re manually reading every message, guessing who’s “hot,” then copying details into a tracker, you will miss good opportunities.
Marketing managers feel it when campaign volume spikes. Sales reps feel it when they’re stuck doing admin instead of calling. Founders feel it because AI lead scoring automation is the difference between “we’re on it” and “sorry for the late reply.”
This workflow captures every inbound lead, scores it with OpenAI, logs it to Airtable, and sends the right email response automatically. You’ll see how it works, what you need, and the key places to customize it.
How This Automation Works
Here’s the complete workflow you’ll be setting up:
n8n Workflow Template: OpenAI + Airtable: qualify leads, route, reply fast
flowchart LR
subgraph sg0["AI Lead Qualificatio Flow"]
direction LR
n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/webhook.dark.svg' width='40' height='40' /></div><br/>Lead Intake Webhook"]
n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/webhook.dark.svg' width='40' height='40' /></div><br/>Acknowledge Receipt"]
n2@{ icon: "mdi:swap-vertical", form: "rounded", label: "Enrich Lead Data", pos: "b", h: 48 }
n3@{ icon: "mdi:robot", form: "rounded", label: "AI Lead Qualification", pos: "b", h: 48 }
n4@{ icon: "mdi:robot", form: "rounded", label: "Parse AI Response", pos: "b", h: 48 }
n5@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Model", pos: "b", h: 48 }
n6@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Route by Quality", pos: "b", h: 48 }
n7["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/airtable.svg' width='40' height='40' /></div><br/>Save to Airtable (Hot Leads)"]
n8["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/airtable.svg' width='40' height='40' /></div><br/>Save to Airtable (Nurture Qu.."]
n9["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/slack.svg' width='40' height='40' /></div><br/>Alert Team (Slack)"]
n10@{ icon: "mdi:message-outline", form: "rounded", label: "Send Confirmation Email (Hot)", pos: "b", h: 48 }
n11@{ icon: "mdi:message-outline", form: "rounded", label: "Send Nurture Email", pos: "b", h: 48 }
n5 -.-> n3
n2 --> n3
n6 --> n7
n6 --> n8
n4 -.-> n3
n1 --> n2
n0 --> n1
n3 --> n6
n7 --> n9
n7 --> n10
n8 --> n11
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n3,n4 ai
class n5 aiModel
class n6 decision
class n7,n8 database
class n0,n1 api
classDef customIcon fill:none,stroke:none
class n0,n1,n7,n8,n9 customIcon
Why This Matters: Slow follow-up kills good leads
Most teams don’t lose leads because they’re bad at selling. They lose leads because the first 30 minutes after an inquiry is chaos. The message lands in a form tool, someone checks it later, then it gets forwarded, then someone asks “did we reply yet?” Meanwhile the lead is still shopping, and the fastest responder often wins. Add in manual scoring and copy-paste CRM updates and you’re doing high-friction work at the exact moment you need speed and clarity.
It adds up fast. Here’s where it breaks down.
- Leads sit untriaged for hours because nobody owns the first review.
- “Hot lead” gets defined differently by every person, so routing becomes inconsistent.
- Manual CRM entry is easy to postpone, which means reporting gets messy and follow-ups slip.
- Reply emails get written from scratch, so the tone varies and the team wastes time reinventing the same message.
What You’ll Build: AI qualification, Airtable logging, instant replies
This automation starts the moment a lead hits your webhook (from a form, landing page, ad platform, or anything that can send data). n8n immediately sends a quick intake acknowledgment so the lead knows you received their message. Then it maps the lead fields into a clean structure and hands the content to OpenAI for analysis. The AI returns a scored evaluation (0–100) plus reasoning, strengths, and concerns. Based on that score, the workflow routes the lead down the right path: hot leads get logged in Airtable, the sales team gets alerted in Slack, and the lead receives a “high-intent” email. Lower-scoring leads still get logged and still get a reply, but with a nurture-style response so nothing gets dropped.
The workflow kicks off with webhook capture and an instant acknowledgment. OpenAI then handles qualification and structured scoring. Finally, Airtable becomes your tracking layer while email and Slack handle fast response and routing.
What You’re Building
| What Gets Automated | What You’ll Achieve |
|---|---|
|
|
Expected Results
Say you get 20 inbound leads a day. Manually, it’s maybe 5 minutes to read and judge each one, plus another 3 minutes to log it and send a decent reply, which is about 2.5 hours daily. With this workflow, the manual work becomes close to zero after setup: the lead submits, the AI score and routing run in under 30 seconds, and Airtable plus email are handled automatically. That’s roughly 2 hours back every day, and your “hot” leads get contacted while they’re still paying attention.
Before You Start
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Airtable for storing hot/nurture lead records.
- OpenAI to analyze and score each inquiry.
- OpenAI API key (get it from your OpenAI dashboard).
Skill level: Beginner. You’ll connect accounts, paste a webhook URL into your form tool, and adjust a few fields and emails.
Want someone to build this for you? Talk to an automation expert (free 15-minute consultation).
Step by Step
A lead hits your webhook. Your form or landing page sends the lead details (name, email, message, and any extra fields) into n8n via the “Incoming Lead Webhook” node.
The lead gets an instant acknowledgment. n8n replies immediately using “Respond to Webhook,” which means your lead sees a confirmation even if your team is in meetings.
OpenAI scores and explains the lead. The workflow maps fields into a consistent structure, runs the “AI Lead Scoring” step using an OpenAI chat model, then extracts a clean score and reasoning with a structured output parser.
Routing, logging, and follow-up happen automatically. If the lead is 70+ it’s treated as hot, logged to Airtable, and your team gets a Slack alert plus a fast sales-focused email. Otherwise it goes into the nurture table (or view) in Airtable and receives a different reply that sets expectations and keeps the conversation moving.
You can easily modify the scoring threshold and the email wording based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Webhook Trigger
Set up the entry point that receives incoming lead data and initiates the workflow.
- Add and open Incoming Lead Webhook.
- Set Path to
lead-intake. - Set HTTP Method to
POST. - Set Response Mode to
responseNodeso the reply is sent by Send Intake Acknowledgment.
Step 2: Send an Intake Acknowledgment and Map Lead Attributes
Return a quick response to the requester and normalize lead fields for downstream processing.
- Open Send Intake Acknowledgment and set Respond With to
json. - Set Response Body to
={{ { "success": true, "message": "Lead received and processing", "leadId": $json.leadId } }}. - Open Map Lead Attributes and add the following assignments:
- Set leadId to
={{ $now.format('yyyyMMddHHmmss') }}-{{ $json.email.split('@')[0] }}. - Set timestamp to
={{ $now.toISO() }}. - Set source to
={{ $json.source || 'website' }}.
Step 3: Set Up the AI Lead Scoring Chain
Configure the AI scoring chain that analyzes lead content, parses the result, and generates a structured score.
- Open AI Lead Scoring and set Text to
=Analyze this lead and provide a qualification score: Name: {{ $json.name }} Email: {{ $json.email }} Company: {{ $json.company }} Message: {{ $json.message }} Budget: {{ $json.budget }} Timeline: {{ $json.timeline }}. - Ensure Prompt Type is
defineand Has Output Parser is enabled. - Open Extract AI Score and set Schema Type to
manual. - Set Input Schema to the provided JSON schema for
score,category,reasoning,recommended_action,key_strengths, andconcerns. - Open OpenAI Chat Model and keep the model selection (e.g.,
gpt-4o-mini) or change to your preferred model. - Credential Required: Connect your
openAiApicredentials in OpenAI Chat Model. - Note: Extract AI Score is an AI sub-node; credentials must be added to the parent language model, OpenAI Chat Model.
Step 4: Configure Lead Quality Routing
Route leads into hot or nurture paths based on the AI score.
- Open Evaluate Lead Quality and set the first condition to compare Left Value
={{ $json.output.score }}with Right Value70using Operatorlarger. - Review the second condition row, which currently has empty Left Value and Right Value, and remove or complete it based on your own rules.
⚠️ Common Pitfall: Leaving empty condition values in Evaluate Lead Quality can cause unexpected routing. Remove unused conditions or define them clearly.
Step 5: Configure Airtable and Notification Outputs
Store qualified and nurture leads in Airtable and notify your team and prospects via Slack and email.
- Open Append Hot Leads Airtable and set Operation to
append, Base toYOUR_AIRTABLE_BASE_ID, and Table toYOUR_AIRTABLE_TABLE_ID. - Open Append Nurture Airtable and set Operation to
append, Base toYOUR_AIRTABLE_BASE_ID, and Table toYOUR_AIRTABLE_TABLE_ID. - Credential Required: Connect your Airtable credentials in both Append Hot Leads Airtable and Append Nurture Airtable.
- Open Slack Team Alert and keep Operation set to
send. - Credential Required: Connect your Slack credentials in Slack Team Alert.
- Open Dispatch Hot Lead Email and set Subject to
Thank you for your inquiry - We'll be in touch soon!, To Email to={{ $('Incoming Lead Webhook').item.json.email }}, and From Email to[YOUR_EMAIL]. - Open Dispatch Nurture Email and set Subject to
Thank you for contacting us, To Email to={{ $('Incoming Lead Webhook').item.json.email }}, and From Email to[YOUR_EMAIL]. - Credential Required: Connect your SMTP/Email credentials in both Dispatch Hot Lead Email and Dispatch Nurture Email.
- Confirm the parallel branch: Append Hot Leads Airtable outputs to both Slack Team Alert and Dispatch Hot Lead Email in parallel.
Step 6: Test and Activate Your Workflow
Validate the end-to-end flow and move the workflow into production.
- Click Test Workflow and send a sample POST request to the Incoming Lead Webhook URL with lead fields like
name,email,company,message,budget, andtimeline. - Confirm that Send Intake Acknowledgment returns the JSON response containing
success,message, andleadId. - Verify that AI Lead Scoring produces output parsed by Extract AI Score, and that Evaluate Lead Quality routes to the correct Airtable node.
- Check Airtable records, Slack notifications, and the outbound email in the correct branch to confirm success.
- Once validated, toggle the workflow to Active to enable production processing.
Troubleshooting Tips
- Airtable credentials can expire or need specific permissions. If things break, check your Airtable personal access token scopes and the base/table access first.
- If you’re sending a lot of leads at once (like a webinar signup spike), OpenAI or email providers can rate-limit you. Add batching or a short delay so downstream nodes don’t fail under load.
- Default AI prompts are generic. Bake in what “qualified” means for your business (budget floor, timeline, target industry) or you’ll spend your time second-guessing scores.
Quick Answers
About 30–60 minutes if your Airtable base and email sender are ready.
No. You’ll mainly connect accounts and map a few lead fields to match your form.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs, which are usually a few cents per lead depending on your prompt and model.
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
Yes, and you should. You can change the qualification rules inside the “AI Lead Scoring” step (the prompt) and adjust the cutoff in “Evaluate Lead Quality” (the 70+ hot lead logic). Common tweaks include routing by service line, sending different nurture replies by industry, and adding extra Airtable fields like source campaign or UTM tags.
Usually it’s a permissions issue with the Airtable token, or the base/table IDs changed since you first connected it. Re-check the credentials in n8n, then confirm the exact table names used in “Append Hot Leads Airtable” and “Append Nurture Airtable.” If the workflow runs but fields are blank, it’s often a mapping mismatch from “Map Lead Attributes,” not Airtable itself.
On most setups, dozens of leads per minute is realistic; the main limiter is OpenAI and your email provider. n8n Cloud plans cap executions by tier, while self-hosting has no execution limit (it depends on your server). If you expect big spikes, add batching and consider separating hot-lead routing into its own workflow.
Often, yes, especially once you want structured AI output and more nuanced branching. n8n makes it easier to keep everything in one workflow: webhook intake, an immediate acknowledgment response, an AI scoring step, then two different database writes and two different email paths. You also get a self-host option, which is helpful if lead volume climbs and per-task pricing starts to sting. Zapier or Make can still be great for quick, two-step automations, and their UI can feel simpler at first. If you’re on the fence, Talk to an automation expert and you’ll get a straight recommendation.
Once this is live, leads get handled in seconds, not “whenever someone has time.” The workflow takes the repetitive sorting and replying off your plate so you can focus on the conversations that actually close.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.