8
n8n 中文网amn8n.com

使用HTTP请求和JavaScript的Google Maps邮箱采集器

高级

这是一个Lead Generation领域的自动化工作流，包含 19 个节点。主要使用 Code, Wait, Limit, Filter, SplitOut 等节点。 线索生成系统：从Google Maps到邮箱采集器，导出至Google Sheets

前置要求
  • •可能需要目标 API 的认证凭证
  • •Google Sheets API 凭证

使用的节点 (19)

Code
Wait
Limit
Filter
SplitOut
StickyNote
HttpRequest
GoogleSheets
ManualTrigger
SplitInBatches
RemoveDuplicates

分类

潜在客户开发
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "xiabGWCXUOe469Nm",
  "meta": {
    "instanceId": "d7661a849ead114a9aa6d9ceaf4160465aeb79532a35bde62160c840ffba9fc8"
  },
  "name": "使用 HTTP 请求和 JavaScript 的 Google Maps 邮箱采集器",
  "tags": [
    {
      "id": "l8MPK4ZirgwFWMno",
      "name": "N8N Course",
      "createdAt": "2025-01-23T18:12:52.273Z",
      "updatedAt": "2025-01-23T18:12:52.273Z"
    }
  ],
  "nodes": [
    {
      "id": "sticky-note-1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        100,
        -280
      ],
      "parameters": {
        "width": 350,
        "height": 180,
        "content": "## 🗺️ 步骤 1：Google Maps 数据提取"
      },
      "typeVersion": 1
    },
    {
      "id": "sticky-note-2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        300,
        -320
      ],
      "parameters": {
        "width": 380,
        "height": 200,
        "content": "## 🔗 步骤 2：网站 URL 处理"
      },
      "typeVersion": 1
    },
    {
      "id": "sticky-note-3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        700,
        -320
      ],
      "parameters": {
        "width": 380,
        "height": 200,
        "content": "## 🔄 步骤 3：智能网站采集"
      },
      "typeVersion": 1
    },
    {
      "id": "sticky-note-4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1100,
        -340
      ],
      "parameters": {
        "width": 400,
        "height": 220,
        "content": "## 📧 步骤 4：邮箱提取与导出"
      },
      "typeVersion": 1
    },
    {
      "id": "4a6f9faa-5b11-41fe-88c9-cc8a262a2de2",
      "name": "点击\"测试工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        140,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "47d741e7-a53f-40c7-bf7c-09a446b0d229",
      "name": "移除重复项",
      "type": "n8n-nodes-base.removeDuplicates",
      "position": [
        940,
        0
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 2
    },
    {
      "id": "6cd049c8-425e-45e0-8d45-6a4883c2f496",
      "name": "遍历项目",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1340,
        0
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "3c3a3870-034d-4147-936a-4b0f19b7727d",
      "name": "等待",
      "type": "n8n-nodes-base.wait",
      "position": [
        1700,
        100
      ],
      "webhookId": "19cc6ed4-4fe7-485b-b879-c679e4b3374d",
      "parameters": {
        "amount": 1
      },
      "typeVersion": 1.1
    },
    {
      "id": "a377879d-517d-4c90-a3d4-a7a0c190787e",
      "name": "限制",
      "type": "n8n-nodes-base.limit",
      "position": [
        1120,
        0
      ],
      "parameters": {
        "maxItems": 10
      },
      "typeVersion": 1
    },
    {
      "id": "5f4ae91a-29c7-4fb3-b535-34bc5194b183",
      "name": "等待1",
      "type": "n8n-nodes-base.wait",
      "position": [
        1520,
        -60
      ],
      "webhookId": "0fe34756-6e43-4603-8891-5747a9a6500a",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "645bf31c-4b3c-4f4c-b90b-610fc2d6007c",
      "name": "拆分输出",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1880,
        -60
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "emails"
      },
      "typeVersion": 1
    },
    {
      "id": "7e9c227c-2321-429a-a3f3-4c3a77bc6cf3",
      "name": "提取邮箱",
      "type": "n8n-nodes-base.code",
      "onError": "continueRegularOutput",
      "position": [
        1880,
        100
      ],
      "parameters": {
        "jsCode": "const input = $input.first().json.data\nconst regex = /[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.(?!jpeg|jpg|png|gif|webp|svg)[a-zA-Z]{2,}/g\nconst emails = input.match(regex)\nreturn {json: {emails:emails}}"
      },
      "typeVersion": 2,
      "alwaysOutputData": true
    },
    {
      "id": "fb76c70c-385d-4e7f-93cd-43023690076a",
      "name": "提取 URL",
      "type": "n8n-nodes-base.code",
      "position": [
        540,
        0
      ],
      "parameters": {
        "jsCode": "const input = $input.first().json.data\nconst regex = /https?:\\/\\/[^\\/\\s\"'>]+/g\nconst websites = input.match(regex)\nreturn websites.map(website => ({json:{website}}))"
      },
      "typeVersion": 2
    },
    {
      "id": "b10c0ed6-5a94-4272-b65c-bd19bd674fa0",
      "name": "采集 Google Maps",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        340,
        0
      ],
      "parameters": {
        "url": "https://www.google.com/maps/search/calgary+dentists",
        "options": {
          "response": {
            "response": {
              "fullResponse": true
            }
          },
          "allowUnauthorizedCerts": true
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "58a0d85d-f6eb-47d1-ba9c-3af69ddd30fb",
      "name": "采集网站",
      "type": "n8n-nodes-base.httpRequest",
      "onError": "continueRegularOutput",
      "position": [
        1520,
        100
      ],
      "parameters": {
        "url": "={{ $json.website }}",
        "options": {
          "redirect": {
            "redirect": {
              "followRedirects": false
            }
          }
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "4618e775-d14d-4355-b3a2-cd6a6bbc70e8",
      "name": "过滤空值",
      "type": "n8n-nodes-base.filter",
      "position": [
        1700,
        -60
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "a6786c58-424a-409a-b87f-8a7592cb7944",
              "operator": {
                "type": "array",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.emails }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "74513e7e-a7dc-4b19-b23e-01efd82c9d6d",
      "name": "过滤 Google URL",
      "type": "n8n-nodes-base.filter",
      "position": [
        740,
        0
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "bf0a5053-9660-457c-9581-964793bb6d7d",
              "operator": {
                "type": "string",
                "operation": "notContains"
              },
              "leftValue": "={{ $json.website }}",
              "rightValue": "schema"
            },
            {
              "id": "9110b9e0-12aa-45cc-bde0-9eda8c10970e",
              "operator": {
                "type": "string",
                "operation": "notContains"
              },
              "leftValue": "={{ $json.website }}",
              "rightValue": "google"
            },
            {
              "id": "fb9b6ed6-96a5-4560-ab10-b8a4b9a61a2b",
              "operator": {
                "type": "string",
                "operation": "notContains"
              },
              "leftValue": "={{ $json.website }}",
              "rightValue": "gg"
            },
            {
              "id": "10500c0b-cdbd-4816-aba3-df60d69845dc",
              "operator": {
                "type": "string",
                "operation": "notContains"
              },
              "leftValue": "={{ $json.website }}",
              "rightValue": "gstatic"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "035fbbe8-7758-4c7b-be8e-c1cba8fc48bc",
      "name": "移除重复项 (2)",
      "type": "n8n-nodes-base.removeDuplicates",
      "position": [
        2080,
        -60
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 2
    },
    {
      "id": "aa3e9285-235d-4fda-ab0e-45134cf825dd",
      "name": "添加到表格（或您想要的任何操作！）",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2280,
        -60
      ],
      "parameters": {
        "columns": {
          "value": {
            "emails": "={{ $json.emails }}"
          },
          "schema": [
            {
              "id": "emails",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "emails",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "emails"
          ]
        },
        "options": {
          "useAppend": true
        },
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fcijyZM1oU73i2xUbXYJ4j6RshmVEduOkCJji2SJP68/edit#gid=0",
          "cachedResultName": "emails"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1fcijyZM1oU73i2xUbXYJ4j6RshmVEduOkCJji2SJP68",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fcijyZM1oU73i2xUbXYJ4j6RshmVEduOkCJji2SJP68/edit?usp=drivesdk",
          "cachedResultName": "Scrape WITHOUT Paying for APIs"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "EOibXIc4U8wcXyRR",
          "name": "YouTube"
        }
      },
      "typeVersion": 4.5
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "9e487a0d-a606-4859-a6e2-b70372b61388",
  "connections": {
    "3c3a3870-034d-4147-936a-4b0f19b7727d": {
      "main": [
        [
          {
            "node": "7e9c227c-2321-429a-a3f3-4c3a77bc6cf3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a377879d-517d-4c90-a3d4-a7a0c190787e": {
      "main": [
        [
          {
            "node": "6cd049c8-425e-45e0-8d45-6a4883c2f496",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5f4ae91a-29c7-4fb3-b535-34bc5194b183": {
      "main": [
        [
          {
            "node": "4618e775-d14d-4355-b3a2-cd6a6bbc70e8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "645bf31c-4b3c-4f4c-b90b-610fc2d6007c": {
      "main": [
        [
          {
            "node": "035fbbe8-7758-4c7b-be8e-c1cba8fc48bc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "58a0d85d-f6eb-47d1-ba9c-3af69ddd30fb": {
      "main": [
        [
          {
            "node": "3c3a3870-034d-4147-936a-4b0f19b7727d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fb76c70c-385d-4e7f-93cd-43023690076a": {
      "main": [
        [
          {
            "node": "74513e7e-a7dc-4b19-b23e-01efd82c9d6d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7e9c227c-2321-429a-a3f3-4c3a77bc6cf3": {
      "main": [
        [
          {
            "node": "6cd049c8-425e-45e0-8d45-6a4883c2f496",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6cd049c8-425e-45e0-8d45-6a4883c2f496": {
      "main": [
        [
          {
            "node": "5f4ae91a-29c7-4fb3-b535-34bc5194b183",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "58a0d85d-f6eb-47d1-ba9c-3af69ddd30fb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "47d741e7-a53f-40c7-bf7c-09a446b0d229": {
      "main": [
        [
          {
            "node": "a377879d-517d-4c90-a3d4-a7a0c190787e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "74513e7e-a7dc-4b19-b23e-01efd82c9d6d": {
      "main": [
        [
          {
            "node": "47d741e7-a53f-40c7-bf7c-09a446b0d229",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4618e775-d14d-4355-b3a2-cd6a6bbc70e8": {
      "main": [
        [
          {
            "node": "645bf31c-4b3c-4f4c-b90b-610fc2d6007c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b10c0ed6-5a94-4272-b65c-bd19bd674fa0": {
      "main": [
        [
          {
            "node": "fb76c70c-385d-4e7f-93cd-43023690076a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "035fbbe8-7758-4c7b-be8e-c1cba8fc48bc": {
      "main": [
        [
          {
            "node": "aa3e9285-235d-4fda-ab0e-45134cf825dd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4a6f9faa-5b11-41fe-88c9-cc8a262a2de2": {
      "main": [
        [
          {
            "node": "b10c0ed6-5a94-4272-b65c-bd19bd674fa0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

高级 - 潜在客户开发

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

从Google地图列表提取商业邮箱用于潜在客户生成
从Google地图列表提取商业邮箱用于潜在客户生成
Code
Wait
Limit
+
Code
Wait
Limit
20 节点Jose Castillo
潜在客户开发
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+
If
Set
Code
141 节点Ezema Kingsley Chibuzo
潜在客户开发
使用 Apify、GPT-4o 和 Facebook
使用 Apify、GPT-4o 和 Facebook 广告库进行竞争广告研究与图像生成
Set
Wait
Limit
+
Set
Wait
Limit
32 节点Nick Saraev
内容创作
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+
If
Ftp
Set
113 节点I versus AI
其他
使用Google Maps生成潜在客户 - AlexK1919
使用Google Maps生成潜在客户
If
Set
Code
+
If
Set
Code
42 节点Alex Kim
销售
基于AI的潜在客户生成系统（邮件个性化和LinkedIn）
基于AI的潜在客户生成系统：包含邮件个性化和LinkedIn功能
If
Code
Limit
+
If
Code
Limit
51 节点Matthieu
潜在客户开发
工作流信息
难度等级
高级
节点数量19
分类1
节点类型11
难度说明

适合高级用户，包含 16+ 个节点的复杂工作流

作者
Nick Saraev

Nick Saraev

@nicksaraev

Hi 👋 I'm Nick. I make money with automation & teach others how they can too. If you have any questions about my templates or about my n8n builds, feel free to ask and I'll happily respond in the comments. Thanks for reading!

外部链接
在 n8n.io 查看 →

分享此工作流

分类

多模态 AI
1540
人工智能
1108
内容创作
695
AI 摘要总结
516
营销
419
AI 聊天机器人
251
工程
241
市场调研
203
杂项
193
其他
176
销售
162
IT 运维
156
文档提取
147
AI RAG 检索增强
146
构建模块
144
社交媒体
137
潜在客户开发
125
个人效率
117
开发运维
111
人力资源
101
客户支持
97
客户培育
87
客户关系管理
82
财务
81
产品
77
客服机器人
76
设计
70
工单管理
67
安全运维
57
发票处理
53
加密货币交易
49
文件管理
39
项目管理
35
内部知识库
32

分类: 34