Système automatisé de recherche et d'interaction avec les candidats passifs utilisant Hunter.io et Google Sheets

Avancé

Ceci est unHR, AI Summarizationworkflow d'automatisation du domainecontenant 21 nœuds.Utilise principalement des nœuds comme If, Code, Wait, Gmail, HttpRequest. Automatiser la recherche et l'interaction avec les candidats passifs via Hunter.io, un score d'IA et Gmail

Prérequis
  • Compte Google et informations d'identification Gmail API
  • Peut nécessiter les informations d'identification d'authentification de l'API cible
  • Informations d'identification Google Sheets API
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "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": "Lors du clic sur 'Exécuter le workflow'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        0,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "ee85cc2c-48d5-4f66-8530-6941c8eddd51",
      "name": "Générer une requête de recherche",
      "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": "Filtrer les candidats :",
      "type": "n8n-nodes-base.code",
      "position": [
        624,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "9e84513d-ce08-4a30-a0d3-47b9c8a0b4b0",
      "name": "Enregistrer les candidats potentiels",
      "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": "Analyse de CV par IA",
      "type": "n8n-nodes-base.code",
      "position": [
        1040,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "95560fc5-f587-4a57-a094-a48695eff107",
      "name": "Calculer le score du candidat",
      "type": "n8n-nodes-base.code",
      "position": [
        1248,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "42ff4be5-ca37-4513-968f-470418f1a8be",
      "name": "Le score est-il > 75 ?",
      "type": "n8n-nodes-base.if",
      "position": [
        1456,
        0
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "52a872f0-7fdb-4b7e-afef-dcd777a53688",
      "name": "Note autocollante",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        -96
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d8112584-fde6-4a5d-917a-63c2882d21db",
      "name": "Envoyer l'e-mail de prise de contact initial",
      "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": "Mettre à jour le statut 'Contacté'",
      "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": "Attendre",
      "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": "Pas de réponse ?",
      "type": "n8n-nodes-base.if",
      "position": [
        624,
        320
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "dc1e39ae-2f34-4b2a-9723-f7bd1f801050",
      "name": "Envoyer l'e-mail de relance",
      "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": "Mettre à jour le statut 'Relancé'",
      "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 jours",
      "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": "Toujours pas de réponse ?",
      "type": "n8n-nodes-base.if",
      "position": [
        1424,
        320
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "cf242598-569c-4505-8429-2a8467be5e10",
      "name": "Envoyer l'e-mail de nurturing final",
      "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": "Mettre à jour le statut 'Nurturé'",
      "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": "Note autocollante 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ad178227-bc3e-41b8-958c-d719421e84fd",
      "name": "Note autocollante 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
          }
        ]
      ]
    }
  }
}
Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Avancé - Ressources Humaines, Résumé IA

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.

Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds21
Catégorie2
Types de nœuds8
Description de la difficulté

Adapté aux utilisateurs avancés, avec des workflows complexes contenant 16+ nœuds

Auteur
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.

Liens externes
Voir sur n8n.io

Partager ce workflow

Catégories

Catégories: 34