8
n8n 中文网amn8n.com

从Google地图提取商业邮箱到Google表格用于潜在客户生成

高级

这是一个Lead Generation, Multimodal AI领域的自动化工作流，包含 19 个节点。主要使用 Code, Wait, Filter, SplitOut, HttpRequest 等节点。 从Google地图提取商业邮箱到Google表格用于潜在客户生成

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

使用的节点 (19)

Code
Wait
Filter
SplitOut
StickyNote
HttpRequest
GoogleSheets
SplitInBatches
RemoveDuplicates
ChatTrigger

分类

潜在客户开发
多模态 AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "meta": {
    "instanceId": "95bbb5b970c767b3b6d7299c0acae6c888a5567209cf6474f05874e3c0844fea",
    "templateId": "5385"
  },
  "nodes": [
    {
      "id": "47d741e7-a53f-40c7-bf7c-09a446b0d229",
      "name": "去重",
      "type": "n8n-nodes-base.removeDuplicates",
      "position": [
        1168,
        544
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 2
    },
    {
      "id": "6cd049c8-425e-45e0-8d45-6a4883c2f496",
      "name": "遍历项目",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        336,
        848
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "3c3a3870-034d-4147-936a-4b0f19b7727d",
      "name": "等待",
      "type": "n8n-nodes-base.wait",
      "position": [
        512,
        1056
      ],
      "webhookId": "19cc6ed4-4fe7-485b-b879-c679e4b3374d",
      "parameters": {
        "amount": 1
      },
      "typeVersion": 1.1
    },
    {
      "id": "5f4ae91a-29c7-4fb3-b535-34bc5194b183",
      "name": "等待1",
      "type": "n8n-nodes-base.wait",
      "position": [
        496,
        800
      ],
      "webhookId": "0fe34756-6e43-4603-8891-5747a9a6500a",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "645bf31c-4b3c-4f4c-b90b-610fc2d6007c",
      "name": "拆分输出",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        864,
        800
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "emails"
      },
      "typeVersion": 1
    },
    {
      "id": "7e9c227c-2321-429a-a3f3-4c3a77bc6cf3",
      "name": "提取邮箱",
      "type": "n8n-nodes-base.code",
      "onError": "continueRegularOutput",
      "position": [
        688,
        1056
      ],
      "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": [
        832,
        544
      ],
      "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": [
        576,
        544
      ],
      "parameters": {
        "url": "=https://www.google.com/maps/search/{{ $json.chatInput }}",
        "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": [
        336,
        1056
      ],
      "parameters": {
        "url": "={{ $json.website }}",
        "options": {
          "redirect": {
            "redirect": {}
          }
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "4618e775-d14d-4355-b3a2-cd6a6bbc70e8",
      "name": "过滤空值",
      "type": "n8n-nodes-base.filter",
      "position": [
        672,
        800
      ],
      "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": [
        992,
        544
      ],
      "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": [
        1056,
        800
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 2
    },
    {
      "id": "aa3e9285-235d-4fda-ab0e-45134cf825dd",
      "name": "添加到表格（或任何您想要的操作！）",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1264,
        800
      ],
      "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": "10V7ikaGWmC-U73Z0sWOv1hfwbyMDvYNMS0lxlvA6C8c",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/10V7ikaGWmC-U73Z0sWOv1hfwbyMDvYNMS0lxlvA6C8c/edit?usp=drivesdk",
          "cachedResultName": "GMaps Scrapers"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "KGpn9qYCYQQErxFL",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "5ae34016-6347-474d-a95f-d8e2396fa5d0",
      "name": "当收到聊天消息时",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        400,
        544
      ],
      "webhookId": "f24b6138-da02-4d9a-802f-bce12176a1e5",
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.3
    },
    {
      "id": "794a397c-b98f-4ac7-a149-efd94672f9a0",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        320,
        480
      ],
      "parameters": {
        "width": 466,
        "height": 220,
        "content": "## 🔎 步骤 1：Google 地图数据抓取器"
      },
      "typeVersion": 1
    },
    {
      "id": "221aae1d-3546-42a1-bb2b-f743e02a300f",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        816,
        480
      ],
      "parameters": {
        "width": 544,
        "height": 196,
        "content": "## 🔗 步骤 2：URL 过滤与处理"
      },
      "typeVersion": 1
    },
    {
      "id": "d914e291-db43-4c45-908d-7d20890294cc",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        320,
        976
      ],
      "parameters": {
        "width": 528,
        "height": 248,
        "content": "## 🔄 步骤 3：智能网站抓取器"
      },
      "typeVersion": 1
    },
    {
      "id": "a6a902be-648e-41cd-a4fe-00f50cabe78c",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        480,
        720
      ],
      "parameters": {
        "width": 916,
        "height": 248,
        "content": "## 📧 步骤 4：电子邮件提取与数据导出"
      },
      "typeVersion": 1
    },
    {
      "id": "ac1ba88f-3538-40e9-ad89-84a73da7d239",
      "name": "便签 5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        864,
        976
      ],
      "parameters": {
        "width": 528,
        "height": 240,
        "content": "## 🚀 获取更多资源和高级工作流程"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Wait": {
      "main": [
        [
          {
            "node": "Extract Emails",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait1": {
      "main": [
        [
          {
            "node": "Filter Out Empties",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out": {
      "main": [
        [
          {
            "node": "Remove Duplicates (2)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Scrape Site": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract URLs": {
      "main": [
        [
          {
            "node": "Filter Google URLs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Emails": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Wait1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Scrape Site",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Remove Duplicates": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Google URLs": {
      "main": [
        [
          {
            "node": "Remove Duplicates",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Out Empties": {
      "main": [
        [
          {
            "node": "Split Out",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Scrape Google Maps": {
      "main": [
        [
          {
            "node": "Extract URLs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Remove Duplicates (2)": {
      "main": [
        [
          {
            "node": "Add to Sheet (or whatever you want!)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When chat message received": {
      "main": [
        [
          {
            "node": "Scrape Google Maps",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

高级 - 潜在客户开发, 多模态 AI

需要付费吗？

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

相关工作流推荐

从Google地图列表提取商业邮箱用于潜在客户生成
从Google地图列表提取商业邮箱用于潜在客户生成
Code
Wait
Limit
+8
20 节点Jose Castillo
潜在客户开发
使用HTTP请求和JavaScript的Google Maps邮箱采集器
线索生成系统：从Google Maps到邮箱采集器，导出至Google Sheets
Code
Wait
Limit
+8
19 节点Nick Saraev
潜在客户开发
从 Google Maps 列表抓取企业邮箱到 Google Sheets
从 Google Maps 列表抓取企业邮箱到 Google Sheets
Code
Wait
Limit
+8
19 节点Meak
内容创作
基于AI的潜在客户生成系统（邮件个性化和LinkedIn）
基于AI的潜在客户生成系统：包含邮件个性化和LinkedIn功能
If
Code
Limit
+11
51 节点Matthieu
潜在客户开发
使用LinkedIn、OpenAI和Sales Navigator创建合格线索和冷呼叫脚本
通过LinkedIn、OpenAI和Sales Navigator创建合格线索和冷呼叫脚本
If
Code
Limit
+11
47 节点Matthieu
潜在客户开发
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
工作流信息
难度等级
高级
节点数量19
分类2
节点类型10
难度说明

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

作者
Noman Mohammad

Noman Mohammad

@nomanmohammad

Hi 👋 I'm Noman Mohammad. I do a lot of things, and AI is part of that work. If you have any questions about my templates or my n8n builds, feel free to ask, and I'll gladly reply in the comments. Thank you for reading.

外部链接
在 n8n.io 查看 →

分享此工作流