Generación de leads de LinkedIn (GPT-4o, crawling de Apify y contacto automático)

• •Pueden requerirse credenciales de autenticación para la API de destino
• •Credenciales de API de Google Sheets
• •Clave de API de OpenAI

{
  "meta": {
    "instanceId": "6570b9a3c619b905a29a1c8dcd31f41add28a4b324f4ec6bd206e06c2b9731cf"
  },
  "nodes": [
    {
      "id": "161feae7-64f3-470a-8747-880024aed008",
      "name": "Agregar",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1168,
        224
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "f72f38e9-b5b1-4481-8248-f568c8b20123",
      "name": "Descripción de la audiencia que desea extraer",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -288,
        224
      ],
      "webhookId": "6aac0ee2-c7d7-427a-ad13-ff570c7f7209",
      "parameters": {
        "options": {},
        "formTitle": "Audience ",
        "formFields": {
          "values": [
            {
              "fieldLabel": "descritpion of the company ",
              "placeholder": "company location,size,industry etc ",
              "requiredField": true
            }
          ]
        },
        "formDescription": "describe your audinece in plain text"
      },
      "typeVersion": 2.2
    },
    {
      "id": "bddc1d94-d65d-4d8f-811b-81a6c1d5f88f",
      "name": "Generar URL de Apollo para que apify extraiga",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -48,
        224
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "chatgpt-4o-latest",
          "cachedResultName": "CHATGPT-4O-LATEST"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "you are a helpful intelligent sales assitant "
            },
            {
              "content": "your task is to take as input of a prospect audeince and turn that into a apollo serach URL here is an example of the URL \nhttps://app.apollo.io/#/people?personLocations[]=United%20States&includedOrganizationKeywordFields[]=tags&includedOrganizationKeywordFields[]=name&sortAscending=false&sortByField=recommendations_score&qKeywords=marketing%20agency%20&page=1&personTitles[]=ceo%20and%20founder&personTitles[]=co-founder\nThis url describes a search for peolpe that are \n-located in the united state \n- Holds the titles: CEO,founder,co founder \n- have a keyword assosiated with \"marketing \"agency\"\nyou can only make changes to these fields only \nreturn your response as using this format  \n{\"SearchUrl\":\"SearchUrlgoeshere\"}"
            },
            {
              "content": "={{ $json['descritpion of the company '] }}"
            }
          ]
        },
        "jsonOutput": true
      },
      "credentials": {
        "openAiApi": {
          "id": "6theco8aTqbElchh",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "f85a5a7f-97b8-445d-bb39-40671595b72e",
      "name": "Ejecutar actor apify para extraer el prospecto",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        352,
        224
      ],
      "parameters": {
        "url": "https://api.apify.com/v2/acts/jljBwyyQakqrL1wae/run-sync-get-dataset-items",
        "method": "POST",
        "options": {},
        "jsonBody": "={\n    \"cleanOutput\": true,\n    \"url\": \"{{ $json.message.content.SearchUrl }}\"\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {
              "name": "Accept",
              "value": "application/json"
            },
            {
              "name": "Authorization",
              "value": "Bearer api key"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "6cb4458f-c921-4e9b-ad10-581b47e42c2e",
      "name": "Generar rompehielos extrayendo datos de linkedin",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        560,
        224
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "chatgpt-4o-latest",
          "cachedResultName": "CHATGPT-4O-LATEST"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "role": "system",
              "content": "you are a helpful "
            },
            {
              "content": "your task is to input a bunch of linkedin profile information of a user, and then geenrate a very short,very punchy incebreaker that i can use as a variable in my connection request \nreturn your output in this format \n{\"Icebreaker\":\"Icebreakergoeshere\"}\nin order to ensure icebreakers are punchy and high quality, make them follow this template \nHey {{name}}, loved seeing {{thingaboutThem}}, Im also into {{plausibleTieIN}}, thought Id connect.\nFor {{thingaboutThem}}and {{plausibleTiein}}, never use the exact information provided in a linked in field. instead,always parapharse. this makes it seems human written instead of just an automated message, Also, make it super short. Dont say stuff like \"\"passionate about truning vision into reality \" or anything like that be extremely Laconic and spartan."
            },
            {
              "content": "{\"LinkedInFields\":\"Danielle Morgan, Fort Lauderdale, Founder & CEO at DM Creative Agency, previous experience: Regional Sales Director at Out East Eyewear, Account Director at Radancy\"}\n"
            },
            {
              "content": "map the prospect's LinkedIn or details from the previous node. "
            }
          ]
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "6theco8aTqbElchh",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "423b22af-c02f-4abc-a77e-8050dcca9c90",
      "name": "Agregar rompehielos a hojas de google",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        944,
        224
      ],
      "parameters": {
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": ""
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "642dd7d3-a634-4cb5-b930-1021a594413d",
      "name": "Activar Phantom Buster para enviar solicitud de conexión personalizada",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1392,
        224
      ],
      "parameters": {
        "url": "https://api.phantombuster.com/api/v2/(your agent id goes here)/launch",
        "method": "POST",
        "options": {},
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "X-Phantombuster-Key",
              "value": "api key goes here"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "9f714cd6-82dd-4e85-b076-cf01542d8395",
      "name": "Nota adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        880,
        80
      ],
      "parameters": {
        "height": 336,
        "content": "Create a google sheet add relevant colums name,linkedin url,company website,description and oter coloums that are genrated by the apify node and map them accordingly "
      },
      "typeVersion": 1
    },
    {
      "id": "bbd5ef47-3815-4157-9269-c558e0fe7d26",
      "name": "Nota adhesiva1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1312,
        -32
      ],
      "parameters": {
        "height": 384,
        "content": "Triggers the phantom buster a platform that sends linkedin connection requests. to your leads, you have to go to the api credentials to get the relevant url but i hvae harcoded one for the connection request and add your api key to the header, and the agent ID of the agent you are running will be available in the url of the agent in phantombuster thats it no body  is needed."
      },
      "typeVersion": 1
    },
    {
      "id": "792ddc3b-1c38-4e7b-b84e-36c7009b6689",
      "name": "Nota adhesiva2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        576,
        80
      ],
      "parameters": {
        "height": 304,
        "content": "Hard-coded the prompt for GPT4o to generate the icebreaker; alter the prompt according to your desired need"
      },
      "typeVersion": 1
    },
    {
      "id": "7b0d00de-8404-4bb5-bd9b-9201bab7ef62",
      "name": "Nota adhesiva3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        288,
        128
      ],
      "parameters": {
        "height": 224,
        "content": "Send a request to run the apify actor that scrapes the leads; everything is configuered add your API key "
      },
      "typeVersion": 1
    },
    {
      "id": "de1af1ca-e857-4e37-8786-104300f73cad",
      "name": "Nota adhesiva4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -32,
        64
      ],
      "parameters": {
        "height": 352,
        "content": "Generates an Apollo URL,using GPT-4o, which will be scraped by apify actor to get the leads data. the url is generated by the information you input in the form. "
      },
      "typeVersion": 1
    }
  ],
  "pinData": {
    "Description of the audience you want to scrap": [
      {
        "formMode": "test",
        "submittedAt": "2025-07-01T17:14:00.111+05:00",
        "descritpion of the company ": "i want a creative agency in united state with 1-1000 employess"
      }
    ]
  },
  "connections": {
    "161feae7-64f3-470a-8747-880024aed008": {
      "main": [
        [
          {
            "node": "642dd7d3-a634-4cb5-b930-1021a594413d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "423b22af-c02f-4abc-a77e-8050dcca9c90": {
      "main": [
        [
          {
            "node": "161feae7-64f3-470a-8747-880024aed008",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f85a5a7f-97b8-445d-bb39-40671595b72e": {
      "main": [
        [
          {
            "node": "6cb4458f-c921-4e9b-ad10-581b47e42c2e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bddc1d94-d65d-4d8f-811b-81a6c1d5f88f": {
      "main": [
        [
          {
            "node": "f85a5a7f-97b8-445d-bb39-40671595b72e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f72f38e9-b5b1-4481-8248-f568c8b20123": {
      "main": [
        [
          {
            "node": "bddc1d94-d65d-4d8f-811b-81a6c1d5f88f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6cb4458f-c921-4e9b-ad10-581b47e42c2e": {
      "main": [
        [
          {
            "node": "423b22af-c02f-4abc-a77e-8050dcca9c90",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}