8
n8n 中文网amn8n.com

使用Hunter.io和Google Sheets的自动化被动候选人搜寻与互动系统

高级

这是一个HR, AI Summarization领域的自动化工作流,包含 21 个节点。主要使用 If, Code, Wait, Gmail, HttpRequest 等节点。 通过Hunter.io、AI评分和Gmail自动化被动候选人搜寻与互动

前置要求
  • Google 账号和 Gmail API 凭证
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "hJ3OmlB0o6jHcpgZ",
  "meta": {
    "instanceId": "a287613f1596da776459594685fbf4e2b4a12124f80ab8c8772f5e37bff103ae",
    "templateCredsSetupCompleted": true
  },
  "name": "Automated Passive Candidate Sourcing & Engagement System with Hunter.io & Google Sheet",
  "tags": [],
  "nodes": [
    {
      "id": "753cd4fd-a647-45f5-9af9-f0e98fac4884",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "ee85cc2c-48d5-4f66-8530-6941c8eddd51",
      "name": "Generate Search Query",
      "type": "n8n-nodes-base.code",
      "position": [
        208,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "1354a9b7-0dee-4bd7-9b56-db2f801ba1cb",
      "name": "Hunter.io",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        416,
        0
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "ecdc31ae-260e-4c70-b5dc-e94ec23f5364",
      "name": "Filter Candidates:",
      "type": "n8n-nodes-base.code",
      "position": [
        624,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "9e84513d-ce08-4a30-a0d3-47b9c8a0b4b0",
      "name": "Log Potential Candidates",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Fields: name={{ $json.full_name }}, \nemail={{ $json.email }}, status=Potential",
      "position": [
        832,
        0
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 4.6
    },
    {
      "id": "df21181d-f8a3-4d32-90b8-f5b52d138e17",
      "name": "AI Resume Analysis",
      "type": "n8n-nodes-base.code",
      "position": [
        1040,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "95560fc5-f587-4a57-a094-a48695eff107",
      "name": "Calculate Candidate Score",
      "type": "n8n-nodes-base.code",
      "position": [
        1248,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "42ff4be5-ca37-4513-968f-470418f1a8be",
      "name": "Is Score > 75?",
      "type": "n8n-nodes-base.if",
      "position": [
        1456,
        0
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "52a872f0-7fdb-4b7e-afef-dcd777a53688",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        -96
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d8112584-fde6-4a5d-917a-63c2882d21db",
      "name": "Send Initial Outreach Email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        0,
        320
      ],
      "webhookId": "8a026259-6b32-476e-a3c9-36c15a278324",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "2c4c6435-d42b-4596-ae40-305a7f4c307b",
      "name": "Update Status 'Contacted'",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Fields: Status=Contacted, Contacted On={{ $now }}",
      "position": [
        208,
        320
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 4.6
    },
    {
      "id": "7aa47a6e-3171-424c-8b8f-064b19958bb8",
      "name": "Wait",
      "type": "n8n-nodes-base.wait",
      "position": [
        416,
        320
      ],
      "webhookId": "bed2f062-c8a6-4400-993b-2be136f779a9",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "4d0a9308-e24a-4929-a3f9-7e16f1d1f3d8",
      "name": "No Reply?",
      "type": "n8n-nodes-base.if",
      "position": [
        624,
        320
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "dc1e39ae-2f34-4b2a-9723-f7bd1f801050",
      "name": "Send Follow-up Email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        848,
        320
      ],
      "webhookId": "1556dfa7-6954-42e6-bef5-3038346715e2",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "4be1a313-f73b-411d-ab21-2892fab9b1de",
      "name": "Update Status 'Followed Up'",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Fields: Status=Followed Up",
      "position": [
        1056,
        320
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 4.6
    },
    {
      "id": "d66946fe-5cb8-4392-8fb1-1a3cc5c9f262",
      "name": "5 Days",
      "type": "n8n-nodes-base.wait",
      "position": [
        1264,
        320
      ],
      "webhookId": "ccb5a5c1-2e57-4e04-aada-13b9075c0db7",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "84cdd188-181b-429e-a6f4-03b1aec93ba2",
      "name": "Still No Reply?",
      "type": "n8n-nodes-base.if",
      "position": [
        1424,
        320
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "cf242598-569c-4505-8429-2a8467be5e10",
      "name": "Send Final Nurture Email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1664,
        320
      ],
      "webhookId": "b1fb16ec-f252-4b23-b6be-0d1d868ce5e5",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "13b4948d-0368-4896-89aa-6555d448bb93",
      "name": "Update Status 'Nurtured'",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Fields: Status=Nurtured",
      "position": [
        1904,
        320
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 4.6
    },
    {
      "id": "23e62c9a-1937-4ba3-91cc-f27e63c3e482",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ad178227-bc3e-41b8-958c-d719421e84fd",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1024,
        -96
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "44c85110-3847-409f-a48d-62686f566094",
  "connections": {
    "7aa47a6e-3171-424c-8b8f-064b19958bb8": {
      "main": [
        [
          {
            "node": "4d0a9308-e24a-4929-a3f9-7e16f1d1f3d8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d66946fe-5cb8-4392-8fb1-1a3cc5c9f262": {
      "main": [
        [
          {
            "node": "84cdd188-181b-429e-a6f4-03b1aec93ba2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1354a9b7-0dee-4bd7-9b56-db2f801ba1cb": {
      "main": [
        [
          {
            "node": "ecdc31ae-260e-4c70-b5dc-e94ec23f5364",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4d0a9308-e24a-4929-a3f9-7e16f1d1f3d8": {
      "main": [
        [
          {
            "node": "dc1e39ae-2f34-4b2a-9723-f7bd1f801050",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "42ff4be5-ca37-4513-968f-470418f1a8be": {
      "main": [
        [
          {
            "node": "d8112584-fde6-4a5d-917a-63c2882d21db",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "84cdd188-181b-429e-a6f4-03b1aec93ba2": {
      "main": [
        [
          {
            "node": "cf242598-569c-4505-8429-2a8467be5e10",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "df21181d-f8a3-4d32-90b8-f5b52d138e17": {
      "main": [
        [
          {
            "node": "95560fc5-f587-4a57-a094-a48695eff107",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ecdc31ae-260e-4c70-b5dc-e94ec23f5364": {
      "main": [
        [
          {
            "node": "9e84513d-ce08-4a30-a0d3-47b9c8a0b4b0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "dc1e39ae-2f34-4b2a-9723-f7bd1f801050": {
      "main": [
        [
          {
            "node": "4be1a313-f73b-411d-ab21-2892fab9b1de",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ee85cc2c-48d5-4f66-8530-6941c8eddd51": {
      "main": [
        [
          {
            "node": "1354a9b7-0dee-4bd7-9b56-db2f801ba1cb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9e84513d-ce08-4a30-a0d3-47b9c8a0b4b0": {
      "main": [
        [
          {
            "node": "df21181d-f8a3-4d32-90b8-f5b52d138e17",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cf242598-569c-4505-8429-2a8467be5e10": {
      "main": [
        [
          {
            "node": "13b4948d-0368-4896-89aa-6555d448bb93",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "95560fc5-f587-4a57-a094-a48695eff107": {
      "main": [
        [
          {
            "node": "42ff4be5-ca37-4513-968f-470418f1a8be",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2c4c6435-d42b-4596-ae40-305a7f4c307b": {
      "main": [
        [
          {
            "node": "7aa47a6e-3171-424c-8b8f-064b19958bb8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d8112584-fde6-4a5d-917a-63c2882d21db": {
      "main": [
        [
          {
            "node": "2c4c6435-d42b-4596-ae40-305a7f4c307b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4be1a313-f73b-411d-ab21-2892fab9b1de": {
      "main": [
        [
          {
            "node": "d66946fe-5cb8-4392-8fb1-1a3cc5c9f262",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "753cd4fd-a647-45f5-9af9-f0e98fac4884": {
      "main": [
        [
          {
            "node": "ee85cc2c-48d5-4f66-8530-6941c8eddd51",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级 - 人力资源, AI 摘要总结

需要付费吗?

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

工作流信息
难度等级
高级
节点数量21
分类2
节点类型8
难度说明

适合高级用户,包含 16+ 个节点的复杂工作流

作者
Marth

Marth

@marth

Simplifying Business with Smart Automation. I create and share user-friendly, highly efficient n8n workflow templates for SMEs, focusing on digital marketing, sales, and operational excellence. Get ready to automate, innovate, and elevate your business. Connect me on Linkedin for custom solutions.

外部链接
在 n8n.io 查看

分享此工作流

分类

分类: 34