Pipeline automatisé de qualification de prospects LinkedIn avec Apollo.io et Google Sheets
Avancé
Ceci est unLead Generation, AI Summarizationworkflow d'automatisation du domainecontenant 33 nœuds.Utilise principalement des nœuds comme If, Code, Wait, Webhook, SplitOut. Pipeline d'enrichissement automatique de prospects LinkedIn avec Apollo.io et Google Sheets
Prérequis
- •Point de terminaison HTTP Webhook (généré automatiquement par n8n)
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Informations d'identification Google Sheets API
- •Clé API Google Gemini
Nœuds utilisés (33)
Catégorie
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
{
"meta": {
"instanceId": "67dd1445921862780ac74448aef33eb969db12b9a6ce95248c7ae86a887cb653",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "ee7ba99a-a412-4389-af47-e12a8070a9a1",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
2032,
1296
],
"webhookId": "4584ccbb-4256-4da7-a8df-bee1f3b27084",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "d913c122-3f4a-4fa3-aab3-79c6319ac12e",
"name": "Diviser",
"type": "n8n-nodes-base.splitOut",
"position": [
2240,
1296
],
"parameters": {},
"typeVersion": 1
},
{
"id": "41a6dc80-fe9e-4cde-b47b-b03ae98feb7f",
"name": "Analyseur de Sortie Structurée",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2832,
1504
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "0bda86e3-84ab-4b9f-9c74-b871a658bdc6",
"name": "Google Gemini Modèle de Chat",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
2512,
1504
],
"parameters": {},
"typeVersion": 1
},
{
"id": "65af8ed4-cec3-4937-963e-4623473f5b57",
"name": "Boucle sur les Éléments",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2448,
1296
],
"parameters": {},
"typeVersion": 3
},
{
"id": "54c6c70e-59f6-4320-9d6a-5bdd94e8e6ed",
"name": "Obtenir la/les ligne(s) dans la feuille",
"type": "n8n-nodes-base.googleSheets",
"position": [
2224,
2016
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "ea21290c-588d-443b-b401-d7329063e9bb",
"name": "Déclencheur Planifié",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
2048,
2016
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "748e2b43-e51a-417d-92ff-df0704cef2a9",
"name": "Boucle sur les Éléments1",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
2720,
2016
],
"parameters": {},
"typeVersion": 3
},
{
"id": "2e9a8548-a8bf-47e3-8fe1-93072276cd9d",
"name": "Mettre à jour la ligne dans la feuille",
"type": "n8n-nodes-base.googleSheets",
"position": [
3440,
2032
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "ed8a4414-e31d-46d7-9ad6-836faee1a3ac",
"name": "Déclencheur Planifié1",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
2064,
2672
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "6951d857-278a-4633-be22-f06937dacb98",
"name": "Boucle sur les Éléments2",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
2752,
2656
],
"parameters": {},
"typeVersion": 3
},
{
"id": "bb781af1-7246-4bf7-9f77-1f7eb17637ef",
"name": "Pause",
"type": "n8n-nodes-base.wait",
"position": [
3648,
2032
],
"webhookId": "e5a3db76-aa67-42c7-8ad1-e916509b7c13",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "5127d065-bc43-454c-bc64-02402c23143a",
"name": "Pause1",
"type": "n8n-nodes-base.wait",
"position": [
3440,
2656
],
"webhookId": "69d23d48-e9fd-4f7d-bc70-fa2400658e62",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "65efcc77-b567-4fff-a2e8-31b8e0e29f4e",
"name": "Obtenir la/les ligne(s) dans la feuille1",
"type": "n8n-nodes-base.googleSheets",
"position": [
2288,
2672
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "71fb0b9d-d8b2-490b-8a55-a515c56fe10e",
"name": "Mettre à jour la ligne dans la feuille1",
"type": "n8n-nodes-base.googleSheets",
"position": [
3648,
2656
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "5a81a696-1155-4fbb-966c-82baec8219fe",
"name": "Si",
"type": "n8n-nodes-base.if",
"position": [
2496,
2672
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "72c8bccf-37b1-4dc5-9fbd-19fe72b7c1ca",
"name": "Si1",
"type": "n8n-nodes-base.if",
"position": [
2432,
2032
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "bfa61ebd-bdf8-4356-8807-579ea74a06cd",
"name": "Déclencheur Planifié2",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
2064,
3136
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "a3dfff36-07c3-49c6-b7fb-718638854507",
"name": "Pause2",
"type": "n8n-nodes-base.wait",
"position": [
3712,
3120
],
"webhookId": "69d23d48-e9fd-4f7d-bc70-fa2400658e62",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "59e93cf6-cf15-4a92-b344-bac485607e07",
"name": "Mettre à jour la ligne dans la feuille2",
"type": "n8n-nodes-base.googleSheets",
"onError": "continueErrorOutput",
"position": [
3920,
3120
],
"parameters": {},
"typeVersion": 4.7,
"alwaysOutputData": false
},
{
"id": "098cf0b1-6c13-428a-aedf-53f5a4ace309",
"name": "Si2",
"type": "n8n-nodes-base.if",
"position": [
2464,
3136
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "69cc889b-3692-412b-9265-8b6ed4df7a49",
"name": "Code",
"type": "n8n-nodes-base.code",
"onError": "continueErrorOutput",
"position": [
2928,
3120
],
"parameters": {},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "37e8ea98-60d5-413e-922d-e5fed98e96ef",
"name": "Note Adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
1776,
2528
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1ab50ec4-c5f0-4888-8f2c-0b16c518e6ea",
"name": "Note Adhésive1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1792,
1856
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9bb1bf69-b5f4-4471-a98e-e4728062391c",
"name": "Note Adhésive2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1808,
3072
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1b2d40a7-ceef-4b15-9ffd-a9ab4ebce29d",
"name": "Code1",
"type": "n8n-nodes-base.code",
"position": [
3456,
3120
],
"parameters": {},
"typeVersion": 2
},
{
"id": "3fdb7f62-3fad-4067-b6c8-d2e07984370f",
"name": "Boucle sur les Éléments4",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
2704,
3088
],
"parameters": {},
"typeVersion": 3,
"alwaysOutputData": true
},
{
"id": "abf7cc40-ea8a-4c1d-abb5-31f8d4e5a723",
"name": "Obtenir la/les ligne(s) dans la feuille3",
"type": "n8n-nodes-base.googleSheets",
"position": [
2288,
3136
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "d83f2237-6fe7-4eb4-b2d7-deba7c26e54e",
"name": "Linkedin Formateur de Données Récupérées",
"type": "@n8n/n8n-nodes-langchain.agent",
"onError": "continueErrorOutput",
"position": [
2656,
1296
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "3f428a31-7eb0-4e78-b574-bf0b968b652e",
"name": "Stocker les valeurs",
"type": "n8n-nodes-base.googleSheets",
"position": [
3008,
1296
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "a3e862b8-9f95-46ad-be2d-a7b06f15a1f0",
"name": "Nom d'Entreprise vers Domaine",
"type": "n8n-nodes-base.httpRequest",
"position": [
3232,
2032
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "835de11e-aa6d-4e4e-9f2d-7e008155d1db",
"name": "Recherche de Personnes",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
3024,
2656
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "bfed2a87-6446-4484-aad5-56f4ee3a566e",
"name": "Outil de Recherche d'Email",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
3184,
3120
],
"parameters": {},
"typeVersion": 4.2
}
],
"pinData": {},
"connections": {
"5a81a696-1155-4fbb-966c-82baec8219fe": {
"main": [
[
{
"node": "6951d857-278a-4633-be22-f06937dacb98",
"type": "main",
"index": 0
}
]
]
},
"72c8bccf-37b1-4dc5-9fbd-19fe72b7c1ca": {
"main": [
[
{
"node": "748e2b43-e51a-417d-92ff-df0704cef2a9",
"type": "main",
"index": 0
}
]
]
},
"098cf0b1-6c13-428a-aedf-53f5a4ace309": {
"main": [
[
{
"node": "3fdb7f62-3fad-4067-b6c8-d2e07984370f",
"type": "main",
"index": 0
}
]
]
},
"69cc889b-3692-412b-9265-8b6ed4df7a49": {
"main": [
[
{
"node": "bfed2a87-6446-4484-aad5-56f4ee3a566e",
"type": "main",
"index": 0
}
]
]
},
"bb781af1-7246-4bf7-9f77-1f7eb17637ef": {
"main": [
[
{
"node": "748e2b43-e51a-417d-92ff-df0704cef2a9",
"type": "main",
"index": 0
}
]
]
},
"1b2d40a7-ceef-4b15-9ffd-a9ab4ebce29d": {
"main": [
[
{
"node": "a3dfff36-07c3-49c6-b7fb-718638854507",
"type": "main",
"index": 0
}
]
]
},
"5127d065-bc43-454c-bc64-02402c23143a": {
"main": [
[
{
"node": "71fb0b9d-d8b2-490b-8a55-a515c56fe10e",
"type": "main",
"index": 0
}
]
]
},
"a3dfff36-07c3-49c6-b7fb-718638854507": {
"main": [
[
{
"node": "59e93cf6-cf15-4a92-b344-bac485607e07",
"type": "main",
"index": 0
}
]
]
},
"ee7ba99a-a412-4389-af47-e12a8070a9a1": {
"main": [
[
{
"node": "d913c122-3f4a-4fa3-aab3-79c6319ac12e",
"type": "main",
"index": 0
}
]
]
},
"d913c122-3f4a-4fa3-aab3-79c6319ac12e": {
"main": [
[
{
"node": "65af8ed4-cec3-4937-963e-4623473f5b57",
"type": "main",
"index": 0
}
]
]
},
"bfed2a87-6446-4484-aad5-56f4ee3a566e": {
"main": [
[
{
"node": "1b2d40a7-ceef-4b15-9ffd-a9ab4ebce29d",
"type": "main",
"index": 0
}
]
]
},
"3f428a31-7eb0-4e78-b574-bf0b968b652e": {
"main": [
[
{
"node": "65af8ed4-cec3-4937-963e-4623473f5b57",
"type": "main",
"index": 0
}
]
]
},
"835de11e-aa6d-4e4e-9f2d-7e008155d1db": {
"main": [
[
{
"node": "5127d065-bc43-454c-bc64-02402c23143a",
"type": "main",
"index": 0
}
]
]
},
"65af8ed4-cec3-4937-963e-4623473f5b57": {
"main": [
[],
[
{
"node": "d83f2237-6fe7-4eb4-b2d7-deba7c26e54e",
"type": "main",
"index": 0
}
]
]
},
"748e2b43-e51a-417d-92ff-df0704cef2a9": {
"main": [
[],
[
{
"node": "a3e862b8-9f95-46ad-be2d-a7b06f15a1f0",
"type": "main",
"index": 0
}
]
]
},
"6951d857-278a-4633-be22-f06937dacb98": {
"main": [
[],
[
{
"node": "835de11e-aa6d-4e4e-9f2d-7e008155d1db",
"type": "main",
"index": 0
}
]
]
},
"3fdb7f62-3fad-4067-b6c8-d2e07984370f": {
"main": [
[],
[
{
"node": "69cc889b-3692-412b-9265-8b6ed4df7a49",
"type": "main",
"index": 0
}
]
]
},
"ea21290c-588d-443b-b401-d7329063e9bb": {
"main": [
[
{
"node": "54c6c70e-59f6-4320-9d6a-5bdd94e8e6ed",
"type": "main",
"index": 0
}
]
]
},
"ed8a4414-e31d-46d7-9ad6-836faee1a3ac": {
"main": [
[
{
"node": "65efcc77-b567-4fff-a2e8-31b8e0e29f4e",
"type": "main",
"index": 0
}
]
]
},
"bfa61ebd-bdf8-4356-8807-579ea74a06cd": {
"main": [
[
{
"node": "abf7cc40-ea8a-4c1d-abb5-31f8d4e5a723",
"type": "main",
"index": 0
}
]
]
},
"54c6c70e-59f6-4320-9d6a-5bdd94e8e6ed": {
"main": [
[
{
"node": "72c8bccf-37b1-4dc5-9fbd-19fe72b7c1ca",
"type": "main",
"index": 0
}
]
]
},
"2e9a8548-a8bf-47e3-8fe1-93072276cd9d": {
"main": [
[
{
"node": "bb781af1-7246-4bf7-9f77-1f7eb17637ef",
"type": "main",
"index": 0
}
]
]
},
"65efcc77-b567-4fff-a2e8-31b8e0e29f4e": {
"main": [
[
{
"node": "5a81a696-1155-4fbb-966c-82baec8219fe",
"type": "main",
"index": 0
}
]
]
},
"abf7cc40-ea8a-4c1d-abb5-31f8d4e5a723": {
"main": [
[
{
"node": "098cf0b1-6c13-428a-aedf-53f5a4ace309",
"type": "main",
"index": 0
}
]
]
},
"71fb0b9d-d8b2-490b-8a55-a515c56fe10e": {
"main": [
[
{
"node": "6951d857-278a-4633-be22-f06937dacb98",
"type": "main",
"index": 0
}
]
]
},
"59e93cf6-cf15-4a92-b344-bac485607e07": {
"main": [
[
{
"node": "3fdb7f62-3fad-4067-b6c8-d2e07984370f",
"type": "main",
"index": 0
}
]
]
},
"a3e862b8-9f95-46ad-be2d-a7b06f15a1f0": {
"main": [
[
{
"node": "2e9a8548-a8bf-47e3-8fe1-93072276cd9d",
"type": "main",
"index": 0
}
]
]
},
"0bda86e3-84ab-4b9f-9c74-b871a658bdc6": {
"ai_languageModel": [
[
{
"node": "d83f2237-6fe7-4eb4-b2d7-deba7c26e54e",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"41a6dc80-fe9e-4cde-b47b-b03ae98feb7f": {
"ai_outputParser": [
[
{
"node": "d83f2237-6fe7-4eb4-b2d7-deba7c26e54e",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"d83f2237-6fe7-4eb4-b2d7-deba7c26e54e": {
"main": [
[
{
"node": "3f428a31-7eb0-4e78-b574-bf0b968b652e",
"type": "main",
"index": 0
}
],
[
{
"node": "3f428a31-7eb0-4e78-b574-bf0b968b652e",
"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é - Génération de leads, 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.
Workflows recommandés
Analyse intelligente quotidienne des groupes WhatsApp : Analyse GPT-4.1 et transcription des messages vocaux
Analyse intelligente des groupes WhatsApp quotidiens : analyse GPT-4.1 et transcription des messages vocaux
If
Set
Code
+
If
Set
Code
52 NœudsDaniel Lianes
Divers
Prospection et workflow d'e-mails
Utiliser Google Maps, SendGrid et l'IA pour automatiser le développement de prospects B2B et le marketing par e-mail
If
Set
Code
+
If
Set
Code
141 NœudsEzema Kingsley Chibuzo
Génération de leads
Explorer les nœuds n8n dans la bibliothèque de références visuelles
Explorer les nœuds n8n dans la base de références visuelles
If
Ftp
Set
+
If
Ftp
Set
113 NœudsI versus AI
Autres
AI驱动de谷歌地图商家données抓取与表格exportation
基于AIde谷歌地图商家données抓取，支持données丰富化并exportation至表格
If
Code
Wait
+
If
Code
Wait
25 NœudsMsaid Mohamed el hadi
Génération de leads
Petite boutique 4
🐶 Agent IA pour les réservations de magasins de pets
If
Set
Code
+
If
Set
Code
187 NœudsBruno Dias
Intelligence Artificielle
第一轮 Telegram et LinkedIn 快速通道 AI 招聘assistant
AI候选人筛选流程：LinkedInàTelegram，intégrationGemini与Apify
If
Set
Code
+
If
Set
Code
55 NœudsDean Pike
Ressources Humaines
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds33
Catégorie2
Types de nœuds13
Description de la difficulté
Auteur
Rahi Uppal
@rahiuppalAI and Automation Consultant with over 1000 hours of experience building, deploying, and solving marketing and sales automation problems. I ship AI products faster by combining business acumen with AI & automation expertise and an engineering mindset. Connect with me on LinkedIn to chat.
Liens externes
Voir sur n8n.io →
Partager ce workflow