8
n8n 中文网amn8n.com

06 - 潜在客户邮箱验证工作流

中级

这是一个Lead Generation领域的自动化工作流，包含 9 个节点。主要使用 Code, HttpRequest, GoogleSheets, ScheduleTrigger 等节点。 使用 Hunter.io 和 Google Sheets 验证潜在客户邮箱地址

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

使用的节点 (9)

Code
StickyNote
HttpRequest
GoogleSheets
ScheduleTrigger

分类

潜在客户开发
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "CbuL77uh6tA3fVsy",
  "meta": {
    "instanceId": "c91c5b6efe2709e07c37996245857ac5d863d575d07e0072127351337c204c40",
    "templateCredsSetupCompleted": true
  },
  "name": "06 - 潜在客户邮箱验证工作流",
  "tags": [],
  "nodes": [
    {
      "id": "5722ab46-2a4a-4f51-97ca-e5dc97a58fa1",
      "name": "📥 从源表格获取邮箱",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -40,
        -20
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/{{YOUR_INPUT_SHEET_ID}}/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "{{YOUR_INPUT_SHEET_ID}}",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/{{YOUR_INPUT_SHEET_ID}}/edit?usp=drivesdk",
          "cachedResultName": "Emails"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "LJQH5glroAM1SiFe",
          "name": "Google Sheets OAuth2"
        }
      },
      "typeVersion": 4
    },
    {
      "id": "84ba1906-ec77-4890-8499-81521c215ddf",
      "name": "🧹 清理和准备邮箱数据",
      "type": "n8n-nodes-base.code",
      "position": [
        180,
        -20
      ],
      "parameters": {
        "jsCode": "// Process email data and prepare for verification\nconst items = [];\n\nfor (const item of $input.all()) {\n  const email = item.json.Email || item.json.email;\n\n  if (email && email.includes('@')) {\n    items.push({\n      json: {\n        email: email,\n        originalRowIndex: item.json.row_number || items.length + 2,\n        firstName: item.json.FirstName || '',\n        lastName: item.json.LastName || '',\n        company: item.json.Company || ''\n      }\n    });\n  }\n}\n\nreturn items;"
      },
      "typeVersion": 2
    },
    {
      "id": "330e8cf0-dfc3-49d7-bcad-8343fa329740",
      "name": "🕵️‍♂️ Hunter.io 邮箱验证器",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        400,
        -20
      ],
      "parameters": {
        "url": "https://api.hunter.io/v2/email-verifier",
        "options": {},
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "email",
              "value": "={{ $json.email }}"
            },
            {
              "name": "api_key",
              "value": "{{HUNTER_API_KEY}}"
            }
          ]
        }
      },
      "typeVersion": 4
    },
    {
      "id": "0b103e51-5df5-4825-8e4d-28498fa127b2",
      "name": "🧠 格式化 Hunter 响应",
      "type": "n8n-nodes-base.code",
      "position": [
        620,
        -20
      ],
      "parameters": {
        "jsCode": "// Process Hunter.io verification results\nconst originalData = $('🧹 Clean & Prepare Email Data').all();\nconst hunterResults = $('🕵️‍♂️ Hunter.io Email Verifier').all();\n\nconst results = [];\n\nfor (let i = 0; i < originalData.length; i++) {\n  const original = originalData[i].json;\n  const hunter = hunterResults[i]?.json?.data || {};\n\n  const result = {\n    email: original.email,\n    firstName: original.firstName,\n    lastName: original.lastName,\n    company: original.company,\n    rowIndex: original.originalRowIndex,\n\n    // Key Hunter.io verification fields\n    status: hunter.status || 'unknown',\n    score: hunter.score || 0,\n    smtpCheck: hunter.smtp_check || false,\n    acceptAll: hunter.accept_all || false,\n    sourceCount: Array.isArray(hunter.sources) ? hunter.sources.length : 0,\n\n    // Optional extras if needed later\n    regex: hunter.regex || false,\n    gibberish: hunter.gibberish || false,\n    disposable: hunter.disposable || false,\n    webmail: hunter.webmail || false,\n    mxRecords: hunter.mx_records || false,\n    smtpServer: hunter.smtp_server || false,\n    block: hunter.block || false,\n\n    // Human-friendly summary\n    statusSummary: `${hunter.status || 'unknown'} (${hunter.score || 0}% confidence)`\n  };\n\n  results.push({ json: result });\n}\n\nreturn results;"
      },
      "typeVersion": 2
    },
    {
      "id": "b999f5c9-9001-435d-bf33-05861d891b54",
      "name": "📤 将结果写入输出表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        840,
        -20
      ],
      "parameters": {
        "columns": {
          "value": {
            "email": "={{ $json.email }}",
            "score": "={{ $json.score }}",
            "status": "={{ $json.status }}",
            "company": "={{ $json.company }}",
            "lastName": "={{ $json.lastName }}",
            "firstName": "={{ $json.firstName }}",
            "smtp_check": "={{ $json.smtpCheck }}",
            "statusSummary": "={{ $json.statusSummary }}"
          },
          "schema": [
            {
              "id": "firstName",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "firstName",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "lastName",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "lastName",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "email",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "company",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "company",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "status",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "score",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "score",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "smtp_check",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "smtp_check",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "statusSummary",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "statusSummary",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "email"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/{{YOUR_OUTPUT_SHEET_ID}}/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "{{YOUR_OUTPUT_SHEET_ID}}",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/{{YOUR_OUTPUT_SHEET_ID}}edit?usp=drivesdk",
          "cachedResultName": "Email Verifier"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "LJQH5glroAM1SiFe",
          "name": "Google Sheets OAuth2"
        }
      },
      "typeVersion": 4
    },
    {
      "id": "d6d80276-4911-455a-b0c5-4196aec824e5",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -300,
        -320
      ],
      "parameters": {
        "width": 420,
        "height": 560,
        "content": "## 启动与输入源"
      },
      "typeVersion": 1
    },
    {
      "id": "3472c014-1657-4f35-92fd-b6b6775cbb6b",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        140,
        -320
      ],
      "parameters": {
        "width": 420,
        "height": 560,
        "content": "## 清理与验证邮箱"
      },
      "typeVersion": 1
    },
    {
      "id": "51f38886-34e7-418e-b655-4a2b0a3b8eb7",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        580,
        -320
      ],
      "parameters": {
        "width": 400,
        "height": 560,
        "content": "## 后处理与输出"
      },
      "typeVersion": 1
    },
    {
      "id": "9ce17c7f-221c-4268-8438-f95c99c39e09",
      "name": "⏯️ 每日触发",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -260,
        -20
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "16b71444-6e2f-4b01-8714-b5669a5c6d56",
  "connections": {
    "⏯️ Triggers Everyday": {
      "main": [
        [
          {
            "node": "📥 Fetch Emails from Source Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🧠 Format Hunter Response": {
      "main": [
        [
          {
            "node": "📤 Write Results to Output Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🧹 Clean & Prepare Email Data": {
      "main": [
        [
          {
            "node": "🕵️‍♂️ Hunter.io Email Verifier",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📥 Fetch Emails from Source Sheet": {
      "main": [
        [
          {
            "node": "🧹 Clean & Prepare Email Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🕵️‍♂️ Hunter.io Email Verifier": {
      "main": [
        [
          {
            "node": "🧠 Format Hunter Response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 潜在客户开发

需要付费吗？

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

相关工作流推荐

08 - AI驱动的联系人智能分析
使用GPT-4o-mini为Google表格、Airtable和HubSpot分类和丰富联系人信息
Code
Filter
Hubspot
+6
15 节点Avkash Kakdiya
潜在客户开发
07 - 自动化职位筛选引擎
使用 JSearch API 和 Google Sheets 自动化职位搜索与筛选
Code
Filter
Http Request
+3
10 节点Avkash Kakdiya
人力资源
28 - 融资洞察流水线
使用Crunchbase、Google Sheets和Airtable自动化融资洞察
Code
Filter
Airtable
+4
9 节点Avkash Kakdiya
市场调研
AI 产品图片生成器 - 公共模板
使用 OpenAI、Gemini 和 Google Workspace 的自动化产品广告图片创建
Code
Google Drive
Http Request
+6
15 节点Avkash Kakdiya
内容创作
10 - 商业版图追踪器
使用SerpAPI、Google表格和Airtable的每日竞争对手研究自动化
If
Code
Airtable
+5
15 节点Avkash Kakdiya
市场调研
AI驱动的谷歌地图商家数据抓取与表格导出
基于AI的谷歌地图商家数据抓取，支持数据丰富化并导出至表格
If
Code
Wait
+13
25 节点Msaid Mohamed el hadi
潜在客户开发
工作流信息
难度等级
中级
节点数量9
分类1
节点类型5
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Avkash Kakdiya

Avkash Kakdiya

@itechnotion

🚀 Founder of iTechNotion — we build custom AI-powered automation workflows for startups, agencies, and founders. 💡 Specializing in agentic AI systems, content automation, sales funnels, and digital workers. 🔧 14+ years in tech | Building scalable no-code/low-code solutions using n8n, OpenAI, and other API-first tools. 📬 Let’s automate what slows you down.

外部链接
在 n8n.io 查看 →

分享此工作流