Generate qualified leads from LinkedIn with Apify, GPT-4, and Airtable
Needs changesWhat this workflow does
This AI workflow has 16 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Airtable and OpenAI Chat Model. It also calls api.apify.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Edit Variables (Edit Fields (Set)): sets 3 fields: linkedinUrls, maxEmployees, batchSize
- Scrape LinkedIn Jobs (HTTP Request): calls api.apify.com (POST)
- Split Job Data (Split Out): splits a list into separate items
- Remove Duplicates: removes duplicate items
- Clean Data Format (Edit Fields (Set)): sets 12 fields: company_name, title, job_link…
- Get Existing Leads (Airtable): search
- Categorize Leads (Code): runs custom JavaScript code
- Route Leads (Switch): routes items into 3 branches
- Filter: keeps only the items that match a condition
- Process in Batches (Loop Over Items (Split in Batches)): loops over the items in batches
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: api.apify.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Lead Analyzer (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Lead Analyzer (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (14)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Split Out
n8n-nodes-base.splitOut - Remove Duplicates
n8n-nodes-base.removeDuplicates - Airtable
n8n-nodes-base.airtable - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - Filter
n8n-nodes-base.filter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - No Operation, do nothing
n8n-nodes-base.noOp
From the author
Who is this for? This workflow is perfect for sales teams, business development professionals, recruitment agencies, and fractional CFO service providers who need to identify and qualify companies actively hiring. Whether you're prospecting for new clients,…