销售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": "When clicking \"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": "Get website content",
"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 Researcher Output Data",
"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 - Update Row with data",
"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": "Merge data",
"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": "Get rows to enrich",
"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 company researcher",
"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": {
"Input": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"MCP Client": {
"ai_tool": [
[
{
"node": "AI company researcher",
"type": "ai_tool",
"index": 0
}
]
]
},
"Merge data": {
"main": [
[
{
"node": "Google Sheets - Update Row with data",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
null,
[
{
"node": "AI company researcher",
"type": "main",
"index": 0
},
{
"node": "Merge data",
"type": "main",
"index": 0
}
]
]
},
"Get rows to enrich": {
"main": [
[
{
"node": "Input",
"type": "main",
"index": 0
}
]
]
},
"Get website content": {
"ai_tool": [
[
{
"node": "AI company researcher",
"type": "ai_tool",
"index": 0
}
]
]
},
"Anthropic Chat Model": {
"ai_languageModel": [
[
{
"node": "AI company researcher",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"AI company researcher": {
"main": [
[
{
"node": "AI Researcher Output Data",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "AI company researcher",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"AI Researcher Output Data": {
"main": [
[
{
"node": "Merge data",
"type": "main",
"index": 1
}
]
]
},
"When clicking \"Test workflow\"": {
"main": [
[
{
"node": "Get rows to enrich",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets - Update Row with data": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 潜在客户开发, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
使用GPT-4o和Google Sheets的自动公司研究和线索丰富
使用GPT-4o和Google Sheets的自动公司研究和线索丰富
Set
Merge
Google Sheets
+9
22 节点Candra Reza
潜在客户开发
使用 Explorium 评分公司 ICP
通过Explorium数据和Claude AI分析自动化公司ICP评分
Form Trigger
Http Request
Agent
+3
8 节点Itamar
潜在客户开发
通过AI分析HubSpot和Google Sheets数据预测客户流失
通过AI分析HubSpot和Google Sheets数据预测客户流失
Set
Code
Merge
+17
27 节点PollupAI
客户关系管理
使用 Bright Data API 和 AI 抓取分析 Google 广告并发送邮件报告
使用 Bright Data API 和 AI 抓取分析 Google 广告并发送邮件报告
Set
Code
Gmail
+15
45 节点Zacharia Kimotho
市场调研
销售AI网络研究员
销售用AI网络研究员
Set
Merge
Google Sheets
+9
22 节点Lucas Perret
销售
