Overpass 潜在客户生成系统
高级
这是一个Sales, Marketing领域的自动化工作流，包含 27 个节点。主要使用 If, Set, Code, Wait, Merge 等节点。 使用 OpenStreetMap 数据生成商业线索并保存到 Google Sheets
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
使用的节点 (27)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"name": "Overpass 潜在客户生成系统",
"tags": [],
"nodes": [
{
"id": "b5dd8c2a-5b6a-4a20-b8a5-cb0d1898303d",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
3960,
940
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "1e325bd0-e026-4992-9038-a6746e6c51bd",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
700,
440
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "03dfb6c7-c649-4b32-9048-7f16a991a0ae",
"name": "无操作，不执行任何动作",
"type": "n8n-nodes-base.noOp",
"position": [
1360,
720
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a102f606-baa8-4908-8d61-6fd5d4c5d692",
"name": "当被另一个工作流执行时",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
1140,
460
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "ba30c077-0825-4be6-ad89-e58ef42da27a",
"name": "遍历项目1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
280,
200
],
"parameters": {},
"typeVersion": 3
},
{
"id": "3d4f898e-1b8b-4941-82f9-48aa17ea7dce",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "959b5298-e132-40ed-bc5f-01b578a42475",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"disabled": true,
"position": [
680,
260
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "eae223c6-6f34-4725-955e-29a26f15da60",
"name": "执行工作流",
"type": "n8n-nodes-base.executeWorkflow",
"onError": "continueRegularOutput",
"position": [
480,
440
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 1.2,
"waitBetweenTries": 3000
},
{
"id": "9544d301-f368-4e76-9ea4-dbfa75feea5f",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2120,
1160
],
"parameters": {},
"typeVersion": 3
},
{
"id": "5e954b1c-cc3c-407a-9a9e-abadec52607c",
"name": "过滤掉无联系信息的项目",
"type": "n8n-nodes-base.filter",
"position": [
3700,
740
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "451f0cf9-d782-45c4-a7b0-c3f3ef3e5069",
"name": "追加项目（无网站和/或邮箱）",
"type": "n8n-nodes-base.merge",
"position": [
2560,
720
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "64b2b09b-56b5-4159-aece-49c4e46ff6a9",
"name": "合并项目（含 HTML）",
"type": "n8n-nodes-base.merge",
"position": [
2800,
1000
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "6b1f46f6-8a0b-4cb8-a46c-fcc246d676f6",
"name": "获取网站HTML",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
2300,
1240
],
"parameters": {},
"typeVersion": 4.2,
"alwaysOutputData": false
},
{
"id": "24e2a603-d0ec-45fd-ac18-98c9608b6373",
"name": "追加项目",
"type": "n8n-nodes-base.merge",
"position": [
3420,
740
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "31ce2bbb-ded7-4fff-b4ab-b0f83286552e",
"name": "清理邮箱",
"type": "n8n-nodes-base.code",
"position": [
3200,
1000
],
"parameters": {},
"typeVersion": 2
},
{
"id": "691468a9-fe82-44e6-8635-209065639e4c",
"name": "抓取首页",
"type": "n8n-nodes-base.code",
"onError": "continueRegularOutput",
"position": [
3020,
1000
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4eca9096-fdfe-4291-ac60-a866882ebe8c",
"name": "有电子邮件吗？",
"type": "n8n-nodes-base.if",
"position": [
2080,
800
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "89ad6c56-e65d-4b55-8f2e-8cfb579bfde3",
"name": "无网站？",
"type": "n8n-nodes-base.if",
"position": [
1880,
720
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "e1864929-f1ba-4edf-a345-a6515063c943",
"name": "整理数据",
"type": "n8n-nodes-base.code",
"position": [
1660,
720
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a328313b-df35-493f-bda2-b53f3a2a4e1b",
"name": "设置输出字段",
"type": "n8n-nodes-base.set",
"position": [
2180,
440
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "31b445f6-eabf-4d7d-b1da-0659eef50c81",
"name": "提取列表",
"type": "n8n-nodes-base.set",
"position": [
1600,
440
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "6c84c83d-d9dd-4f53-af63-ea577bcc9915",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
3960,
740
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "2f2b7822-a17f-4935-ab09-9c5575876f3a",
"name": "分离",
"type": "n8n-nodes-base.splitOut",
"position": [
1880,
440
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c94f73a0-a049-4482-a072-7d1abc5d7579",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
1360,
460
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "946c8416-15b4-4cd3-a763-566db23ef71d",
"name": "当点击\"测试工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
20,
200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "08a1d715-cf68-417d-9245-db4cda09e5be",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
320,
0
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "fac295bd-c9c2-4c77-a495-893854cfe4b2",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"disabled": true,
"position": [
1220,
140
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {
"When clicking ‘Test workflow’": [
{
"json": {
"inarea": "Los Angeles",
"keyword": "Restaurant",
"outarea": "California"
}
},
{
"json": {
"inarea": "San Francisco",
"keyword": "Restaurant",
"outarea": "California"
}
},
{
"json": {
"inarea": "San Diego",
"keyword": "Restaurant",
"outarea": "California"
}
},
{
"json": {
"inarea": "San Jose",
"keyword": "Restaurant",
"outarea": "California"
}
},
{
"json": {
"inarea": "Sacramento",
"keyword": "Restaurant",
"outarea": "California"
}
},
{
"json": {
"inarea": "Fresno",
"keyword": "Restaurant",
"outarea": "California"
}
},
{
"json": {
"inarea": "Long Beach",
"keyword": "Restaurant",
"outarea": "California"
}
},
{
"json": {
"inarea": "Oakland",
"keyword": "Restaurant",
"outarea": "California"
}
},
{
"json": {
"inarea": "Bakersfield",
"keyword": "Restaurant",
"outarea": "California"
}
},
{
"json": {
"inarea": "Anaheim",
"keyword": "Restaurant",
"outarea": "California"
}
},
{
"json": {
"inarea": "Santa Ana",
"keyword": "Restaurant",
"outarea": "California"
}
},
{
"json": {
"inarea": "New York",
"keyword": "Restaurant",
"outarea": "New York"
}
},
{
"json": {
"inarea": "Buffalo",
"keyword": "Restaurant",
"outarea": "New York"
}
},
{
"json": {
"inarea": "Rochester",
"keyword": "Restaurant",
"outarea": "New York"
}
},
{
"json": {
"inarea": "Syracuse",
"keyword": "Restaurant",
"outarea": "New York"
}
},
{
"json": {
"inarea": "Albany",
"keyword": "Restaurant",
"outarea": "New York"
}
},
{
"json": {
"inarea": "Yonkers",
"keyword": "Restaurant",
"outarea": "New York"
}
},
{
"json": {
"inarea": "Chicago",
"keyword": "Restaurant",
"outarea": "Illinois"
}
},
{
"json": {
"inarea": "Aurora",
"keyword": "Restaurant",
"outarea": "Illinois"
}
},
{
"json": {
"inarea": "Rockford",
"keyword": "Restaurant",
"outarea": "Illinois"
}
},
{
"json": {
"inarea": "Joliet",
"keyword": "Restaurant",
"outarea": "Illinois"
}
},
{
"json": {
"inarea": "Naperville",
"keyword": "Restaurant",
"outarea": "Illinois"
}
},
{
"json": {
"inarea": "Peoria",
"keyword": "Restaurant",
"outarea": "Illinois"
}
},
{
"json": {
"inarea": "Houston",
"keyword": "Restaurant",
"outarea": "Texas"
}
},
{
"json": {
"inarea": "San Antonio",
"keyword": "Restaurant",
"outarea": "Texas"
}
},
{
"json": {
"inarea": "Dallas",
"keyword": "Restaurant",
"outarea": "Texas"
}
},
{
"json": {
"inarea": "Austin",
"keyword": "Restaurant",
"outarea": "Texas"
}
},
{
"json": {
"inarea": "Fort Worth",
"keyword": "Restaurant",
"outarea": "Texas"
}
},
{
"json": {
"inarea": "El Paso",
"keyword": "Restaurant",
"outarea": "Texas"
}
},
{
"json": {
"inarea": "Arlington",
"keyword": "Restaurant",
"outarea": "Texas"
}
},
{
"json": {
"inarea": "Corpus Christi",
"keyword": "Restaurant",
"outarea": "Texas"
}
},
{
"json": {
"inarea": "Plano",
"keyword": "Restaurant",
"outarea": "Texas"
}
},
{
"json": {
"inarea": "Laredo",
"keyword": "Restaurant",
"outarea": "Texas"
}
},
{
"json": {
"inarea": "Lubbock",
"keyword": "Restaurant",
"outarea": "Texas"
}
},
{
"json": {
"inarea": "Garland",
"keyword": "Restaurant",
"outarea": "Texas"
}
},
{
"json": {
"inarea": "Irving",
"keyword": "Restaurant",
"outarea": "Texas"
}
},
{
"json": {
"inarea": "Mckinney",
"keyword": "Restaurant",
"outarea": "Texas"
}
},
{
"json": {
"inarea": "Amarillo",
"keyword": "Restaurant",
"outarea": "Texas"
}
},
{
"json": {
"inarea": "Grand Prairie",
"keyword": "Restaurant",
"outarea": "Texas"
}
},
{
"json": {
"inarea": "Phoenix",
"keyword": "Restaurant",
"outarea": "Arizona"
}
},
{
"json": {
"inarea": "Tucson",
"keyword": "Restaurant",
"outarea": "Arizona"
}
},
{
"json": {
"inarea": "Mesa",
"keyword": "Restaurant",
"outarea": "Arizona"
}
},
{
"json": {
"inarea": "Chandler",
"keyword": "Restaurant",
"outarea": "Arizona"
}
},
{
"json": {
"inarea": "Philadelphia",
"keyword": "Restaurant",
"outarea": "Pennsylvania"
}
},
{
"json": {
"inarea": "Pittsburgh",
"keyword": "Restaurant",
"outarea": "Pennsylvania"
}
},
{
"json": {
"inarea": "Allentown",
"keyword": "Restaurant",
"outarea": "Pennsylvania"
}
},
{
"json": {
"inarea": "Erie",
"keyword": "Restaurant",
"outarea": "Pennsylvania"
}
},
{
"json": {
"inarea": "Reading",
"keyword": "Restaurant",
"outarea": "Pennsylvania"
}
},
{
"json": {
"inarea": "Scranton",
"keyword": "Restaurant",
"outarea": "Pennsylvania"
}
},
{
"json": {
"inarea": "Miami",
"keyword": "Restaurant",
"outarea": "Florida"
}
},
{
"json": {
"inarea": "Orlando",
"keyword": "Restaurant",
"outarea": "Florida"
}
},
{
"json": {
"inarea": "Tampa",
"keyword": "Restaurant",
"outarea": "Florida"
}
},
{
"json": {
"inarea": "Jacksonville",
"keyword": "Restaurant",
"outarea": "Florida"
}
},
{
"json": {
"inarea": "St. Petersburg",
"keyword": "Restaurant",
"outarea": "Florida"
}
},
{
"json": {
"inarea": "Hialeah",
"keyword": "Restaurant",
"outarea": "Florida"
}
},
{
"json": {
"inarea": "Fort Lauderdale",
"keyword": "Restaurant",
"outarea": "Florida"
}
},
{
"json": {
"inarea": "Tallahassee",
"keyword": "Restaurant",
"outarea": "Florida"
}
},
{
"json": {
"inarea": "Cape Coral",
"keyword": "Restaurant",
"outarea": "Florida"
}
},
{
"json": {
"inarea": "Fort Myers",
"keyword": "Restaurant",
"outarea": "Florida"
}
},
{
"json": {
"inarea": "Port St. Lucie",
"keyword": "Restaurant",
"outarea": "Florida"
}
},
{
"json": {
"inarea": "Atlanta",
"keyword": "Restaurant",
"outarea": "Georgia"
}
},
{
"json": {
"inarea": "Augusta",
"keyword": "Restaurant",
"outarea": "Georgia"
}
},
{
"json": {
"inarea": "Columbus",
"keyword": "Restaurant",
"outarea": "Georgia"
}
},
{
"json": {
"inarea": "Savannah",
"keyword": "Restaurant",
"outarea": "Georgia"
}
},
{
"json": {
"inarea": "Macon",
"keyword": "Restaurant",
"outarea": "Georgia"
}
},
{
"json": {
"inarea": "Seattle",
"keyword": "Restaurant",
"outarea": "Washington"
}
},
{
"json": {
"inarea": "Spokane",
"keyword": "Restaurant",
"outarea": "Washington"
}
},
{
"json": {
"inarea": "Tacoma",
"keyword": "Restaurant",
"outarea": "Washington"
}
},
{
"json": {
"inarea": "Vancouver",
"keyword": "Restaurant",
"outarea": "Washington"
}
},
{
"json": {
"inarea": "Bellevue",
"keyword": "Restaurant",
"outarea": "Washington"
}
},
{
"json": {
"inarea": "Boston",
"keyword": "Restaurant",
"outarea": "Massachusetts"
}
},
{
"json": {
"inarea": "Worcester",
"keyword": "Restaurant",
"outarea": "Massachusetts"
}
},
{
"json": {
"inarea": "Springfield",
"keyword": "Restaurant",
"outarea": "Massachusetts"
}
},
{
"json": {
"inarea": "Lowell",
"keyword": "Restaurant",
"outarea": "Massachusetts"
}
},
{
"json": {
"inarea": "Detroit",
"keyword": "Restaurant",
"outarea": "Michigan"
}
},
{
"json": {
"inarea": "Grand Rapids",
"keyword": "Restaurant",
"outarea": "Michigan"
}
},
{
"json": {
"inarea": "Warren",
"keyword": "Restaurant",
"outarea": "Michigan"
}
},
{
"json": {
"inarea": "Lansing",
"keyword": "Restaurant",
"outarea": "Michigan"
}
},
{
"json": {
"inarea": "Sterling Heights",
"keyword": "Restaurant",
"outarea": "Michigan"
}
},
{
"json": {
"inarea": "Denver",
"keyword": "Restaurant",
"outarea": "Colorado"
}
},
{
"json": {
"inarea": "Colorado Springs",
"keyword": "Restaurant",
"outarea": "Colorado"
}
},
{
"json": {
"inarea": "Aurora",
"keyword": "Restaurant",
"outarea": "Colorado"
}
},
{
"json": {
"inarea": "Fort Collins",
"keyword": "Restaurant",
"outarea": "Colorado"
}
},
{
"json": {
"inarea": "Lakewood",
"keyword": "Restaurant",
"outarea": "Colorado"
}
},
{
"json": {
"inarea": "Baltimore",
"keyword": "Restaurant",
"outarea": "Maryland"
}
},
{
"json": {
"inarea": "Frederick",
"keyword": "Restaurant",
"outarea": "Maryland"
}
},
{
"json": {
"inarea": "Rockville",
"keyword": "Restaurant",
"outarea": "Maryland"
}
},
{
"json": {
"inarea": "Las Vegas",
"keyword": "Restaurant",
"outarea": "Nevada"
}
},
{
"json": {
"inarea": "Henderson",
"keyword": "Restaurant",
"outarea": "Nevada"
}
},
{
"json": {
"inarea": "Reno",
"keyword": "Restaurant",
"outarea": "Nevada"
}
},
{
"json": {
"inarea": "North Las Vegas",
"keyword": "Restaurant",
"outarea": "Nevada"
}
},
{
"json": {
"inarea": "Portland",
"keyword": "Restaurant",
"outarea": "Oregon"
}
},
{
"json": {
"inarea": "Salem",
"keyword": "Restaurant",
"outarea": "Oregon"
}
},
{
"json": {
"inarea": "Eugene",
"keyword": "Restaurant",
"outarea": "Oregon"
}
},
{
"json": {
"inarea": "Gresham",
"keyword": "Restaurant",
"outarea": "Oregon"
}
},
{
"json": {
"inarea": "Cleveland",
"keyword": "Restaurant",
"outarea": "Ohio"
}
},
{
"json": {
"inarea": "Cincinnati",
"keyword": "Restaurant",
"outarea": "Ohio"
}
},
{
"json": {
"inarea": "Columbus",
"keyword": "Restaurant",
"outarea": "Ohio"
}
},
{
"json": {
"inarea": "Toledo",
"keyword": "Restaurant",
"outarea": "Ohio"
}
},
{
"json": {
"inarea": "Akron",
"keyword": "Restaurant",
"outarea": "Ohio"
}
},
{
"json": {
"inarea": "Dayton",
"keyword": "Restaurant",
"outarea": "Ohio"
}
},
{
"json": {
"inarea": "Charlotte",
"keyword": "Restaurant",
"outarea": "North Carolina"
}
},
{
"json": {
"inarea": "Raleigh",
"keyword": "Restaurant",
"outarea": "North Carolina"
}
},
{
"json": {
"inarea": "Greensboro",
"keyword": "Restaurant",
"outarea": "North Carolina"
}
},
{
"json": {
"inarea": "Durham",
"keyword": "Restaurant",
"outarea": "North Carolina"
}
},
{
"json": {
"inarea": "Winston-Salem",
"keyword": "Restaurant",
"outarea": "North Carolina"
}
},
{
"json": {
"inarea": "Fayetteville",
"keyword": "Restaurant",
"outarea": "North Carolina"
}
},
{
"json": {
"inarea": "Nashville",
"keyword": "Restaurant",
"outarea": "Tennessee"
}
},
{
"json": {
"inarea": "Memphis",
"keyword": "Restaurant",
"outarea": "Tennessee"
}
},
{
"json": {
"inarea": "Knoxville",
"keyword": "Restaurant",
"outarea": "Tennessee"
}
},
{
"json": {
"inarea": "Chattanooga",
"keyword": "Restaurant",
"outarea": "Tennessee"
}
},
{
"json": {
"inarea": "Clarksville",
"keyword": "Restaurant",
"outarea": "Tennessee"
}
},
{
"json": {
"inarea": "Kansas City",
"keyword": "Restaurant",
"outarea": "Missouri"
}
},
{
"json": {
"inarea": "St. Louis",
"keyword": "Restaurant",
"outarea": "Missouri"
}
},
{
"json": {
"inarea": "Springfield",
"keyword": "Restaurant",
"outarea": "Missouri"
}
},
{
"json": {
"inarea": "Independence",
"keyword": "Restaurant",
"outarea": "Missouri"
}
},
{
"json": {
"inarea": "Columbia",
"keyword": "Restaurant",
"outarea": "Missouri"
}
},
{
"json": {
"inarea": "Indianapolis",
"keyword": "Restaurant",
"outarea": "Indiana"
}
},
{
"json": {
"inarea": "Fort Wayne",
"keyword": "Restaurant",
"outarea": "Indiana"
}
},
{
"json": {
"inarea": "Evansville",
"keyword": "Restaurant",
"outarea": "Indiana"
}
},
{
"json": {
"inarea": "South Bend",
"keyword": "Restaurant",
"outarea": "Indiana"
}
},
{
"json": {
"inarea": "Milwaukee",
"keyword": "Restaurant",
"outarea": "Wisconsin"
}
},
{
"json": {
"inarea": "Madison",
"keyword": "Restaurant",
"outarea": "Wisconsin"
}
},
{
"json": {
"inarea": "Green Bay",
"keyword": "Restaurant",
"outarea": "Wisconsin"
}
},
{
"json": {
"inarea": "Kenosha",
"keyword": "Restaurant",
"outarea": "Wisconsin"
}
},
{
"json": {
"inarea": "Racine",
"keyword": "Restaurant",
"outarea": "Wisconsin"
}
},
{
"json": {
"inarea": "New Orleans",
"keyword": "Restaurant",
"outarea": "Louisiana"
}
},
{
"json": {
"inarea": "Baton Rouge",
"keyword": "Restaurant",
"outarea": "Louisiana"
}
},
{
"json": {
"inarea": "Shreveport",
"keyword": "Restaurant",
"outarea": "Louisiana"
}
},
{
"json": {
"inarea": "Lafayette",
"keyword": "Restaurant",
"outarea": "Louisiana"
}
},
{
"json": {
"inarea": "Lake Charles",
"keyword": "Restaurant",
"outarea": "Louisiana"
}
},
{
"json": {
"inarea": "Louisville",
"keyword": "Restaurant",
"outarea": "Kentucky"
}
},
{
"json": {
"inarea": "Lexington",
"keyword": "Restaurant",
"outarea": "Kentucky"
}
},
{
"json": {
"inarea": "Bowling Green",
"keyword": "Restaurant",
"outarea": "Kentucky"
}
},
{
"json": {
"inarea": "Covington",
"keyword": "Restaurant",
"outarea": "Kentucky"
}
},
{
"json": {
"inarea": "Hartford",
"keyword": "Restaurant",
"outarea": "Connecticut"
}
},
{
"json": {
"inarea": "Bridgeport",
"keyword": "Restaurant",
"outarea": "Connecticut"
}
},
{
"json": {
"inarea": "New Haven",
"keyword": "Restaurant",
"outarea": "Connecticut"
}
},
{
"json": {
"inarea": "Stamford",
"keyword": "Restaurant",
"outarea": "Connecticut"
}
},
{
"json": {
"inarea": "Waterbury",
"keyword": "Restaurant",
"outarea": "Connecticut"
}
},
{
"json": {
"inarea": "Salt Lake City",
"keyword": "Restaurant",
"outarea": "Utah"
}
},
{
"json": {
"inarea": "Provo",
"keyword": "Restaurant",
"outarea": "Utah"
}
},
{
"json": {
"inarea": "West Valley City",
"keyword": "Restaurant",
"outarea": "Utah"
}
},
{
"json": {
"inarea": "Ogden",
"keyword": "Restaurant",
"outarea": "Utah"
}
},
{
"json": {
"inarea": "Orem",
"keyword": "Restaurant",
"outarea": "Utah"
}
},
{
"json": {
"inarea": "Birmingham",
"keyword": "Restaurant",
"outarea": "Alabama"
}
},
{
"json": {
"inarea": "Montgomery",
"keyword": "Restaurant",
"outarea": "Alabama"
}
},
{
"json": {
"inarea": "Mobile",
"keyword": "Restaurant",
"outarea": "Alabama"
}
},
{
"json": {
"inarea": "Huntsville",
"keyword": "Restaurant",
"outarea": "Alabama"
}
},
{
"json": {
"inarea": "Charleston",
"keyword": "Restaurant",
"outarea": "South Carolina"
}
},
{
"json": {
"inarea": "Columbia",
"keyword": "Restaurant",
"outarea": "South Carolina"
}
},
{
"json": {
"inarea": "Greenville",
"keyword": "Restaurant",
"outarea": "South Carolina"
}
},
{
"json": {
"inarea": "North Charleston",
"keyword": "Restaurant",
"outarea": "South Carolina"
}
},
{
"json": {
"inarea": "Myrtle Beach",
"keyword": "Restaurant",
"outarea": "South Carolina"
}
},
{
"json": {
"inarea": "Richmond",
"keyword": "Restaurant",
"outarea": "Virginia"
}
},
{
"json": {
"inarea": "Virginia Beach",
"keyword": "Restaurant",
"outarea": "Virginia"
}
},
{
"json": {
"inarea": "Norfolk",
"keyword": "Restaurant",
"outarea": "Virginia"
}
},
{
"json": {
"inarea": "Chesapeake",
"keyword": "Restaurant",
"outarea": "Virginia"
}
},
{
"json": {
"inarea": "Arlington",
"keyword": "Restaurant",
"outarea": "Virginia"
}
},
{
"json": {
"inarea": "Newport News",
"keyword": "Restaurant",
"outarea": "Virginia"
}
},
{
"json": {
"inarea": "Alexandria",
"keyword": "Restaurant",
"outarea": "Virginia"
}
},
{
"json": {
"inarea": "Roanoke",
"keyword": "Restaurant",
"outarea": "Virginia"
}
},
{
"json": {
"inarea": "Minneapolis",
"keyword": "Restaurant",
"outarea": "Minnesota"
}
},
{
"json": {
"inarea": "Saint Paul",
"keyword": "Restaurant",
"outarea": "Minnesota"
}
},
{
"json": {
"inarea": "Rochester",
"keyword": "Restaurant",
"outarea": "Minnesota"
}
},
{
"json": {
"inarea": "Duluth",
"keyword": "Restaurant",
"outarea": "Minnesota"
}
},
{
"json": {
"inarea": "Oklahoma City",
"keyword": "Restaurant",
"outarea": "Oklahoma"
}
},
{
"json": {
"inarea": "Tulsa",
"keyword": "Restaurant",
"outarea": "Oklahoma"
}
},
{
"json": {
"inarea": "Norman",
"keyword": "Restaurant",
"outarea": "Oklahoma"
}
},
{
"json": {
"inarea": "Broken Arrow",
"keyword": "Restaurant",
"outarea": "Oklahoma"
}
},
{
"json": {
"inarea": "Des Moines",
"keyword": "Restaurant",
"outarea": "Iowa"
}
},
{
"json": {
"inarea": "Cedar Rapids",
"keyword": "Restaurant",
"outarea": "Iowa"
}
},
{
"json": {
"inarea": "Davenport",
"keyword": "Restaurant",
"outarea": "Iowa"
}
},
{
"json": {
"inarea": "Little Rock",
"keyword": "Restaurant",
"outarea": "Arkansas"
}
},
{
"json": {
"inarea": "Fort Smith",
"keyword": "Restaurant",
"outarea": "Arkansas"
}
},
{
"json": {
"inarea": "Jackson",
"keyword": "Restaurant",
"outarea": "Mississippi"
}
},
{
"json": {
"inarea": "Gulfport",
"keyword": "Restaurant",
"outarea": "Mississippi"
}
},
{
"json": {
"inarea": "Hattiesburg",
"keyword": "Restaurant",
"outarea": "Mississippi"
}
},
{
"json": {
"inarea": "Southaven",
"keyword": "Restaurant",
"outarea": "Mississippi"
}
},
{
"json": {
"inarea": "Wichita",
"keyword": "Restaurant",
"outarea": "Kansas"
}
},
{
"json": {
"inarea": "Overland Park",
"keyword": "Restaurant",
"outarea": "Kansas"
}
},
{
"json": {
"inarea": "Kansas City",
"keyword": "Restaurant",
"outarea": "Kansas"
}
},
{
"json": {
"inarea": "Topeka",
"keyword": "Restaurant",
"outarea": "Kansas"
}
},
{
"json": {
"inarea": "Omaha",
"keyword": "Restaurant",
"outarea": "Nebraska"
}
},
{
"json": {
"inarea": "Lincoln",
"keyword": "Restaurant",
"outarea": "Nebraska"
}
},
{
"json": {
"inarea": "Bellevue",
"keyword": "Restaurant",
"outarea": "Nebraska"
}
},
{
"json": {
"inarea": "Grand Island",
"keyword": "Restaurant",
"outarea": "Nebraska"
}
},
{
"json": {
"inarea": "Albuquerque",
"keyword": "Restaurant",
"outarea": "New Mexico"
}
},
{
"json": {
"inarea": "Las Cruces",
"keyword": "Restaurant",
"outarea": "New Mexico"
}
},
{
"json": {
"inarea": "Santa Fe",
"keyword": "Restaurant",
"outarea": "New Mexico"
}
},
{
"json": {
"inarea": "Charleston",
"keyword": "Restaurant",
"outarea": "West Virginia"
}
},
{
"json": {
"inarea": "Huntington",
"keyword": "Restaurant",
"outarea": "West Virginia"
}
},
{
"json": {
"inarea": "Morgantown",
"keyword": "Restaurant",
"outarea": "West Virginia"
}
},
{
"json": {
"inarea": "Parkersburg",
"keyword": "Restaurant",
"outarea": "West Virginia"
}
},
{
"json": {
"inarea": "Wilmington",
"keyword": "Restaurant",
"outarea": "Delaware"
}
},
{
"json": {
"inarea": "Dover",
"keyword": "Restaurant",
"outarea": "Delaware"
}
},
{
"json": {
"inarea": "Providence",
"keyword": "Restaurant",
"outarea": "Rhode Island"
}
},
{
"json": {
"inarea": "Warwick",
"keyword": "Restaurant",
"outarea": "Rhode Island"
}
},
{
"json": {
"inarea": "Cranston",
"keyword": "Restaurant",
"outarea": "Rhode Island"
}
},
{
"json": {
"inarea": "Portland",
"keyword": "Restaurant",
"outarea": "Maine"
}
},
{
"json": {
"inarea": "Manchester",
"keyword": "Restaurant",
"outarea": "New Hampshire"
}
},
{
"json": {
"inarea": "Nashua",
"keyword": "Restaurant",
"outarea": "New Hampshire"
}
},
{
"json": {
"inarea": "Concord",
"keyword": "Restaurant",
"outarea": "New Hampshire"
}
},
{
"json": {
"inarea": "Burlington",
"keyword": "Restaurant",
"outarea": "Vermont"
}
},
{
"json": {
"inarea": "South Burlington",
"keyword": "Restaurant",
"outarea": "Vermont"
}
},
{
"json": {
"inarea": "Rutland",
"keyword": "Restaurant",
"outarea": "Vermont"
}
},
{
"json": {
"inarea": "Colchester",
"keyword": "Restaurant",
"outarea": "Vermont"
}
},
{
"json": {
"inarea": "Boise",
"keyword": "Restaurant",
"outarea": "Idaho"
}
},
{
"json": {
"inarea": "Nampa",
"keyword": "Restaurant",
"outarea": "Idaho"
}
},
{
"json": {
"inarea": "Meridian",
"keyword": "Restaurant",
"outarea": "Idaho"
}
},
{
"json": {
"inarea": "Billings",
"keyword": "Restaurant",
"outarea": "Montana"
}
},
{
"json": {
"inarea": "Missoula",
"keyword": "Restaurant",
"outarea": "Montana"
}
},
{
"json": {
"inarea": "Great Falls",
"keyword": "Restaurant",
"outarea": "Montana"
}
},
{
"json": {
"inarea": "Bozeman",
"keyword": "Restaurant",
"outarea": "Montana"
}
},
{
"json": {
"inarea": "Fargo",
"keyword": "Restaurant",
"outarea": "North Dakota"
}
},
{
"json": {
"inarea": "Bismarck",
"keyword": "Restaurant",
"outarea": "North Dakota"
}
},
{
"json": {
"inarea": "Grand Forks",
"keyword": "Restaurant",
"outarea": "North Dakota"
}
},
{
"json": {
"inarea": "Minot",
"keyword": "Restaurant",
"outarea": "North Dakota"
}
},
{
"json": {
"inarea": "Sioux Falls",
"keyword": "Restaurant",
"outarea": "South Dakota"
}
},
{
"json": {
"inarea": "Rapid City",
"keyword": "Restaurant",
"outarea": "South Dakota"
}
},
{
"json": {
"inarea": "Aberdeen",
"keyword": "Restaurant",
"outarea": "South Dakota"
}
},
{
"json": {
"inarea": "Brookings",
"keyword": "Restaurant",
"outarea": "South Dakota"
}
},
{
"json": {
"inarea": "Cheyenne",
"keyword": "Restaurant",
"outarea": "Wyoming"
}
},
{
"json": {
"inarea": "Casper",
"keyword": "Restaurant",
"outarea": "Wyoming"
}
},
{
"json": {
"inarea": "Laramie",
"keyword": "Restaurant",
"outarea": "Wyoming"
}
},
{
"json": {
"inarea": "Anchorage",
"keyword": "Restaurant",
"outarea": "Alaska"
}
},
{
"json": {
"inarea": "Fairbanks",
"keyword": "Restaurant",
"outarea": "Alaska"
}
},
{
"json": {
"inarea": "Honolulu",
"keyword": "Restaurant",
"outarea": "Hawaii"
}
},
{
"json": {
"inarea": "Pearl City",
"keyword": "Restaurant",
"outarea": "Hawaii"
}
},
{
"json": {
"inarea": "Newark",
"keyword": "Restaurant",
"outarea": "New Jersey"
}
},
{
"json": {
"inarea": "Jersey City",
"keyword": "Restaurant",
"outarea": "New Jersey"
}
},
{
"json": {
"inarea": "Paterson",
"keyword": "Restaurant",
"outarea": "New Jersey"
}
},
{
"json": {
"inarea": "Elizabeth",
"keyword": "Restaurant",
"outarea": "New Jersey"
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "b7f49248-62e5-4dc4-93d7-646fe7658777",
"connections": {
"Wait": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Split Out": {
"main": [
[
{
"node": "Set Output Fields",
"type": "main",
"index": 0
}
]
]
},
"Has Email?": {
"main": [
[
{
"node": "Append Items (No Website and/not Email)",
"type": "main",
"index": 1
}
],
[
{
"node": "Merge Items with HTML",
"type": "main",
"index": 0
},
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Append Items": {
"main": [
[
{
"node": "Filter Away Items With No Contact Info",
"type": "main",
"index": 0
}
]
]
},
"Clean Emails": {
"main": [
[
{
"node": "Append Items",
"type": "main",
"index": 1
}
]
]
},
"Extract List": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Extract List",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
]
]
},
"Organize Data": {
"main": [
[
{
"node": "Has No Website?",
"type": "main",
"index": 0
}
]
]
},
"Has No Website?": {
"main": [
[
{
"node": "Append Items (No Website and/not Email)",
"type": "main",
"index": 0
}
],
[
{
"node": "Has Email?",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "Merge Items with HTML",
"type": "main",
"index": 1
}
],
[
{
"node": "Get Website HTML",
"type": "main",
"index": 0
}
]
]
},
"Scrape HomePage": {
"main": [
[
{
"node": "Clean Emails",
"type": "main",
"index": 0
}
]
]
},
"Execute Workflow": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Get Website HTML": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items1": {
"main": [
[],
[
{
"node": "Execute Workflow",
"type": "main",
"index": 0
}
]
]
},
"Set Output Fields": {
"main": [
[
{
"node": "Organize Data",
"type": "main",
"index": 0
}
]
]
},
"Merge Items with HTML": {
"main": [
[
{
"node": "Scrape HomePage",
"type": "main",
"index": 0
}
]
]
},
"When Executed by Another Workflow": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Filter Away Items With No Contact Info": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Append Items (No Website and/not Email)": {
"main": [
[
{
"node": "Append Items",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 销售, 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
Google Maps邮箱采集器模板
无需使用任何第三方API从Google Maps抓取企业邮箱
Code
Wait
Filter
+10
26 节点Akram Kadri
销售
实时Notion Todoist双向同步模板
使用Redis的Notion Todoist实时双向同步
If
Set
Code
+26
246 节点Mario
销售
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
使用Google Maps生成潜在客户 - AlexK1919
使用Google Maps生成潜在客户
If
Set
Code
+13
42 节点Alex Kim
销售
HubSpot 联系人同步（含 LinkedIn URL）、变更检测与 Gmail 提醒
同步 HubSpot 联系人（含 LinkedIn URL），检测变更并发送 Gmail 提醒
If
Set
Code
+11
46 节点PollupAI
销售
工作流信息
难度等级
高级
节点数量27
分类2
节点类型15
作者
Akram Kadri
@akramkadrin8n Automation Freelancer ------------------------ Contact me at: akram@digispruce.com
外部链接
在 n8n.io 查看 →
分享此工作流