{ "name": "Extract and qualify local business leads and draft cold emails with OpenAI, Apify and Hunter", "nodes": [ { "id": "594adee7-a24d-4b4e-9738-83b3e12c7fa6", "name": "Scrape Lead Website", "type": "n8n-nodes-base.html", "position": [ 2976, 1136 ] }, { "id": "3ce2d134-2d1f-42b6-ae9e-b3724e7bef2a", "name": "Filter Qualified Leads", "type": "n8n-nodes-base.filter", "position": [ 3600, 1136 ] }, { "id": "9c5d551e-e3b5-4deb-ab18-029c1a68638e", "name": "Write Qualified Leads to CRM", "type": "n8n-nodes-base.googleSheets", "position": [ 4352, 1008 ] }, { "id": "4fd08224-8981-44b4-93ae-0caf1b499c26", "name": "Write Cold Email to CRM", "type": "n8n-nodes-base.googleSheets", "position": [ 4352, 1248 ] }, { "id": "115f1d4e-75ac-4434-b1e7-680ef4f3ff90", "name": "Get dataset items", "type": "@apify/n8n-nodes-apify.apify", "position": [ 2112, 1136 ] }, { "id": "7dbe1d4a-65bc-4619-bb0c-7ac539da4aa6", "name": "When clicking ‘Execute workflow’", "type": "n8n-nodes-base.manualTrigger", "position": [ 1888, 1136 ] }, { "id": "cc00d4cf-472f-4771-b807-b1fca0a31837", "name": "Limit", "type": "n8n-nodes-base.limit", "position": [ 2336, 1136 ] }, { "id": "59838c68-cc52-42ee-970e-af9c78d25f22", "name": "Scrape Home", "type": "n8n-nodes-base.httpRequest", "position": [ 2752, 1152 ] }, { "id": "15ac4695-71b5-44e1-abc8-fb9e1ffc924a", "name": "Loop Over Items", "type": "n8n-nodes-base.splitInBatches", "position": [ 2560, 1136 ] }, { "id": "d7686d18-407f-4648-a708-98b719399bb1", "name": "Merge", "type": "n8n-nodes-base.merge", "position": [ 4624, 1232 ] }, { "id": "2b3342ff-ab73-4631-a5f2-c8a5ac470489", "name": "Lead Normalize Agent", "type": "@n8n/n8n-nodes-langchain.openAi", "position": [ 3984, 1008 ] }, { "id": "f9290323-6427-4c4d-9069-ac06471f3464", "name": "Cold Email Writer AI Agent1", "type": "@n8n/n8n-nodes-langchain.openAi", "position": [ 3984, 1248 ] }, { "id": "87bb37dd-2317-4633-b9fd-0ea79ee5fccd", "name": "Hunter", "type": "n8n-nodes-base.hunter", "position": [ 3440, 1136 ] }, { "id": "a1103cc3-2888-45fb-9763-c4845ad7b60b", "name": "Search", "type": "@tavily/n8n-nodes-tavily.tavily", "position": [ 3776, 1136 ] }, { "id": "dce23c6e-dac0-4ea4-82fc-ef880a63454c", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [ 1312, 864 ], "parameters": { "width": 464, "height": 864, "content": "# AI-Powered Local Business Lead Scraping, Qualification & Outreach System\n\nWhat this workflow does (end-to-end)\nThis workflow automatically:\n\t1.\tPulls local business leads from Apify (Google Search /" } }, { "id": "e66fea58-f9b1-4c4e-b14f-3669c4dde0b0", "name": "Sticky Note1", "type": "n8n-nodes-base.stickyNote", "position": [ 2000, 864 ], "parameters": { "width": 336, "height": 368, "content": "## Lead Source (Apify)\n\nThis section pulls raw local business results from Apify.\nEverything downstream assumes each item has a website URL.\n\nIf you want different industries or cities, change it in A" } }, { "id": "cd890b32-c201-4142-b816-f4d4a0ce06b8", "name": "Sticky Note2", "type": "n8n-nodes-base.stickyNote", "position": [ 2736, 880 ], "parameters": { "width": 384, "height": 416, "content": "## Website Scraping\n\nThis section fetches the business homepage and raw site content.\n\nSome sites will fail or block scraping. That’s expected.\nFailures won’t stop the workflow, they just won’t qualif" } }, { "id": "c662617d-22c5-4742-a696-fb5e82e6f385", "name": "Lead Qualification Agent", "type": "@n8n/n8n-nodes-langchain.openAi", "position": [ 3136, 1136 ] }, { "id": "df3c4163-67a4-4bbd-b2a2-a1799a22ac77", "name": "Sticky Note3", "type": "n8n-nodes-base.stickyNote", "position": [ 3264, 880 ], "parameters": { "width": 528, "height": 416, "content": "## Qualification & Validation\n\nThis section decides whether a lead is worth keeping.\n\nIt checks:\n\t•\tReachability (email + site)\n\t•\tBasic ops signals\n\t•\tSocial presence (if any)\n\nLow-quality leads are " } }, { "id": "74f92ec9-fa01-46d5-83b7-bfd160991c13", "name": "Sticky Note4", "type": "n8n-nodes-base.stickyNote", "position": [ 4048, 736 ], "parameters": { "width": 352, "height": 368, "content": "## CRM Write\n\nThis is the system of record.\n\nQualified leads are written to Google Sheets using append-or-update logic.\nRe-running the workflow won’t duplicate rows if the email already exists.\n\nIf yo" } }, { "id": "43a21083-78d0-4766-949c-dfc6b45774c0", "name": "Sticky Note5", "type": "n8n-nodes-base.stickyNote", "position": [ 4048, 1232 ], "parameters": { "width": 352, "height": 336, "content": "\n\n\n\n\n\n\n\n\n\n## Cold Email Drafting\n\nThis agent writes human-sounding cold email drafts using the extracted context.\n\nThese are drafts only.\nThey are stored in the CRM for review, sequencing, or export.\n" } } ], "connections": { "Limit": { "main": [ [ { "node": "Loop Over Items", "type": "main", "index": 0 } ] ] }, "Merge": { "main": [ [ { "node": "Loop Over Items", "type": "main", "index": 0 } ] ] }, "Hunter": { "main": [ [ { "node": "Filter Qualified Leads", "type": "main", "index": 0 } ] ] }, "Search": { "main": [ [ { "node": "Lead Normalize Agent", "type": "main", "index": 0 }, { "node": "Cold Email Writer AI Agent1", "type": "main", "index": 0 } ] ] }, "Scrape Home": { "main": [ [ { "node": "Scrape Lead Website", "type": "main", "index": 0 } ] ] }, "Loop Over Items": { "main": [ [], [ { "node": "Scrape Home", "type": "main", "index": 0 } ] ] }, "Get dataset items": { "main": [ [ { "node": "Limit", "type": "main", "index": 0 } ] ] }, "Scrape Lead Website": { "main": [ [ { "node": "Lead Qualification Agent", "type": "main", "index": 0 } ] ] }, "Lead Normalize Agent": { "main": [ [ { "node": "Write Qualified Leads to CRM", "type": "main", "index": 0 } ] ] }, "Filter Qualified Leads": { "main": [ [ { "node": "Search", "type": "main", "index": 0 } ] ] }, "Write Cold Email to CRM": { "main": [ [ { "node": "Merge", "type": "main", "index": 1 } ] ] }, "Lead Qualification Agent": { "main": [ [ { "node": "Hunter", "type": "main", "index": 0 } ] ] }, "Cold Email Writer AI Agent1": { "main": [ [ { "node": "Write Cold Email to CRM", "type": "main", "index": 0 } ] ] }, "Write Qualified Leads to CRM": { "main": [ [ { "node": "Merge", "type": "main", "index": 0 } ] ] }, "When clicking ‘Execute workflow’": { "main": [ [ { "node": "Get dataset items", "type": "main", "index": 0 } ] ] } } }