8
n8n 中文网amn8n.com

ELV 查找通用电子邮件（用于共享）

中级

这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 12 个节点。主要使用 Merge, HttpRequest, GoogleSheets, ManualTrigger 等节点。 使用 EmailListVerify 和 Google Sheets 跨多个域名验证通用商务邮箱

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

使用的节点 (12)

Merge
StickyNote
HttpRequest
GoogleSheets
ManualTrigger

分类

内容创作
多模态 AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "deeMAaUKlXBrqaiS",
  "meta": {
    "instanceId": "42f06bdbe33c6e48441258a73a5cbec4a66a97aff3a765b2ca73c67ed394d25f",
    "templateCredsSetupCompleted": true
  },
  "name": "ELV 查找通用电子邮件（用于共享）",
  "tags": [],
  "nodes": [
    {
      "id": "95bbc44c-e484-4185-96fa-7e6e65a34d25",
      "name": "保存结果",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1152,
        -240
      ],
      "parameters": {
        "columns": {
          "value": {
            "Email": "={{ $json.root }}@{{ $json.domain }}",
            "Status": "={{ $json.data }}"
          },
          "schema": [
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1262572795,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1t-sBs3hr3snmNT1i5hykFkmxvuaQjC_r_Nmfly4oN-M/edit#gid=1262572795",
          "cachedResultName": "[OutPut] emails"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw/edit?usp=drivesdk",
          "cachedResultName": "[N8N template] EmailListVerify: generic email finder"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "",
          "name": "Google Sheets"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "210824fa-4c47-4e8a-8a14-cac9c3b27142",
      "name": "获取域名列表",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        192,
        -176
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 2121105756,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw/edit#gid=2121105756",
          "cachedResultName": "[Input] domain"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw/edit?usp=drivesdk",
          "cachedResultName": "[N8N template] EmailListVerify: generic email finder"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "",
          "name": "Google Sheets (Fab)"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "8b5905c5-a09c-4732-b26e-4ca7510d2a23",
      "name": "获取电子邮件根列表",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        192,
        16
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw/edit#gid=0",
          "cachedResultName": "[Input] partern"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/11JW2e9w00bZO_ORe0FNaK_u5tnchI8ZOwcq8qN1toZw/edit?usp=drivesdk",
          "cachedResultName": "[N8N template] EmailListVerify: generic email finder"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "",
          "name": "Google Sheets (Fab)"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "11e24bac-08a2-4797-825a-954b0a20df25",
      "name": "创建电子邮件候选",
      "type": "n8n-nodes-base.merge",
      "position": [
        464,
        -80
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineAll"
      },
      "typeVersion": 3.2
    },
    {
      "id": "5c80b5ee-6d35-41b0-865b-3b73d99f0b90",
      "name": "使用 EmailListVerify API 检查电子邮件是否有效",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        720,
        -80
      ],
      "parameters": {
        "url": "https://api.emaillistverify.com/api/verifyEmail",
        "options": {},
        "sendQuery": true,
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "queryParameters": {
          "parameters": [
            {
              "name": "email",
              "value": "={{ $json.root }}@{{ $json.domain }}"
            }
          ]
        }
      },
      "credentials": {
        "httpQueryAuth": {
          "id": "Add your EmailListVerify API key here",
          "name": "Query Auth account 2"
        },
        "httpHeaderAuth": {
          "id": "Add your EmailListVerify API key here",
          "name": "Header Auth account 2"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "d86dba88-75b0-4911-a790-eb07accc9b7f",
      "name": "合并结果",
      "type": "n8n-nodes-base.merge",
      "position": [
        992,
        -240
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineByPosition"
      },
      "typeVersion": 3.2
    },
    {
      "id": "8f71141f-9bc9-4c88-af0c-e5886d426c2a",
      "name": "当点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -112,
        48
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "49de2a94-1444-447f-abca-a96d86c20d8c",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        128,
        -384
      ],
      "parameters": {
        "height": 624,
        "content": "## 获取输入"
      },
      "typeVersion": 1
    },
    {
      "id": "4edb37d7-3f5e-4f38-839f-d3517acfd10e",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        -384
      ],
      "parameters": {
        "height": 624,
        "content": "## 生成电子邮件候选"
      },
      "typeVersion": 1
    },
    {
      "id": "35bd07e5-ad0c-4a26-8b95-9ae3dabc716d",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        656,
        -384
      ],
      "parameters": {
        "height": 624,
        "content": "## 检查电子邮件是否有效"
      },
      "typeVersion": 1
    },
    {
      "id": "a2ed1db7-d036-4d00-b576-4e4dbf8a0908",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        928,
        -384
      ],
      "parameters": {
        "width": 352,
        "height": 624,
        "content": "## 保存结果"
      },
      "typeVersion": 1
    },
    {
      "id": "d9f2ae53-e467-470c-9991-58985d7780c3",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -176,
        -624
      ],
      "parameters": {
        "color": 3,
        "height": 592,
        "content": "## 自述文件"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "180b9911-ff6f-4a42-8a50-5c7bc37210a7",
  "connections": {
    "Combine results": {
      "main": [
        [
          {
            "node": "Save results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get list of domain": {
      "main": [
        [
          {
            "node": "Create email candidates",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get list of email root": {
      "main": [
        [
          {
            "node": "Create email candidates",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Create email candidates": {
      "main": [
        [
          {
            "node": "Use EmailListVerify API to check if email is valid",
            "type": "main",
            "index": 0
          },
          {
            "node": "Combine results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get list of domain",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get list of email root",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Use EmailListVerify API to check if email is valid": {
      "main": [
        [
          {
            "node": "Combine results",
            "type": "main",
            "index": 1
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 内容创作, 多模态 AI

需要付费吗？

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

相关工作流推荐

ELV网站邮箱提取
使用EmailListVerify API从网站提取邮箱地址并存储到Google Sheets
If
Set
Code
+6
20 节点EmailListVerify
潜在客户开发
模板HP - 内容排期
使用GPT-4、Apify和Google Sheets自动生成Instagram内容排期
Set
Code
Wait
+9
24 节点keisha kalra
内容创作
对比页面工作流
使用OpenAI和Google Sheets自动生成产品对比页面
Code
Merge
Http Request
+6
50 节点Abrar Sami
内容创作
内容聚合
使用Gemini AI从网站文章自动化社交媒体帖子发布到LinkedIn和X/Twitter
If
Set
Xml
+16
34 节点Vadim
内容创作
使用 OpenAI、ElevenLabs 和 Fal.ai 自动化病毒式内容创作，适用于视频、播客和 ASMR
使用 OpenAI、ElevenLabs 和 Fal.ai 自动化病毒式内容创作，适用于视频、播客和 ASMR
Set
Code
Wait
+16
97 节点Adam Crafts
内容创作
使用OpenAI、ElevenLabs和Hedra创建病毒式婴儿播客YouTube短视频
使用OpenAI、ElevenLabs和Hedra创建病毒式婴儿播客YouTube短视频
Code
Wait
Merge
+12
38 节点Electrabot
内容创作
工作流信息
难度等级
中级
节点数量12
分类2
节点类型5
难度说明

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

作者
EmailListVerify

EmailListVerify

@emaillistverify

Full-Featured Email Verification for half the price

外部链接
在 n8n.io 查看 →

分享此工作流