使用Anymail Finder验证潜在客户电子邮件地址
中级
这是一个Lead Generation, Multimodal AI领域的自动化工作流,包含 6 个节点。主要使用 HttpRequest, GoogleSheets, ManualTrigger, SplitInBatches 等节点。 使用Google表格和Anymail Finder批量验证潜在客户电子邮件
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"id": "bvYcq5zrLPePpJPm",
"meta": {
"instanceId": "a4bfc93e975ca233ac45ed7c9227d84cf5a2329310525917adaf3312e10d5462",
"templateCredsSetupCompleted": true
},
"name": "使用 Anymail Finder 验证潜在客户电子邮件地址",
"tags": [],
"nodes": [
{
"id": "b440f1f9-ec22-4958-bf05-e1d65f277951",
"name": "手动触发器",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-704,
-448
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5094115d-4649-4d28-847d-541e3b4b1494",
"name": "获取潜在客户",
"type": "n8n-nodes-base.googleSheets",
"position": [
-496,
-448
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupColumn": "VERIFY"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/108sjf89zpKRyZbGq9MjcNFQOezP4hi97SJ_uAkXc8WI/edit#gid=0",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "108sjf89zpKRyZbGq9MjcNFQOezP4hi97SJ_uAkXc8WI",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/108sjf89zpKRyZbGq9MjcNFQOezP4hi97SJ_uAkXc8WI/edit?usp=drivesdk",
"cachedResultName": "Verify leads email"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JYR6a64Qecd6t8Hb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "3cde3dfb-91dc-4863-ad0f-aedd7078cd18",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-288,
-448
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "311399e5-d190-4e72-9968-c9c2ec88fbe1",
"name": "更新电子邮件状态",
"type": "n8n-nodes-base.googleSheets",
"position": [
320,
-448
],
"parameters": {
"columns": {
"value": {
"VERIFY": "={{ $json.email_status }}",
"row_number": "={{ $('Loop Over Items').item.json.row_number }}"
},
"schema": [
{
"id": "COMPANY NAME",
"type": "string",
"display": true,
"required": false,
"displayName": "COMPANY NAME",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL ",
"type": "string",
"display": true,
"required": false,
"displayName": "EMAIL ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "VERIFY",
"type": "string",
"display": true,
"required": false,
"displayName": "VERIFY",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/108sjf89zpKRyZbGq9MjcNFQOezP4hi97SJ_uAkXc8WI/edit#gid=0",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "108sjf89zpKRyZbGq9MjcNFQOezP4hi97SJ_uAkXc8WI",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/108sjf89zpKRyZbGq9MjcNFQOezP4hi97SJ_uAkXc8WI/edit?usp=drivesdk",
"cachedResultName": "Verify leads email"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JYR6a64Qecd6t8Hb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "6c24bae6-fb01-4071-ba23-b5613a9a6c7b",
"name": "检查电子邮件状态",
"type": "n8n-nodes-base.httpRequest",
"notes": "This node sends the request to Anymailfinder.\nMake sure you've connected your API key in the credentials (HTTP Header Auth).",
"onError": "continueErrorOutput",
"position": [
-16,
-432
],
"parameters": {
"url": "https://api.anymailfinder.com/v5.1/verify-email",
"method": "POST",
"options": {
"timeout": 180000
},
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "email",
"value": "={{ $json[\"EMAIL \"] }}"
}
]
},
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "h3AkgiVUAlGDw3Ec",
"name": "Anymail Finder"
}
},
"typeVersion": 4.2
},
{
"id": "7d2a131c-527e-44ac-b4b9-089dcc3245b0",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-704,
-768
],
"parameters": {
"width": 608,
"height": 256,
"content": "## 使用 Anymail Finder 验证潜在客户电子邮件地址"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "b53ba6c5-ac90-42d7-90a9-13b405c13206",
"connections": {
"Get Leads": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Manual Trigger": {
"main": [
[
{
"node": "Get Leads",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Check email status",
"type": "main",
"index": 0
}
]
]
},
"Check email status": {
"main": [
[
{
"node": "Update email status",
"type": "main",
"index": 0
}
],
[]
]
},
"Update email status": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
中级 - 潜在客户开发, 多模态 AI
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
适用于WooCommerce Nano Banana的AI虚拟试穿
使用Fal.ai Nano Banana为WooCommerce自动生成虚拟AI试穿图像
If
Set
Wait
+7
20 节点Davide
内容创作
使用 Anymail Finder 根据公司名称查找邮箱
使用 Anymail Finder、Google Sheets 和 Telegram 提醒自动化公司邮箱发现
Switch
Telegram
Http Request
+4
12 节点Davide
潜在客户开发
使用 ElevenLabs 转录和分析会议或播客
使用 ElevenLabs 和 Google Gemini AI 转录分析会议或播客
Gmail
Markdown
Google Docs
+8
17 节点Davide
内容创作
基于AI的潜在客户生成系统(邮件个性化和LinkedIn)
基于AI的潜在客户生成系统:包含邮件个性化和LinkedIn功能
If
Code
Limit
+11
51 节点Matthieu
潜在客户开发
从WordPress使用Postiz的AI社交媒体发布器
使用Claude和Postiz从WordPress自动生成平台优化的社交媒体帖子
Postiz
Wordpress
Http Request
+7
23 节点Davide
社交媒体
使用免费邮箱丰富功能自动化Google Maps潜在客户生成至Google Sheets
使用免费邮箱丰富功能自动化Google Maps潜在客户生成至Google Sheets
If
Code
Split Out
+5
18 节点Zain Khan
潜在客户开发
工作流信息
难度等级
中级
节点数量6
分类2
节点类型5
作者
Davide
@n3witaliaFull-stack Web Developer based in Italy specialising in Marketing & AI-powered automations. For business enquiries, send me an email at info@n3w.it or add me on Linkedin.com/in/davideboizza
外部链接
在 n8n.io 查看 →
分享此工作流