Hunter.ioとGoogleシートを使用した候補者の自動検出と対話システム

上級

これは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": "ワークフロー実行時",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "ee85cc2c-48d5-4f66-8530-6941c8eddd51",
      "name": "検索クエリ生成",
      "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": "候補者フィルタリング:",
      "type": "n8n-nodes-base.code",
      "position": [
        624,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "9e84513d-ce08-4a30-a0d3-47b9c8a0b4b0",
      "name": "潜在候補者記録",
      "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履歴書分析",
      "type": "n8n-nodes-base.code",
      "position": [
        1040,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "95560fc5-f587-4a57-a094-a48695eff107",
      "name": "候補者スコア算出",
      "type": "n8n-nodes-base.code",
      "position": [
        1248,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "42ff4be5-ca37-4513-968f-470418f1a8be",
      "name": "スコア > 75?",
      "type": "n8n-nodes-base.if",
      "position": [
        1456,
        0
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "52a872f0-7fdb-4b7e-afef-dcd777a53688",
      "name": "付箋",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        -96
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d8112584-fde6-4a5d-917a-63c2882d21db",
      "name": "初回アウトリーチメール送信",
      "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": "ステータス「コンタクト済」に更新",
      "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": "待機",
      "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": "返信なし?",
      "type": "n8n-nodes-base.if",
      "position": [
        624,
        320
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "dc1e39ae-2f34-4b2a-9723-f7bd1f801050",
      "name": "フォローアップメール送信",
      "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": "ステータス「フォローアップ済」に更新",
      "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日間",
      "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": "まだ返信なし?",
      "type": "n8n-nodes-base.if",
      "position": [
        1424,
        320
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "cf242598-569c-4505-8429-2a8467be5e10",
      "name": "最終育成メール送信",
      "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": "ステータス「育成済」に更新",
      "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": "付箋1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ad178227-bc3e-41b8-958c-d719421e84fd",
      "name": "付箋2",
      "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