Pipeline automatizado para enriquecimiento de prospectos de LinkedIn con Apollo.io y Hojas de Cálculo de Google
Este es unLead Generation, AI Summarizationflujo de automatización del dominio deautomatización que contiene 33 nodos.Utiliza principalmente nodos como If, Code, Wait, Webhook, SplitOut. Tubería automatizada para enriquecimiento de leads de LinkedIn usando Apollo.io y Google Sheets
- •Punto final de HTTP Webhook (n8n generará automáticamente)
- •Pueden requerirse credenciales de autenticación para la API de destino
- •Credenciales de API de Google Sheets
- •Clave de API de Google Gemini
Nodos utilizados (33)
Categoría
{
"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": "Dividir",
"type": "n8n-nodes-base.splitOut",
"position": [
2240,
1296
],
"parameters": {},
"typeVersion": 1
},
{
"id": "41a6dc80-fe9e-4cde-b47b-b03ae98feb7f",
"name": "Analizador de Salida Estructurada",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2832,
1504
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "0bda86e3-84ab-4b9f-9c74-b871a658bdc6",
"name": "Google Gemini Modelo de Chat",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
2512,
1504
],
"parameters": {},
"typeVersion": 1
},
{
"id": "65af8ed4-cec3-4937-963e-4623473f5b57",
"name": "Iterar sobre Elementos",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2448,
1296
],
"parameters": {},
"typeVersion": 3
},
{
"id": "54c6c70e-59f6-4320-9d6a-5bdd94e8e6ed",
"name": "Obtener fila(s) en hoja",
"type": "n8n-nodes-base.googleSheets",
"position": [
2224,
2016
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "ea21290c-588d-443b-b401-d7329063e9bb",
"name": "Activador Programado",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
2048,
2016
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "748e2b43-e51a-417d-92ff-df0704cef2a9",
"name": "Iterar sobre Elementos1",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
2720,
2016
],
"parameters": {},
"typeVersion": 3
},
{
"id": "2e9a8548-a8bf-47e3-8fe1-93072276cd9d",
"name": "Actualizar fila en hoja",
"type": "n8n-nodes-base.googleSheets",
"position": [
3440,
2032
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "ed8a4414-e31d-46d7-9ad6-836faee1a3ac",
"name": "Activador Programado1",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
2064,
2672
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "6951d857-278a-4633-be22-f06937dacb98",
"name": "Iterar sobre Elementos2",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
2752,
2656
],
"parameters": {},
"typeVersion": 3
},
{
"id": "bb781af1-7246-4bf7-9f77-1f7eb17637ef",
"name": "Esperar",
"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": "Esperar1",
"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": "Obtener fila(s) en hoja1",
"type": "n8n-nodes-base.googleSheets",
"position": [
2288,
2672
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "71fb0b9d-d8b2-490b-8a55-a515c56fe10e",
"name": "Actualizar fila en hoja1",
"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": "Activador Programado2",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
2064,
3136
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "a3dfff36-07c3-49c6-b7fb-718638854507",
"name": "Esperar2",
"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": "Actualizar fila en hoja2",
"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": "Código",
"type": "n8n-nodes-base.code",
"onError": "continueErrorOutput",
"position": [
2928,
3120
],
"parameters": {},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "37e8ea98-60d5-413e-922d-e5fed98e96ef",
"name": "Nota Adhesiva",
"type": "n8n-nodes-base.stickyNote",
"position": [
1776,
2528
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1ab50ec4-c5f0-4888-8f2c-0b16c518e6ea",
"name": "Nota Adhesiva1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1792,
1856
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9bb1bf69-b5f4-4471-a98e-e4728062391c",
"name": "Nota Adhesiva2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1808,
3072
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1b2d40a7-ceef-4b15-9ffd-a9ab4ebce29d",
"name": "Código1",
"type": "n8n-nodes-base.code",
"position": [
3456,
3120
],
"parameters": {},
"typeVersion": 2
},
{
"id": "3fdb7f62-3fad-4067-b6c8-d2e07984370f",
"name": "Iterar sobre Elementos4",
"type": "n8n-nodes-base.splitInBatches",
"onError": "continueErrorOutput",
"position": [
2704,
3088
],
"parameters": {},
"typeVersion": 3,
"alwaysOutputData": true
},
{
"id": "abf7cc40-ea8a-4c1d-abb5-31f8d4e5a723",
"name": "Obtener fila(s) en hoja3",
"type": "n8n-nodes-base.googleSheets",
"position": [
2288,
3136
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "d83f2237-6fe7-4eb4-b2d7-deba7c26e54e",
"name": "Linkedin Formateador de Datos Extraídos",
"type": "@n8n/n8n-nodes-langchain.agent",
"onError": "continueErrorOutput",
"position": [
2656,
1296
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "3f428a31-7eb0-4e78-b574-bf0b968b652e",
"name": "Almacenar Valores",
"type": "n8n-nodes-base.googleSheets",
"position": [
3008,
1296
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "a3e862b8-9f95-46ad-be2d-a7b06f15a1f0",
"name": "Nombre de Empresa a Dominio",
"type": "n8n-nodes-base.httpRequest",
"position": [
3232,
2032
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "835de11e-aa6d-4e4e-9f2d-7e008155d1db",
"name": "Búsqueda de Personas",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
3024,
2656
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "bfed2a87-6446-4484-aad5-56f4ee3a566e",
"name": "Buscador de Correos Electrónicos",
"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
}
]
]
}
}
}¿Cómo usar este flujo de trabajo?
Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.
¿En qué escenarios es adecuado este flujo de trabajo?
Avanzado - Generación de leads, Resumen de IA
¿Es de pago?
Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.
Flujos de trabajo relacionados recomendados
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.
Compartir este flujo de trabajo