Pipeline automatizado para enriquecimiento de prospectos de LinkedIn con Apollo.io y Hojas de Cálculo de Google

Avanzado

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

Requisitos previos
  • 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
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
  "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
          }
        ]
      ]
    }
  }
}
Preguntas frecuentes

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

Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos33
Categoría2
Tipos de nodos13
Descripción de la dificultad

Adecuado para usuarios avanzados, flujos de trabajo complejos con 16+ nodos

Autor
Rahi Uppal

Rahi Uppal

@rahiuppal

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

Enlaces externos
Ver en n8n.io

Compartir este flujo de trabajo

Categorías

Categorías: 34