セールスAIネットワークリサーチャー
上級
これはLead Generation, AI Summarization分野の自動化ワークフローで、17個のノードを含みます。主にSet, Merge, GoogleSheets, ManualTrigger, SplitInBatchesなどのノードを使用。 Explorium MCPとClaude AIを使って会社プロファイルを補完し、マーケット進出調査を行う
前提条件
- •Google Sheets API認証情報
- •Anthropic API Key
使用ノード (17)
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "F45TTZf5JIuQ8mdg",
"meta": {
"instanceId": "0a70652f43c1b29dd16c35b61a38fd31c8004f58bc7e723bf43262a797407c77",
"templateId": "2324",
"templateCredsSetupCompleted": true
},
"name": "AI web researcher for sales",
"tags": [],
"nodes": [
{
"id": "71b06728-7f59-49e3-9365-3281189a6659",
"name": "「Test workflow」クリック時",
"type": "n8n-nodes-base.manualTrigger",
"position": [
920,
340
],
"parameters": {},
"typeVersion": 1
},
{
"id": "b37019e3-c7ab-4119-986d-c27d082a036e",
"name": "入力",
"type": "n8n-nodes-base.set",
"position": [
1380,
340
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "fcc97354-b9f6-4459-a004-46e87902c77c",
"name": "company_input",
"type": "string",
"value": "={{ $json.input }}"
},
{
"id": "e5415c49-5204-45b1-a0e9-814157127b12",
"name": "row_number",
"type": "number",
"value": "={{ $json.row_number }}"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "24e2f3b0-8b90-49a9-bde6-0fb0c2baf52a",
"name": "Webサイトコンテンツ取得",
"type": "@n8n/n8n-nodes-langchain.toolWorkflow",
"position": [
2280,
560
],
"parameters": {
"name": "get_website_content",
"source": "parameter",
"description": "This tool will return the text from the given URL. ",
"workflowJson": "{\n \"meta\": {\n \"templateCredsSetupCompleted\": true,\n \"instanceId\": \"2b1cc1a8b0a2fb9caab11ab2d5eb3712f9973066051b2e898cf4041a1f2a7757\"\n },\n \"nodes\": [\n {\n \"parameters\": {},\n \"id\": \"475eaf3c-7e11-457e-8b72-4d3e683e2f80\",\n \"name\": \"Execute Workflow Trigger\",\n \"type\": \"n8n-nodes-base.executeWorkflowTrigger\",\n \"typeVersion\": 1,\n \"position\": [\n 260,\n 340\n ]\n },\n {\n \"parameters\": {\n \"url\": \"={{ $json.query.url }}\",\n \"options\": {}\n },\n \"id\": \"321fbc74-d749-4f9b-954e-7cad37601ddf\",\n \"name\": \"Visit Website\",\n \"type\": \"n8n-nodes-base.httpRequest\",\n \"typeVersion\": 4.2,\n \"position\": [\n 440,\n 340\n ]\n },\n {\n \"parameters\": {\n \"operation\": \"extractHtmlContent\",\n \"extractionValues\": {\n \"values\": [\n {\n \"key\": \"body\",\n \"cssSelector\": \"html\",\n \"skipSelectors\": \"head\"\n }\n ]\n },\n \"options\": {\n \"cleanUpText\": true\n }\n },\n \"id\": \"6e51732a-4999-4805-838b-f692e9965197\",\n \"name\": \"HTML\",\n \"type\": \"n8n-nodes-base.html\",\n \"typeVersion\": 1.2,\n \"position\": [\n 620,\n 340\n ]\n }\n ],\n \"connections\": {\n \"Execute Workflow Trigger\": {\n \"main\": [\n [\n {\n \"node\": \"Visit Website\",\n \"type\": \"main\",\n \"index\": 0\n }\n ]\n ]\n },\n \"Visit Website\": {\n \"main\": [\n [\n {\n \"node\": \"HTML\",\n \"type\": \"main\",\n \"index\": 0\n }\n ]\n ]\n }\n },\n \"pinData\": {\n \"Execute Workflow Trigger\": [\n {\n \"query\": {\n \"url\": \"https://www.lemlist.com\"\n }\n }\n ]\n }\n}",
"jsonSchemaExample": "{\n\t\"url\": \"https://www.lemlist.com\"\n}",
"specifyInputSchema": true,
"responsePropertyName": "body"
},
"typeVersion": 1.1
},
{
"id": "4fe311f2-4983-4380-b4ed-a827a406fce5",
"name": "構造化出力パーサー",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2620,
660
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n\t\"type\": \"object\",\n\t\"properties\": {\n\t\t\"case_study_link\": {\n\t\t\t\"type\":[\"string\", \"null\"]\n\t\t},\n \t\t\"domain\": {\n\t\t\t\"type\": [\"string\", \"null\"]\n\t\t},\n \"linkedinUrl\": {\n\t\t\t\"type\": [\"string\", \"null\"]\n\t\t},\n \t\"market\": {\n\t\t\t\"type\": [\"string\", \"null\"]\n\t\t},\n\t\t\"cheapest_plan\": {\n\t\t\t\"type\": [\"number\", \"null\"]\n\t\t},\n\t\"has_enterprise_plan\": {\n\t\t\t\"type\": [\"boolean\", \"null\"]\n\t\t},\n\t\"has_API\": {\n\t\t\t\"type\": [\"boolean\", \"null\"]\n\t\t},\n\t\"has_free_trial\": {\n\t\t\t\"type\": [\"boolean\", \"null\"]\n\t\t},\n\t\"integrations\": {\n\t\t\t\"type\": [\"array\",\"null\"],\n \"items\": {\n\t\t\t\t\"type\": \"string\"\n\t\t\t}\n\t\t}\n\t}\n}"
},
"typeVersion": 1.2
},
{
"id": "89ed0723-4dbe-428d-b1a9-ebdf515e42bb",
"name": "アイテムをループ処理",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1600,
340
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "34ea3862-e8e5-4bf2-a9aa-2ad084376bb5",
"name": "AIリサーチャー出力データ",
"type": "n8n-nodes-base.set",
"position": [
2380,
280
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "4109ca11-1bb8-4f5c-8bec-a962f44b0746",
"name": "domain",
"type": "string",
"value": "={{ $json.output.domain }}"
},
{
"id": "7f492768-375e-48fa-866b-644b2b5cbd68",
"name": "linkedinUrl",
"type": "string",
"value": "={{ $json.output.linkedinUrl }}"
},
{
"id": "e30b0d07-68db-45a1-9593-fd6ce24a1d50",
"name": "market",
"type": "string",
"value": "={{ $json.output.market }}"
},
{
"id": "0c03a51e-2c07-4583-85c6-d3d2ee81c5d1",
"name": "cheapest_plan",
"type": "number",
"value": "={{ $json.output.cheapest_plan }}"
},
{
"id": "0c9622d0-8446-4663-9a94-964b5df851f1",
"name": "has_enterprise_plan",
"type": "boolean",
"value": "={{ $json.output.has_enterprise_plan }}"
},
{
"id": "564cf6ea-457f-4762-bc19-6900b7d5743c",
"name": "has_API",
"type": "boolean",
"value": "={{ $json.output.has_API }}"
},
{
"id": "7fd39897-65c3-45d6-9563-8254f55ecef0",
"name": "has_free_trial",
"type": "boolean",
"value": "={{ $json.output.has_free_trial }}"
},
{
"id": "26477939-d407-4cae-92b2-9a9dc0f53a64",
"name": "integrations",
"type": "array",
"value": "={{ $json.output.integrations }}"
},
{
"id": "f0cc61d1-6b6b-4142-8627-4a4c721b19a1",
"name": "case_study_link",
"type": "string",
"value": "={{ $json.output.case_study_link }}"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "ff1cb26d-6138-4ee1-9f28-4ecc80c1c8ae",
"name": "Google Sheets - データで行を更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
2960,
680
],
"parameters": {
"columns": {
"value": {
"domain": "={{ $json.domain }}",
"market": "={{ $json.market }}",
"row_number": "={{ $json.row_number }}",
"linkedinUrl": "={{ $json.linkedinUrl }}",
"integrations": "={{ $json.integrations }}",
"cheapest_plan": "={{ $json.cheapest_plan }}",
"has_free_trial": "={{ $json.has_free_trial }}",
"enrichment_status": "done",
"has_entreprise_plan": "={{ $json.has_enterprise_plan }}",
"last_case_study_link": "={{ $json.case_study_link }}"
},
"schema": [
{
"id": "input",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "input",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "domain",
"type": "string",
"display": true,
"required": false,
"displayName": "domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedinUrl",
"type": "string",
"display": true,
"required": false,
"displayName": "linkedinUrl",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "has_free_trial",
"type": "string",
"display": true,
"required": false,
"displayName": "has_free_trial",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "cheapest_plan",
"type": "string",
"display": true,
"required": false,
"displayName": "cheapest_plan",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "has_entreprise_plan",
"type": "string",
"display": true,
"required": false,
"displayName": "has_entreprise_plan",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_case_study_link",
"type": "string",
"display": true,
"required": false,
"displayName": "last_case_study_link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "market",
"type": "string",
"display": true,
"required": false,
"displayName": "market",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "integrations",
"type": "string",
"display": true,
"required": false,
"displayName": "integrations",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "enrichment_status",
"type": "string",
"display": true,
"required": false,
"displayName": "enrichment_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NZbhZSBhuJIfL3waJ8Vitz2_0pZASia4cAKma-hN_lo/edit#gid=0",
"cachedResultName": "input"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1NZbhZSBhuJIfL3waJ8Vitz2_0pZASia4cAKma-hN_lo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NZbhZSBhuJIfL3waJ8Vitz2_0pZASia4cAKma-hN_lo/edit?usp=drivesdk",
"cachedResultName": "Enrich companies using AI agents [template]"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "ichpKIhnbuwz30pf",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.3
},
{
"id": "6611f852-b4d6-4a07-9428-db206ef57cc3",
"name": "データをマージ",
"type": "n8n-nodes-base.merge",
"position": [
2720,
180
],
"parameters": {
"mode": "combine",
"options": {},
"combinationMode": "mergeByPosition"
},
"typeVersion": 2.1
},
{
"id": "2a19516b-33a1-4987-9b5f-242a084621e0",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
440,
100
],
"parameters": {
"width": 409.013165632244,
"height": 658.061460122593,
"content": "## Read Me\n\nThis workflow allows you to do account research with the web using AI.\n\nThe advanced AI module has 2 capabilities: \n- Research Google using SerpAPI\n- Visit and get website content using a sub-workflow\n\n\nFrom an unstructured input like a domain or a company name. \n\nIt will return the following properties: \n- domain\n- company Linkedin Url\n- cheapest plan\n- has free trial\n- has entreprise plan\n- has API\n- market (B2B or B2C)\n\n\nThe strength of n8n here is that you can adapt this workflow to research whatever information you need.\n\nYou just have to precise it in the prompt and to precise the output format in the \"Strutured Output Parser\" module.\n\n[Click here to find more detailed instructions with video guide.](https://lempire.notion.site/AI-Web-research-with-n8n-a25aae3258d0423481a08bd102f16906)\n"
},
"typeVersion": 1
},
{
"id": "67d485c9-3289-4bb3-9523-cd24c0b1aa05",
"name": "充実させる行を取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
1140,
340
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NZbhZSBhuJIfL3waJ8Vitz2_0pZASia4cAKma-hN_lo/edit#gid=0",
"cachedResultName": "input"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1NZbhZSBhuJIfL3waJ8Vitz2_0pZASia4cAKma-hN_lo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NZbhZSBhuJIfL3waJ8Vitz2_0pZASia4cAKma-hN_lo/edit?usp=drivesdk",
"cachedResultName": "Enrich companies using AI agents [template]"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "pNcMgK8HfBbrkIMe",
"name": "Google Sheets account 7"
}
},
"typeVersion": 4.3
},
{
"id": "8bf0deae-dda7-4e27-9ac7-978db14cca19",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2540,
600
],
"parameters": {
"color": 3,
"width": 260,
"height": 216,
"content": "Precise here the format in which you need the data to be "
},
"typeVersion": 1
},
{
"id": "dc4f1550-1e3c-4175-a2b3-10153dc2fd77",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1860,
200
],
"parameters": {
"color": 3,
"width": 320,
"height": 200,
"content": "### Ask AI what are the information you are looking for about the company"
},
"typeVersion": 1
},
{
"id": "70fc73a0-303b-46e1-822d-cebdbccf8e32",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1900,
580
],
"parameters": {
"color": 3,
"width": 220,
"height": 209,
"content": "Explorium MCP Server does all the research for us!"
},
"typeVersion": 1
},
{
"id": "d7db2452-ba3d-4adb-bd8b-d17a92d1bce5",
"name": "AI企業リサーチャー",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1920,
280
],
"parameters": {
"text": "=This is the company I want you to research info about:\n{{ $json.company_input }}\n\nReturn me:\n- the linkedin URL of the company\n- the domain of the company. in this format ([domain].[tld])\n- market: if they are B2B or B2C. Only reply by \"B2B\" or \"B2B\"\n- the lowest paid plan the company is offering. If you are not sure, reply null.\n- the latest case study URL published on the website (find case study hub using google, and return the first case study link)\n- tell me if the company offer an API\n- tell me if the company has an enterprise plan\n- tell me if the company has a free trial mentionned in their homepage. reply false if you don't find strong evidence.\n- return an array with up to 5 tools the company is integrated with",
"options": {
"maxIterations": 20
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.6
},
{
"id": "79eff129-790b-46da-bef3-899eb6db3ced",
"name": "付箋7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1080,
-40
],
"parameters": {
"color": 4,
"width": 175,
"height": 486,
"content": "In this workflow, I use Google Sheets to store the results. \n\nYou can use my template to get started faster:\n\n1. [Click on this link to get the template](https://docs.google.com/spreadsheets/d/1vR6s2nlTwu01v3GP7wvSRWS5W49FJIh20ZF7AUkmMDo/edit?usp=sharing)\n2. Make a copy of the Sheets\n3. Add the URL to this node and the node **\"Google Sheets - Update Row with data\"**\n\n\n"
},
"typeVersion": 1
},
{
"id": "4453d2c7-3b14-4d6a-962c-1388e931ca55",
"name": "MCPクライアント",
"type": "@n8n/n8n-nodes-langchain.mcpClientTool",
"position": [
1960,
640
],
"parameters": {
"sseEndpoint": "mcp.explorium.ai/sse",
"authentication": "headerAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "LZOE1nqmRk3X6r1J",
"name": "Explorium"
}
},
"typeVersion": 1
},
{
"id": "7fc6657a-fa50-4107-b5f7-aa70a7ff81db",
"name": "Anthropic チャットモデル",
"type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
"position": [
1800,
540
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "claude-3-7-sonnet-20250219",
"cachedResultName": "Claude 3.7 Sonnet"
},
"options": {}
},
"credentials": {
"anthropicApi": {
"id": "FQdE6twB8nCJNoxV",
"name": "Anthropic account"
}
},
"typeVersion": 1.3
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "585e3f9f-dd4e-40d9-8abe-ebf1185accbe",
"connections": {
"b37019e3-c7ab-4119-986d-c27d082a036e": {
"main": [
[
{
"node": "89ed0723-4dbe-428d-b1a9-ebdf515e42bb",
"type": "main",
"index": 0
}
]
]
},
"4453d2c7-3b14-4d6a-962c-1388e931ca55": {
"ai_tool": [
[
{
"node": "d7db2452-ba3d-4adb-bd8b-d17a92d1bce5",
"type": "ai_tool",
"index": 0
}
]
]
},
"6611f852-b4d6-4a07-9428-db206ef57cc3": {
"main": [
[
{
"node": "ff1cb26d-6138-4ee1-9f28-4ecc80c1c8ae",
"type": "main",
"index": 0
}
]
]
},
"89ed0723-4dbe-428d-b1a9-ebdf515e42bb": {
"main": [
null,
[
{
"node": "d7db2452-ba3d-4adb-bd8b-d17a92d1bce5",
"type": "main",
"index": 0
},
{
"node": "6611f852-b4d6-4a07-9428-db206ef57cc3",
"type": "main",
"index": 0
}
]
]
},
"67d485c9-3289-4bb3-9523-cd24c0b1aa05": {
"main": [
[
{
"node": "b37019e3-c7ab-4119-986d-c27d082a036e",
"type": "main",
"index": 0
}
]
]
},
"24e2f3b0-8b90-49a9-bde6-0fb0c2baf52a": {
"ai_tool": [
[
{
"node": "d7db2452-ba3d-4adb-bd8b-d17a92d1bce5",
"type": "ai_tool",
"index": 0
}
]
]
},
"7fc6657a-fa50-4107-b5f7-aa70a7ff81db": {
"ai_languageModel": [
[
{
"node": "d7db2452-ba3d-4adb-bd8b-d17a92d1bce5",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"d7db2452-ba3d-4adb-bd8b-d17a92d1bce5": {
"main": [
[
{
"node": "34ea3862-e8e5-4bf2-a9aa-2ad084376bb5",
"type": "main",
"index": 0
}
]
]
},
"4fe311f2-4983-4380-b4ed-a827a406fce5": {
"ai_outputParser": [
[
{
"node": "d7db2452-ba3d-4adb-bd8b-d17a92d1bce5",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"34ea3862-e8e5-4bf2-a9aa-2ad084376bb5": {
"main": [
[
{
"node": "6611f852-b4d6-4a07-9428-db206ef57cc3",
"type": "main",
"index": 1
}
]
]
},
"71b06728-7f59-49e3-9365-3281189a6659": {
"main": [
[
{
"node": "67d485c9-3289-4bb3-9523-cd24c0b1aa05",
"type": "main",
"index": 0
}
]
]
},
"ff1cb26d-6138-4ee1-9f28-4ecc80c1c8ae": {
"main": [
[
{
"node": "89ed0723-4dbe-428d-b1a9-ebdf515e42bb",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - リード獲得, AI要約
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
n8nノードの探索（可視化リファレンスライブラリ内）
n8nノードを可視化リファレンスライブラリで探索
If
Ftp
Set
+
If
Ftp
Set
113 ノードI versus AI
その他
GPT-4oとGoogle Sheetsを使った自動のな企業調査とリード豊富
GPT-4oとGoogle Sheetsを使用した自動のな企業調査とリード豊富化
Set
Merge
Google Sheets
+
Set
Merge
Google Sheets
22 ノードCandra Reza
リード獲得
Explorium を使用して ICP 企業を評価
ExploriumデータとClaude AIを使った企業ICPスコアの分析自動化
Form Trigger
Http Request
Agent
+
Form Trigger
Http Request
Agent
8 ノードItamar
リード獲得
営業用AIネットワークリサーチャー
営業向けAIネットワークリサーチャー
Set
Merge
Google Sheets
+
Set
Merge
Google Sheets
22 ノードLucas Perret
営業
基于AIの潜在顧客信息增强（Bright Data MCPとGoogle Sheets）
基于AIの潜在顧客信息增强：使用Bright Data MCPとGoogle Sheets
If
Set
Wait
+
If
Set
Wait
51 ノードCyril Nicko Gaspar
営業
潜在顧客開掘とメールワーキングフロー
Google Maps、SendGrid、AIを使用してB2Bリード獲得とメールマーケティングを自動化
If
Set
Code
+
If
Set
Code
141 ノードEzema Kingsley Chibuzo
リード獲得
