使用 Anymail Finder 根据公司名称查找邮箱
中级
这是一个Lead Generation领域的自动化工作流，包含 12 个节点。主要使用 Switch, Telegram, HttpRequest, GoogleSheets, ManualTrigger 等节点。 使用 Anymail Finder、Google Sheets 和 Telegram 提醒自动化公司邮箱发现
前置要求
- •Telegram Bot Token
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "8WkZpiRCYlakSpNY",
"meta": {
"instanceId": "a4bfc93e975ca233ac45ed7c9227d84cf5a2329310525917adaf3312e10d5462",
"templateCredsSetupCompleted": true
},
"name": "使用 Anymail Finder 根据公司名称查找邮箱",
"tags": [],
"nodes": [
{
"id": "24f96fe4-0e5f-4127-90d9-754ef254a48e",
"name": "手动触发器",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-704,
-448
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1eb2df5c-ad7f-43c7-bb51-26cac9111075",
"name": "获取潜在客户",
"type": "n8n-nodes-base.googleSheets",
"position": [
-496,
-448
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupColumn": "PROCESSING"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU/edit#gid=0",
"cachedResultName": "Foglio1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU/edit?usp=drivesdk",
"cachedResultName": "Find Email by Company"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JYR6a64Qecd6t8Hb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "1b4cb64a-d43b-4063-8884-e163fcd93c46",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-288,
-448
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "a6da4992-d53b-4e09-9deb-4ce0aeaa79fe",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-720,
-704
],
"parameters": {
"width": 608,
"height": 144,
"content": "- 克隆此[表格](https://docs.google.com/spreadsheets/d/1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU/edit?usp=sharing)"
},
"typeVersion": 1
},
{
"id": "539a8f1c-bdcd-4450-bd63-a4845063d6bf",
"name": "切换",
"type": "n8n-nodes-base.switch",
"position": [
272,
-464
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "valid",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e2d035e7-353e-4c3e-a82a-5ab3ad5de400",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.email_status }}",
"rightValue": "valid"
}
]
},
"renameOutput": true
},
{
"outputKey": "risky",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7440ef17-b184-49f9-bc92-0ec289e11ccf",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.email_status }}",
"rightValue": "risky"
}
]
},
"renameOutput": true
},
{
"outputKey": "not found",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7eec38fb-005c-4ea7-9b7b-2e39e0ac4156",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "",
"rightValue": ""
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "6259403f-2327-438d-97e1-7b4a8a369158",
"name": "找到邮箱",
"type": "n8n-nodes-base.googleSheets",
"position": [
576,
-496
],
"parameters": {
"columns": {
"value": {
"EMAIL": "={{JSON.stringify( $json.emails) }}",
"PROCESSING": "x",
"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": "WEBSITE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "WEBSITE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "EMAIL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PROCESSING",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PROCESSING",
"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": "1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU/edit?usp=drivesdk",
"cachedResultName": "Find Email by Company"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JYR6a64Qecd6t8Hb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "02a1ec6c-4e58-44c5-b7ba-891e4065594d",
"name": "未找到邮箱",
"type": "n8n-nodes-base.googleSheets",
"position": [
784,
-416
],
"parameters": {
"columns": {
"value": {
"EMAIL": "=",
"PROCESSING": "x",
"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": "WEBSITE",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "WEBSITE",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "EMAIL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "EMAIL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "PROCESSING",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "PROCESSING",
"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": "1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yH5f_z6HeHN5KJBdMbij_-KKX47rKnSIGPj_OUTO0LU/edit?usp=drivesdk",
"cachedResultName": "Find Email by Company"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "JYR6a64Qecd6t8Hb",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "2f24945d-a082-474b-86bf-d552f6728289",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
224,
-528
],
"parameters": {
"width": 224,
"height": 224,
"content": "分类邮箱是否有效、有风险或未找到"
},
"typeVersion": 1
},
{
"id": "8dad63c6-d171-4895-86f0-65e7d73f56ae",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-48,
-528
],
"parameters": {
"width": 224,
"height": 224,
"content": "查找邮箱"
},
"typeVersion": 1
},
{
"id": "4e1ff1f3-c0c8-406b-bd79-d008fabac373",
"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": [
0,
-432
],
"parameters": {
"url": "https://api.anymailfinder.com/v5.1/find-email/company",
"method": "POST",
"options": {
"timeout": 180000
},
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "domain",
"value": "={{ $json[\"WEBSITE\"] }}"
},
{
"name": "company_name",
"value": "={{ $json[\"COMPANY NAME\"] }}"
}
]
},
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "h3AkgiVUAlGDw3Ec",
"name": "Anymail Finder"
}
},
"typeVersion": 4.2
},
{
"id": "3a741450-561c-49de-bb53-988b7afa2cb6",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-720,
-896
],
"parameters": {
"color": 3,
"width": 608,
"content": "## 使用 Anymail Finder 根据公司查找邮箱地址"
},
"typeVersion": 1
},
{
"id": "2bd1b49d-7f98-4a80-aa07-48413a896ed6",
"name": "发送警报",
"type": "n8n-nodes-base.telegram",
"position": [
1008,
-416
],
"webhookId": "16b603d6-121f-4531-b01f-0fb8e22c06ba",
"parameters": {
"text": "Alert! Email not found",
"chatId": "XXXXXX",
"additionalFields": {}
},
"credentials": {
"telegramApi": {
"id": "rQ5q95W7uKesMDx4",
"name": "Telegram account Fastewb"
}
},
"typeVersion": 1.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "33bcd6d5-9863-4fcb-bae2-95cbc800c354",
"connections": {
"Switch": {
"main": [
[
{
"node": "Email found",
"type": "main",
"index": 0
}
],
[
{
"node": "Email found",
"type": "main",
"index": 0
}
],
[
{
"node": "Email not found",
"type": "main",
"index": 0
}
]
]
},
"Get Leads": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Send Alert": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Email found": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Email finder": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
]
]
},
"Manual Trigger": {
"main": [
[
{
"node": "Get Leads",
"type": "main",
"index": 0
}
]
]
},
"Email not found": {
"main": [
[
{
"node": "Send Alert",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Email finder",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 潜在客户开发
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Anymail Finder验证潜在客户电子邮件地址
使用Google表格和Anymail Finder批量验证潜在客户电子邮件
Http Request
Google Sheets
Manual Trigger
+2
6 节点Davide
潜在客户开发
AI驱动的WooCommerce产品导入器与SEO
基于Google表格的AI驱动WooCommerce产品导入器，含Yoast SEO元数据
Code
Telegram
Woo Commerce
+7
16 节点Davide
销售
生成考试题目
基于Google文档和Gemini的AI驱动自动生成考试题目与答案
Code
Google Docs
Http Request
+17
37 节点Davide
其他
适用于WooCommerce Nano Banana的AI虚拟试穿
使用Fal.ai Nano Banana为WooCommerce自动生成虚拟AI试穿图像
If
Set
Wait
+7
20 节点Davide
内容创作
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
从WooCommerce产品图片中移除背景
使用API和Google Sheet自动化WooCommerce产品图片背景移除
Ftp
Set
Code
+6
12 节点Davide
设计
工作流信息
难度等级
中级
节点数量12
分类1
节点类型7
作者
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 查看 →
分享此工作流