8
n8n 中文网amn8n.com

使用Google表格、Hunter.io和EmailValidation.io

中级

这是一个Lead Generation, Miscellaneous, Multimodal AI领域的自动化工作流，包含 8 个节点。主要使用 Set, Filter, Hunter, HttpRequest, GoogleSheets 等节点。 使用Google表格、Hunter.io和EmailValidation.io的自动邮件验证

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

使用的节点 (8)

Set
Filter
Hunter
StickyNote
HttpRequest
GoogleSheets
GoogleSheetsTrigger

分类

潜在客户开发
杂项
多模态 AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "meta": {
    "instanceId": "3dd7d3035157a6c8c0bc0904aa8991f90872849a76d57fd6b5eedb4e09f76c2f"
  },
  "nodes": [
    {
      "id": "6a06b03c-27d8-4256-8f54-ac614fec00b2",
      "name": "Google Sheets Trigger",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -544,
        96
      ],
      "parameters": {
        "event": "rowAdded",
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/14tsPplI_HG0K1IuRjFNsAIxqewmFrxfb10JRy15Urg4/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "14tsPplI_HG0K1IuRjFNsAIxqewmFrxfb10JRy15Urg4",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/14tsPplI_HG0K1IuRjFNsAIxqewmFrxfb10JRy15Urg4/edit?usp=drivesdk",
          "cachedResultName": "Email Validation"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "bd24d486-ff8a-483f-9123-8158e47f2c36",
      "name": "Email Validation API",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        96,
        96
      ],
      "parameters": {
        "url": "=https://api.emailvalidation.io/v1/info?apikey={{api_key}}&email={{ $json.Email }}",
        "options": {},
        "sendBody": true,
        "sendHeaders": true,
        "bodyParameters": {
          "parameters": [
            {}
          ]
        },
        "headerParameters": {
          "parameters": [
            {}
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "1296f145-1589-4df5-a648-8d24266adb9a",
      "name": "Filter Empty Cells",
      "type": "n8n-nodes-base.filter",
      "position": [
        -320,
        96
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "55afbbbe-0c07-412d-aae3-eceb061d1b92",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json.Email }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "d8cb2bf4-babb-4a80-a051-35cc37ac7479",
      "name": "Take Email Only",
      "type": "n8n-nodes-base.set",
      "position": [
        -112,
        96
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "26020ce1-c307-4c9d-9c47-f66efda1b57e",
              "name": "Email",
              "type": "string",
              "value": "={{ $json.Email }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "95f7fc3a-32c1-4dff-85f7-e9d36a2808fe",
      "name": "Take Email and Validation Status",
      "type": "n8n-nodes-base.set",
      "position": [
        272,
        96
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "ba35033d-05fc-4b05-9a08-c55662f956c3",
              "name": "status",
              "type": "string",
              "value": "={{ $json.state }}"
            },
            {
              "id": "abab1589-c81b-4d1f-80c5-83dc156a45e0",
              "name": "email",
              "type": "string",
              "value": "={{ $json.email }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "6feaf204-bdc8-48f8-a427-8a16afd63688",
      "name": "Update the Sheets with Validation Status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        464,
        96
      ],
      "parameters": {
        "columns": {
          "value": {
            "Email": "={{ $json.email }}",
            "Deliverability ": "={{ $json.status }}"
          },
          "schema": [
            {
              "id": "Name ",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Name ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Deliverability ",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Deliverability ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Linkedin URL",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Linkedin URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company ",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Company ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Email"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/14tsPplI_HG0K1IuRjFNsAIxqewmFrxfb10JRy15Urg4/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "14tsPplI_HG0K1IuRjFNsAIxqewmFrxfb10JRy15Urg4",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/14tsPplI_HG0K1IuRjFNsAIxqewmFrxfb10JRy15Urg4/edit?usp=drivesdk",
          "cachedResultName": "Email Validation"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "buZ3kxvSme2Z38GJ",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "40b08848-691d-4082-ad80-cf2d2d45c39e",
      "name": "Alternative - Hunter for Email Validation",
      "type": "n8n-nodes-base.hunter",
      "position": [
        96,
        -80
      ],
      "parameters": {
        "email": "={{ $json.Email }}",
        "operation": "emailVerifier"
      },
      "typeVersion": 1
    },
    {
      "id": "43b4b741-3db0-48c6-b99b-8f1bf6b5d76b",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -672,
        -176
      ],
      "parameters": {
        "width": 1456,
        "height": 464,
        "content": "## Instructions\n1. Take email and other data from the google sheets. \n2. If new row added the trigger will trigger the workflow automatically\n3. Setup Sheets credentails \n4. Setup Email Validation or Hunter Credentials \n5. Tadah! You are all good."
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "d8cb2bf4-babb-4a80-a051-35cc37ac7479": {
      "main": [
        [
          {
            "node": "bd24d486-ff8a-483f-9123-8158e47f2c36",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1296f145-1589-4df5-a648-8d24266adb9a": {
      "main": [
        [
          {
            "node": "d8cb2bf4-babb-4a80-a051-35cc37ac7479",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bd24d486-ff8a-483f-9123-8158e47f2c36": {
      "main": [
        [
          {
            "node": "95f7fc3a-32c1-4dff-85f7-e9d36a2808fe",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6a06b03c-27d8-4256-8f54-ac614fec00b2": {
      "main": [
        [
          {
            "node": "1296f145-1589-4df5-a648-8d24266adb9a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "95f7fc3a-32c1-4dff-85f7-e9d36a2808fe": {
      "main": [
        [
          {
            "node": "6feaf204-bdc8-48f8-a427-8a16afd63688",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 潜在客户开发, 杂项, 多模态 AI

需要付费吗？

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

相关工作流推荐

Google Maps线索抓取与AI驱动个性化触达丰富
Google Maps线索抓取与AI驱动个性化触达丰富
Set
Code
Filter
+
Set
Code
Filter
24 节点A Z
潜在客户开发
基于AI的潜在客户生成（Apollo、LinkedIn研究和4步个性化邮件）
基于AI的潜在客户生成：使用Apollo、LinkedIn研究和4步个性化邮件
If
Set
Code
+
If
Set
Code
30 节点Gain FLow AI
潜在客户开发
自定义冷邮件破冰内容生成器
通过Apollo线索抓取和GPT-4.1自动化个性化冷邮件
Set
Code
Slack
+
Set
Code
Slack
24 节点Richard Besier
潜在客户开发
使用Gmail、GPT-4和向量知识库的自动化客户支持系统
使用Gmail、GPT-4和向量知识库的自动化客户支持系统
If
Set
Code
+
If
Set
Code
32 节点Khair Ahammed
AI RAG 检索增强
AI潜在客户挖掘智能体
使用Apify、AI和Gmail的自动化潜在客户生成与冷邮件发送
If
Set
Wait
+
If
Set
Wait
20 节点Rakin Jakaria
潜在客户开发
使用GPT-4 Mini、Apify和LinkedIn生成个性化冷邮件开场白
使用GPT-4 Mini、Apify和LinkedIn生成个性化冷邮件开场白
Set
Filter
Aggregate
+
Set
Filter
Aggregate
16 节点Erfan Mostafiz
潜在客户开发
工作流信息
难度等级
中级
节点数量8
分类3
节点类型7
难度说明

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

作者
Khair Ahammed

Khair Ahammed

@khair1212

Automation engineer with over 2 years of experience specializing in building scalable and reliable automation solutions using n8n and other cutting-edge tools. With expertise in workflow optimization, API integrations, and process automation, I help businesses streamline their operations and eliminate repetitive tasks.

外部链接
在 n8n.io 查看 →

分享此工作流

分类

多模态 AI
1540
人工智能
1108
内容创作
695
AI 摘要总结
516
营销
419
AI 聊天机器人
251
工程
241
市场调研
203
杂项
193
其他
176
销售
162
IT 运维
156
文档提取
147
AI RAG 检索增强
146
构建模块
144
社交媒体
137
潜在客户开发
125
个人效率
117
开发运维
111
人力资源
101
客户支持
97
客户培育
87
客户关系管理
82
财务
81
产品
77
客服机器人
76
设计
70
工单管理
67
安全运维
57
发票处理
53
加密货币交易
49
文件管理
39
项目管理
35
内部知识库
32

分类: 34