Génération de prospects LinkedIn (GPT-4o, scraping Apify et contact automatisé)

• •Peut nécessiter les informations d'identification d'authentification de l'API cible
• •Informations d'identification Google Sheets API
• •Clé API OpenAI

{
  "meta": {
    "instanceId": "6570b9a3c619b905a29a1c8dcd31f41add28a4b324f4ec6bd206e06c2b9731cf"
  },
  "nodes": [
    {
      "id": "161feae7-64f3-470a-8747-880024aed008",
      "name": "Agrégation",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1168,
        224
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "f72f38e9-b5b1-4481-8248-f568c8b20123",
      "name": "Description du public à scraper",
      "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": "Génération de l'URL Apollo pour scraper apify",
      "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": "Exécution de l'acteur apify pour scraper le prospect",
      "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": "Génération d'un ice breaker en scrapant les données 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": "Ajout de l'ice breaker dans les feuilles 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": "Déclenchement de Phantom Buster pour envoyer une demande de connexion personnalisée",
      "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": "Note adhésive",
      "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": "Note adhésive 1",
      "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": "Note adhésive 2",
      "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": "Note adhésive 3",
      "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": "Note adhésive 4",
      "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
          }
        ]
      ]
    }
  }
}