LinkedInリードジェネレーション（GPT-4o、Apifyスクレイピングと自動アプローチ）

• •ターゲットAPIの認証情報が必要な場合あり
• •Google Sheets API認証情報
• •OpenAI API Key

{
  "meta": {
    "instanceId": "6570b9a3c619b905a29a1c8dcd31f41add28a4b324f4ec6bd206e06c2b9731cf"
  },
  "nodes": [
    {
      "id": "161feae7-64f3-470a-8747-880024aed008",
      "name": "Aggregate",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1168,
        224
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "f72f38e9-b5b1-4481-8248-f568c8b20123",
      "name": "スクレイピング対象オーディエンスの説明",
      "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": "apify用Apollo URL生成（スクレイピング向け）",
      "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": "apifyアクター実行による見込み客スクレイピング",
      "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": "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": "アイスブレーカーの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": "Phantom Buster起動による個人別接続リクエスト送信",
      "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": "付箋",
      "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": "付箋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": "付箋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": "付箋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": "付箋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
          }
        ]
      ]
    }
  }
}