🔓 Unlock all 10,000+ workflows & prompts free Join Newsletter →
✅ Full access unlocked — explore all 10,000 AI workflow and prompt templates Browse Templates →
Home n8n Workflow
January 22, 2026

OpenAI + Airtable: qualify leads, route, reply fast

Lisa Granqvist Partner Workflow Automation Expert

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

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

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.

  1. Add and open Incoming Lead Webhook.
  2. Set Path to lead-intake.
  3. Set HTTP Method to POST.
  4. Set Response Mode to responseNode so 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.

  1. Open Send Intake Acknowledgment and set Respond With to json.
  2. Set Response Body to ={{ { "success": true, "message": "Lead received and processing", "leadId": $json.leadId } }}.
  3. Open Map Lead Attributes and add the following assignments:
  4. Set leadId to ={{ $now.format('yyyyMMddHHmmss') }}-{{ $json.email.split('@')[0] }}.
  5. Set timestamp to ={{ $now.toISO() }}.
  6. 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.

  1. 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 }}.
  2. Ensure Prompt Type is define and Has Output Parser is enabled.
  3. Open Extract AI Score and set Schema Type to manual.
  4. Set Input Schema to the provided JSON schema for score, category, reasoning, recommended_action, key_strengths, and concerns.
  5. Open OpenAI Chat Model and keep the model selection (e.g., gpt-4o-mini) or change to your preferred model.
  6. Credential Required: Connect your openAiApi credentials in OpenAI Chat Model.
  7. 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.

  1. Open Evaluate Lead Quality and set the first condition to compare Left Value ={{ $json.output.score }} with Right Value 70 using Operator larger.
  2. 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.

  1. Open Append Hot Leads Airtable and set Operation to append, Base to YOUR_AIRTABLE_BASE_ID, and Table to YOUR_AIRTABLE_TABLE_ID.
  2. Open Append Nurture Airtable and set Operation to append, Base to YOUR_AIRTABLE_BASE_ID, and Table to YOUR_AIRTABLE_TABLE_ID.
  3. Credential Required: Connect your Airtable credentials in both Append Hot Leads Airtable and Append Nurture Airtable.
  4. Open Slack Team Alert and keep Operation set to send.
  5. Credential Required: Connect your Slack credentials in Slack Team Alert.
  6. 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].
  7. 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].
  8. Credential Required: Connect your SMTP/Email credentials in both Dispatch Hot Lead Email and Dispatch Nurture Email.
  9. 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.

  1. Click Test Workflow and send a sample POST request to the Incoming Lead Webhook URL with lead fields like name, email, company, message, budget, and timeline.
  2. Confirm that Send Intake Acknowledgment returns the JSON response containing success, message, and leadId.
  3. Verify that AI Lead Scoring produces output parsed by Extract AI Score, and that Evaluate Lead Quality routes to the correct Airtable node.
  4. Check Airtable records, Slack notifications, and the outbound email in the correct branch to confirm success.
  5. Once validated, toggle the workflow to Active to enable production processing.
🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

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

What’s the setup time for this AI lead scoring automation?

About 30–60 minutes if your Airtable base and email sender are ready.

Is coding required for this lead scoring automation?

No. You’ll mainly connect accounts and map a few lead fields to match your form.

Is n8n free to use for this AI lead scoring workflow?

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.

Where can I host n8n to run this automation?

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.

Can I modify this AI lead scoring workflow for different use cases?

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.

Why is my Airtable connection failing in this workflow?

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.

What volume can this AI lead scoring workflow process?

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.

Is this AI lead scoring automation better than using Zapier or Make?

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.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

×

Use template

Get instant access to this n8n workflow Json file

💬
Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.

Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.

Launch login modal Launch register modal