Airtable + Instantly.ai: enriched leads, ready to send
Your lead list is growing, but your outreach quality isn’t. You’re copying LinkedIn snippets, guessing at “personalization,” and still shipping emails that sound like everyone else’s.
This Airtable Instantly.ai automation hits growth marketers first because volume exposes every weak process. Sales operators feel it when reps start freelancing their own templates. And agency teams running outbound for clients? They get crushed by the research-to-send gap.
This workflow takes new Airtable leads, enriches them with real company and LinkedIn signals, generates clean variables plus a strong opener, and pushes everything into Instantly.ai so your sequence is ready to launch.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Airtable + Instantly.ai: enriched leads, ready to send
flowchart LR
subgraph sg0["Determine Valuable U Flow"]
direction LR
n0@{ icon: "mdi:swap-vertical", form: "rounded", label: "Configure Variables", pos: "b", h: 48 }
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/>Webhook"]
n2["<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/code.svg' width='40' height='40' /></div><br/>Turn X Items Into 1"]
n3@{ icon: "mdi:robot", form: "rounded", label: "Determine Valuable URLs", pos: "b", h: 48 }
n4@{ icon: "mdi:swap-vertical", form: "rounded", label: "Split Out", pos: "b", h: 48 }
n5["<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/httprequest.dark.svg' width='40' height='40' /></div><br/>HTTP Request"]
n6@{ icon: "mdi:cog", form: "rounded", label: "Aggregate", 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/code.svg' width='40' height='40' /></div><br/>Remove HTML Homepage"]
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/code.svg' width='40' height='40' /></div><br/>Remove HTML Webpages"]
n9@{ icon: "mdi:robot", form: "rounded", label: "Analyze Company/Mission", pos: "b", h: 48 }
n10@{ icon: "mdi:robot", form: "rounded", label: "Analyze Offerings & Position..", pos: "b", h: 48 }
n11@{ icon: "mdi:robot", form: "rounded", label: "Analyze Process & Differenti..", pos: "b", h: 48 }
n12@{ icon: "mdi:robot", form: "rounded", label: "Analyze Proof Of Success", pos: "b", h: 48 }
n13["<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/code.svg' width='40' height='40' /></div><br/>Remove Duplicates Texts C/M"]
n14["<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/code.svg' width='40' height='40' /></div><br/>Remove Duplicates Texts O/P"]
n15["<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/code.svg' width='40' height='40' /></div><br/>Remove Duplicates Texts P/D"]
n16["<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/code.svg' width='40' height='40' /></div><br/>Remove Duplicates Texts PoS"]
n17["<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/>Pull Lead From Airtable"]
n18@{ icon: "mdi:robot", form: "rounded", label: "Analyze Company LinkedIn", pos: "b", h: 48 }
n19["<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/httprequest.dark.svg' width='40' height='40' /></div><br/>LinkedIn Profile Scraper"]
n20["<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/code.svg' width='40' height='40' /></div><br/>JSON Into Text"]
n21@{ icon: "mdi:robot", form: "rounded", label: "Analyze Personal LinkedIn", pos: "b", h: 48 }
n22["<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/httprequest.dark.svg' width='40' height='40' /></div><br/>Company Homepage Scraper"]
n23["<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/code.svg' width='40' height='40' /></div><br/>Check If Empty"]
n24@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Unable To Scrape Website?", pos: "b", h: 48 }
n25["<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/>Update Lead W/ Enrichment"]
n26@{ icon: "mdi:swap-horizontal", form: "rounded", label: "US: Yes or No?", pos: "b", h: 48 }
n27@{ icon: "mdi:swap-horizontal", form: "rounded", label: "B2B: Yes or No?", pos: "b", h: 48 }
n28@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Headcount: 5, 30?", pos: "b", h: 48 }
n29["<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/httprequest.dark.svg' width='40' height='40' /></div><br/>LinkedIn Company Scraper"]
n30["<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/code.svg' width='40' height='40' /></div><br/>Remove HTML LinkedIn Page"]
n31["<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/>Update Lead - Not US"]
n32["<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/>Update Lead - Not B2B"]
n33["<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/>Update Lead - Too Big or Small"]
n34["<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/httprequest.dark.svg' width='40' height='40' /></div><br/>Email Validation - NeverBounce"]
n35@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Email Valid?", pos: "b", h: 48 }
n36["<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/>Update Lead - No Valid Email"]
n37@{ icon: "mdi:cog", form: "rounded", label: "Wait", pos: "b", h: 48 }
n38@{ icon: "mdi:robot", form: "rounded", label: "Analyze Company LinkedIn_", pos: "b", h: 48 }
n39["<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/code.svg' width='40' height='40' /></div><br/>Filter HTML For URLs"]
n40@{ icon: "mdi:robot", form: "rounded", label: "Determine Variables", pos: "b", h: 48 }
n41@{ icon: "mdi:robot", form: "rounded", label: "Determine Variables.", pos: "b", h: 48 }
n42["<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/>Update Lead W/ Enrichment."]
n43["<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/httprequest.dark.svg' width='40' height='40' /></div><br/>Upload Lead To Instantly."]
n44["<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/httprequest.dark.svg' width='40' height='40' /></div><br/>Upload Lead To Instantly"]
n45@{ icon: "mdi:robot", form: "rounded", label: "Clean Company Name", pos: "b", h: 48 }
n46@{ icon: "mdi:robot", form: "rounded", label: "Clean Company Name.", pos: "b", h: 48 }
n47["<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/httprequest.dark.svg' width='40' height='40' /></div><br/>Scrape Personal LinkedIn Posts"]
n48@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Posts Available?", pos: "b", h: 48 }
n49@{ icon: "mdi:robot", form: "rounded", label: "Craft Opening Line - Posts", pos: "b", h: 48 }
n50["<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/code.svg' width='40' height='40' /></div><br/>Merge Posts To 1 Item"]
n51@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Suitable Posts?", pos: "b", h: 48 }
n52["<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/>Update Lead W/ Enrichment - .."]
n53["<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/httprequest.dark.svg' width='40' height='40' /></div><br/>Upload Lead To Instantly - L.."]
n54@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Posts Available?.", pos: "b", h: 48 }
n55@{ icon: "mdi:robot", form: "rounded", label: "Craft Opening Line - Posts.", pos: "b", h: 48 }
n56@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Suitable Posts?.", pos: "b", h: 48 }
n57["<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/>Update Lead W/ Enrichment. -.."]
n58["<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/httprequest.dark.svg' width='40' height='40' /></div><br/>Upload Lead To Instantly. - .."]
n37 --> n29
n1 --> n0
n6 --> n8
n4 --> n5
n35 --> n26
n35 --> n36
n5 --> n6
n23 --> n24
n20 --> n21
n26 --> n37
n26 --> n31
n27 --> n28
n27 --> n32
n51 --> n53
n51 --> n52
n51 --> n25
n51 --> n44
n48 --> n49
n48 --> n25
n48 --> n44
n56 --> n58
n56 --> n57
n56 --> n42
n56 --> n43
n54 --> n55
n54 --> n42
n54 --> n43
n45 --> n40
n46 --> n41
n0 --> n17
n40 --> n48
n28 --> n18
n28 --> n33
n2 --> n3
n41 --> n54
n39 --> n2
n7 --> n23
n8 --> n13
n50 --> n22
n9 --> n14
n3 --> n4
n17 --> n34
n18 --> n19
n12 --> n46
n22 --> n7
n29 --> n30
n19 --> n20
n38 --> n27
n21 --> n47
n30 --> n38
n24 --> n45
n24 --> n39
n49 --> n51
n55 --> n56
n13 --> n9
n14 --> n10
n15 --> n11
n16 --> n12
n34 --> n35
n47 --> n50
n10 --> n15
n11 --> n16
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,n9,n10,n11,n12,n18,n21,n38,n40,n41,n45,n46,n49,n55 ai
class n24,n26,n27,n28,n35,n48,n51,n54,n56 decision
class n17,n25,n31,n32,n33,n36,n42,n52,n57 database
class n1,n5,n19,n22,n29,n34,n43,n44,n47,n53,n58 api
class n2,n7,n8,n13,n14,n15,n16,n20,n23,n30,n39,n50 code
classDef customIcon fill:none,stroke:none
class n1,n2,n5,n7,n8,n13,n14,n15,n16,n17,n19,n20,n22,n23,n25,n29,n30,n31,n32,n33,n34,n36,n39,n42,n43,n44,n47,n50,n52,n53,n57,n58 customIcon
The Problem: Personalization That Doesn’t Scale
Cold outreach breaks down in a very predictable place: the “research” step that sits between “new lead” and “email sent.” Someone has to check if the email is valid, skim the website, find the right positioning, peek at LinkedIn activity, then turn that into variables your sequence can actually use. Do it manually and you burn hours every week. Rush it and you get vague openers, wrong assumptions, and embarrassing mistakes. Worst of all, you can’t fix it with a scheduler or a CRM reminder, because the hard part is the thinking you’re trying to systemize.
The friction compounds.
- You end up with “personalization” that’s basically a company name swap, so replies stay low even when your list is strong.
- Reps and assistants research in different ways, which means your variables are inconsistent and your templates slowly fall apart.
- Bad emails slip in, bounces spike, and deliverability becomes a weekly fire drill.
- By the time a lead is enriched, it’s already stale, and the best prospects get contacted too late.
The Solution: Airtable-to-Instantly Enrichment With AI Variables
This workflow starts the moment a new lead lands in Airtable through a webhook trigger. It validates the email, filters out contacts that don’t match your basic targeting rules (like geography and headcount), then enriches the record by scraping the company site and LinkedIn data through Apify. After that, it uses OpenAI models to clean up messy text (think: stripping HTML) and turn raw pages into structured insights you can actually use. Finally, it generates ready-to-drop Instantly variables (company specialty, ICP fit, pain points, proof points) plus a strong opener based on recent LinkedIn posts when available. The enriched lead updates back in Airtable, then gets pushed into Instantly.ai so your campaign can run without hand-editing every record.
Airtable triggers the run. Apify and HTTP requests gather real-world context. OpenAI synthesizes and writes the pieces your outreach needs. Instantly.ai receives the lead with clean fields, so your sequence renders correctly on send day.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you add 20 new leads per day to Airtable. Manually, if you spend about 10 minutes validating, skimming the site, checking LinkedIn, and writing a decent opener, that’s roughly 3 hours a day. With this workflow, you drop the lead into Airtable once, then wait for enrichment to complete in the background (often 10–20 minutes depending on scraping). Your “work” becomes a quick spot-check and hitting send in Instantly.ai. Most teams get a couple hours back daily at that volume.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Airtable for lead intake and CRM fields.
- Instantly.ai to run outbound sequences with variables.
- Apify to scrape LinkedIn and site content.
- OpenAI API key (get it from the OpenAI dashboard).
- NeverBounce for email validation (API access required).
Skill level: Intermediate. You’ll connect a few accounts, map fields, and test runs with sample leads.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
Airtable lead comes in. A webhook triggers the workflow when a new record is created (or updated into a “ready to enrich” state), pulling basics like name, email, company, and URLs.
Qualification happens early. NeverBounce checks deliverability, then simple rules filter out leads that don’t match your targeting (for example, US-only or headcount between roughly 5 and 30). This prevents wasting scrape time and model calls.
Scraping collects real context. Apify pulls company and personal LinkedIn data, recent posts when available, plus key website pages. n8n cleans the text (removing HTML and extra noise) so the AI isn’t guessing from junk.
AI turns raw text into usable fields. OpenAI nodes summarize positioning, proof, differentiation, and create outreach variables. If posts exist, the opener is built from that; otherwise it falls back to company-based personalization that still sounds human.
Instantly.ai gets the finished lead. The workflow updates Airtable for record-keeping, then pushes the enriched lead and variables into Instantly.ai so your sequence can send with the right merge fields.
You can easily modify the qualification rules to match your ICP, so you’re enriching fewer leads but with higher intent. See the full implementation guide below for customization options.
Common Gotchas
- Airtable credentials can expire or lack base access. If the workflow suddenly stops finding records, check your Airtable personal access token scopes and the base permissions first.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.
Frequently Asked Questions
About 60–90 minutes if your accounts and fields are ready.
No. You’ll mostly map fields and connect accounts in n8n. The “hard” part is deciding what you want the variables to say.
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 (often a few cents per lead) plus Apify and NeverBounce usage.
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. Swap the qualification checks (US and headcount rules) and adjust the “Determine Variables” prompts to match your ICP language, offer, and proof points. Many teams also change the “valuable URLs” selection so the workflow prioritizes pages like case studies or pricing. If you’re in a regulated niche, you can force the AI to only use scraped facts and to avoid making claims.
Usually it’s expired credentials or missing base permissions. Regenerate your Airtable token (or re-auth) and confirm the base, table, and field names still match what the workflow expects. If only some runs fail, it can also be a webhook change or a record missing a required URL field.
It can handle hundreds or thousands per month, but scraping and AI costs become your real limiter.
Often, yes, if you care about richer logic and consistent outputs. This workflow has a lot of branching (qualification, “posts available” fallbacks, multi-stage analysis), and n8n handles that cleanly without forcing you into pricey task counts for every little step. Self-hosting is also a big deal when you want higher volume without surprise bills. Zapier or Make can still win for very small setups, especially if you only need “Airtable record → Instantly lead” with minimal enrichment. If you’re torn, Talk to an automation expert and you’ll get a straight recommendation.
Once this is running, your “new lead” pipeline stops being a research project. The workflow does the digging and formatting, and you get clean Instantly-ready leads that actually sound like you meant to email them.
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.