This workflow corresponds to n8n.io template #3616 — we link there as the canonical source.
This workflow follows the Airtable → Chainllm recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "eXBhltwQduIDLMjB",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "LeadAIgen-basic",
"tags": [
{
"id": "TEMPLATE-EXPORT",
"name": "LEAD-GEN",
"createdAt": "2025-03-28T13:33:06.236Z",
"updatedAt": "2025-03-28T13:33:06.236Z"
}
],
"nodes": [
{
"id": "464a14da-f8fa-4205-b2bc-0a0b1d31dd24",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-40,
-160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "b48bc267-266b-4236-8231-5b4d8f31d281",
"name": "Leads List",
"type": "n8n-nodes-base.googleSheets",
"position": [
1700,
60
],
"parameters": {},
"executeOnce": false,
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "e2ca65c2-cb6e-4c3d-bc29-63d4983b0c83",
"name": "If",
"type": "n8n-nodes-base.if",
"position": [
1520,
-160
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "2dbfacda-643b-471d-a38f-243fee1e9ed6",
"name": "OpenRouter Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
1760,
-120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2cb450d8-ad24-469e-80ed-3771d1bfcaea",
"name": "Company Finder",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
1780,
-280
],
"parameters": {},
"typeVersion": 1.5
},
{
"id": "07db9a00-aecb-47d7-8914-0f2d83ec57d3",
"name": "Code2",
"type": "n8n-nodes-base.code",
"position": [
2140,
-280
],
"parameters": {},
"typeVersion": 2
},
{
"id": "c16ac18b-d3ca-493f-a838-662321ecaf01",
"name": "Leads List2",
"type": "n8n-nodes-base.googleSheets",
"position": [
2620,
-400
],
"parameters": {},
"executeOnce": false,
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "f26e2dd3-7a85-405e-b3c1-5cd20cf9886c",
"name": "If1",
"type": "n8n-nodes-base.if",
"position": [
2360,
-280
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "b46def02-afa9-4583-b7e3-b88a0df4c0a2",
"name": "Leads List3",
"type": "n8n-nodes-base.googleSheets",
"position": [
2640,
-220
],
"parameters": {},
"executeOnce": false,
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "d1f35c06-a77c-4a2e-911f-17cf744e9efd",
"name": "When chat message received",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
-60,
-1300
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "60f5ca94-5357-4e67-b0d9-20bc262e2fe8",
"name": "OpenRouter Chat Model1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
700,
-1000
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9698dd12-6f9f-43cd-92ef-06dc19195f19",
"name": "Company Finder1",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
440,
-1300
],
"parameters": {},
"typeVersion": 1.5
},
{
"id": "2a989d70-c8b3-4a63-896f-dad2f351d9bb",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"position": [
1760,
-1420
],
"parameters": {},
"typeVersion": 3
},
{
"id": "e2271e54-84da-4dc3-a498-04339698ed96",
"name": "Leads List4",
"type": "n8n-nodes-base.googleSheets",
"position": [
2780,
-1280
],
"parameters": {},
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "e1b3f256-2190-4f09-9b7f-e2228bf99416",
"name": "If2",
"type": "n8n-nodes-base.if",
"position": [
2200,
-1420
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "1488b044-53e9-4c88-be2f-842cc55c287f",
"name": "Slice down to 10",
"type": "n8n-nodes-base.code",
"position": [
540,
-160
],
"parameters": {},
"typeVersion": 2
},
{
"id": "c284a388-e7de-4917-b7a4-c9a985c88aad",
"name": "Find real user data with Hunter",
"type": "n8n-nodes-base.hunter",
"position": [
960,
-160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0a2a2711-6ef8-4bc5-b4f8-82e45f1541d3",
"name": "Clean Hunter output",
"type": "n8n-nodes-base.code",
"position": [
1240,
-160
],
"parameters": {},
"typeVersion": 2
},
{
"id": "3454795b-8dc4-49bc-98eb-7f8758d136af",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2160,
-1580
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e601df20-b3e0-4840-9d1b-5c50bfc7a85f",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
3260,
-1580
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "139a3ef6-f1de-4b8e-a8b2-60feb86c3e66",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-460,
-1840
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "87a35967-b786-4602-a77b-8b65773ce2e9",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-440,
-1380
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a573def5-08b9-4bed-84f7-817dde2440ef",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-140,
-1380
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "bb884741-3145-478b-9a92-62436726d415",
"name": "Sticky Note18",
"type": "n8n-nodes-base.stickyNote",
"position": [
-140,
-1380
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "61e9daf7-c9b6-43c7-acec-d4f1ed09ed40",
"name": "Sticky Note49",
"type": "n8n-nodes-base.stickyNote",
"position": [
-460,
-1160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a295eea8-23d9-4657-960b-154022c8ef6a",
"name": "Telegram Trigger",
"type": "n8n-nodes-base.telegramTrigger",
"disabled": true,
"position": [
-120,
-900
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "573dc1e0-4988-492d-9920-57ad5fdf9374",
"name": "JSON cleaner code",
"type": "n8n-nodes-base.code",
"position": [
1020,
-1420
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ca6028d4-7e04-46b6-bf5c-edcd725eb1dd",
"name": "Chunk into separate items code",
"type": "n8n-nodes-base.code",
"position": [
1320,
-1420
],
"parameters": {},
"typeVersion": 2
},
{
"id": "7a737e19-141e-4dd8-ad6c-0af8f1ed32a1",
"name": "Keep only non-duplicates code",
"type": "n8n-nodes-base.code",
"position": [
1980,
-1420
],
"parameters": {},
"typeVersion": 2
},
{
"id": "8fee6e6b-042e-45c0-b0a8-99fdb0d36584",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-2060
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "370764d3-f2bb-41a5-bb69-40d9c73d520c",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
180,
-1680
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fe98f3d5-b61d-4c54-88fb-a6233ebec496",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
220,
-1280
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "84f352c1-24d1-40f7-bd9b-d2ecc39bc3dd",
"name": "Sticky Note19",
"type": "n8n-nodes-base.stickyNote",
"position": [
220,
-1280
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3b268910-13b9-49d4-a7fe-8dc04a1bafac",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
860,
-2240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "43e2c545-1f07-4325-a6b2-0960646ec1e6",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
880,
-1780
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6ddeee78-ca64-48b1-8d12-015b082c48bd",
"name": "Sticky Note50",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-1160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "57ffee2c-6d96-4542-b708-803d3f7b8118",
"name": "Sticky Note12",
"type": "n8n-nodes-base.stickyNote",
"position": [
1200,
-1680
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e9107452-0f23-4cae-8f9e-e340072badd7",
"name": "List existing domains code",
"type": "n8n-nodes-base.code",
"position": [
2020,
-1680
],
"parameters": {},
"typeVersion": 2
},
{
"id": "0263b9be-44b8-4964-a8c8-4dff72e9765d",
"name": "Read all from your Google Sheet \"Leads List\" sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1780,
-1700
],
"parameters": {},
"executeOnce": true,
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "d2b6ac2d-a976-4beb-97d1-55daebf8b675",
"name": "Sticky Note13",
"type": "n8n-nodes-base.stickyNote",
"position": [
1540,
-2120
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7f1b11ec-bf10-434b-9974-5860b5ea64db",
"name": "Sticky Note15",
"type": "n8n-nodes-base.stickyNote",
"position": [
1540,
-1680
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fec01b22-9177-42f2-a4c9-4af66b2e81f2",
"name": "Sticky Note51",
"type": "n8n-nodes-base.stickyNote",
"position": [
860,
-1040
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "85323e2e-f765-4bf7-a8df-f972611fd2e1",
"name": "Airtable",
"type": "n8n-nodes-base.airtable",
"disabled": true,
"position": [
1440,
-920
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "422b8116-b7a7-4a09-8098-3c44ac8720df",
"name": "Sticky Note52",
"type": "n8n-nodes-base.stickyNote",
"position": [
1680,
-1040
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3f188505-04b7-4bbe-a3e3-b5d854e00696",
"name": "Sticky Note14",
"type": "n8n-nodes-base.stickyNote",
"position": [
1980,
-1980
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "5ace399e-e6fb-4e4a-aaf1-a9adf5d0ccb7",
"name": "Sticky Note16",
"type": "n8n-nodes-base.stickyNote",
"position": [
1940,
-1460
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "890a4653-dd41-4d31-9643-72600bc50ab7",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2540,
-2400
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9b147919-edae-4f11-bc7d-cc7a6dd36ee7",
"name": "Sticky Note17",
"type": "n8n-nodes-base.stickyNote",
"position": [
2580,
-1860
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "feb6994c-0093-418a-b2ea-76c33166416c",
"name": "Sticky Note20",
"type": "n8n-nodes-base.stickyNote",
"position": [
2720,
-1360
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4e0cdd9d-7046-4294-9f54-16481c45093e",
"name": "Sticky Note53",
"type": "n8n-nodes-base.stickyNote",
"position": [
-740,
-1760
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e40f01b7-9f7b-4c3a-ad9a-3e911c0d049f",
"name": "Sticky Note54",
"type": "n8n-nodes-base.stickyNote",
"position": [
-740,
-660
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2dd66820-c986-4c28-84db-09604c4c3de5",
"name": "Sticky Note11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-580,
-620
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6548646b-6f93-47c4-ae20-1bba71d72eaa",
"name": "Sticky Note21",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
-240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "069aeba1-343d-4390-b802-5838c28dea96",
"name": "Sticky Note22",
"type": "n8n-nodes-base.stickyNote",
"position": [
-100,
-240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "55668fae-bf5a-4dc9-a39e-aefa3c2739a9",
"name": "Sticky Note23",
"type": "n8n-nodes-base.stickyNote",
"position": [
-100,
-240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "xxxxxxxxxxxx",
"name": "Read all \"new\" Leads",
"type": "n8n-nodes-base.googleSheets",
"position": [
220,
-160
],
"parameters": {},
"executeOnce": true,
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "xxxxxxfxxxx",
"name": "Sticky Note24",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-500
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8a21c2a8-b1e2-4229-97be-d502851139e4",
"name": "Sticky Note25",
"type": "n8n-nodes-base.stickyNote",
"position": [
440,
-540
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "8cf0af91-2916-4384-b26f-faec9ddf6f8a",
"name": "Sticky Note26",
"type": "n8n-nodes-base.stickyNote",
"position": [
740,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "bc81fe9b-5382-44a2-b071-7c9d97014423",
"name": "Sticky Note27",
"type": "n8n-nodes-base.stickyNote",
"position": [
760,
-200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2fe533c7-5cf7-4b43-a046-53706d2be500",
"name": "Sticky Note28",
"type": "n8n-nodes-base.stickyNote",
"position": [
1140,
-520
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "56729958-d9e7-48cd-89ef-eab0bb8abaf4",
"name": "Sticky Note29",
"type": "n8n-nodes-base.stickyNote",
"position": [
1440,
-560
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7fb6c4b4-01f4-46ab-8131-2f9b62d1af75",
"name": "Sticky Note55",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "bfbd6e5f-06ca-484f-8e44-e3d6813d2a90",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"disabled": true,
"position": [
40,
300
],
"parameters": {},
"typeVersion": 1.2
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "7756c002-3f1a-4fc0-9d10-6c16daf4cb57",
"connections": {
"If": {
"main": [
[
{
"node": "Company Finder",
"type": "main",
"index": 0
}
],
[
{
"node": "Leads List",
"type": "main",
"index": 0
}
]
]
},
"If1": {
"main": [
[
{
"node": "Leads List2",
"type": "main",
"index": 0
}
],
[
{
"node": "Leads List3",
"type": "main",
"index": 0
}
]
]
},
"If2": {
"main": [
[
{
"node": "Leads List4",
"type": "main",
"index": 0
}
]
]
},
"Code2": {
"main": [
[
{
"node": "If1",
"type": "main",
"index": 0
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Keep only non-duplicates code",
"type": "main",
"index": 0
}
]
]
},
"Company Finder": {
"main": [
[
{
"node": "Code2",
"type": "main",
"index": 0
}
]
]
},
"Company Finder1": {
"main": [
[
{
"node": "JSON cleaner code",
"type": "main",
"index": 0
}
]
]
},
"Slice down to 10": {
"main": [
[
{
"node": "Find real user data with Hunter",
"type": "main",
"index": 0
}
]
]
},
"JSON cleaner code": {
"main": [
[
{
"node": "Chunk into separate items code",
"type": "main",
"index": 0
}
]
]
},
"Clean Hunter output": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"OpenRouter Chat Model": {
"ai_languageModel": [
[
{
"node": "Company Finder",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Read all \"new\" Leads": {
"main": [
[
{
"node": "Slice down to 10",
"type": "main",
"index": 0
}
]
]
},
"OpenRouter Chat Model1": {
"ai_languageModel": [
[
{
"node": "Company Finder1",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"List existing domains code": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"When chat message received": {
"main": [
[
{
"node": "Company Finder1",
"type": "main",
"index": 0
}
]
]
},
"Keep only non-duplicates code": {
"main": [
[
{
"node": "If2",
"type": "main",
"index": 0
}
]
]
},
"Chunk into separate items code": {
"main": [
[
{
"node": "Read all from your Google Sheet \"Leads List\" sheet",
"type": "main",
"index": 0
},
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Find real user data with Hunter": {
"main": [
[
{
"node": "Clean Hunter output",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Read all \"new\" Leads",
"type": "main",
"index": 0
}
]
]
},
"Read all from your Google Sheet \"Leads List\" sheet": {
"main": [
[
{
"node": "List existing domains code",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This template is ideal for B2B founders, solopreneurs, growth marketers, SDRs, or anyone looking to scale their lead generation and enrichment with no-code tools to low-code tools.
Source: https://n8n.io/workflows/3616/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Lead Generating Web Scraper & CRM Automation. Uses httpRequest, airtable, googleSheets, gmail. Scheduled trigger; 38 nodes.
This workflow demonstrates a simple way to run evals on a set of test cases stored in a Google Sheet.
"This workflow builds an AI-powered resume screening system inside n8n. It begins with Gmail and Form triggers that capture incoming resumes, then uploads each file to Google Drive for storage. The re
This workflow demonstrates a simple way to run evals on a set of test cases stored in a Google Sheet.
This workflow automates the time-consuming process of B2B market research. It takes a list of company website URLs from a Google Sheet, uses BrowserAct to scrape their profiles and news sections, anal