使用Explorium.ai和Claude
中级
这是一个Sales, AI领域的自动化工作流，包含 10 个节点。主要使用 If, Code, GoogleSheets, SplitInBatches, Agent 等节点，结合人工智能技术实现智能自动化。 使用Explorium.ai和Claude AI在Google表格中丰富公司企业数据
前置要求
- •Google Sheets API 凭证
- •Anthropic API Key
使用的节点 (10)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "0a70652f43c1b29dd16c35b61a38fd31c8004f58bc7e723bf43262a797407c77"
},
"name": "My workflow 6",
"tags": [],
"nodes": [
{
"id": "326f7ab3-3c5d-4b6e-bb12-9815a9179740",
"name": "Google Sheets Trigger",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
580,
165
],
"parameters": {
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bAMUxQ2UCU_rd1khEkNZ0RKqmBzal7eKk90-AnVScQE/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1bAMUxQ2UCU_rd1khEkNZ0RKqmBzal7eKk90-AnVScQE",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bAMUxQ2UCU_rd1khEkNZ0RKqmBzal7eKk90-AnVScQE/edit?usp=drivesdk",
"cachedResultName": "n8n test"
}
},
"typeVersion": 1
},
{
"id": "6181d60a-91b4-4068-80ab-e4c8fb6f7eac",
"name": "Filter Valid Rows",
"type": "n8n-nodes-base.if",
"position": [
800,
165
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 1,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "8c7d5b8a-4569-4c8f-b5e8-6c5f5e5c5e5c",
"operator": {
"type": "string",
"operation": "notEmpty"
},
"leftValue": "={{ $json.name }}",
"rightValue": ""
},
{
"id": "9d8e6c9b-5670-5d9f-c6f9-7d6g6f6d6f6d",
"operator": {
"type": "string",
"operation": "notEmpty"
},
"leftValue": "={{ $json.website }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2
},
{
"id": "36dd234e-d726-418b-b70e-7c39afea91b4",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1020,
165
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "3870bad2-9551-4c1d-93bd-c42c44ce9584",
"name": "AI Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1272,
40
],
"parameters": {
"text": "=You will be provided with company information including:\n\nName: {{ $json.name }}\nDomain: {{ $json.website }}\n\nYour task is to research and extract the following key business metrics for this company:\nRequired Data Points:\n- Name (keep the same as provided)\n- Website (keep the same as provided)\n- Annual revenue (as business_id first, then get the range)\n- Number of employees (range)\n- NAICS code\n\nUse the Explorium tools to:\n1. First use match-business to find the business ID\n2. Then use enrich-businesses-firmographics to get the company details\n\nReturn the data exactly in this format.",
"options": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.6
},
{
"id": "94f62314-ab95-4f2c-8f9c-c658a982815e",
"name": "Anthropic Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
"position": [
1240,
220
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "claude-sonnet-4-20250514",
"cachedResultName": "Claude Sonnet 4"
},
"options": {}
},
"credentials": {
"anthropicApi": {
"id": "zb4GaoxVQ7gIbD2A",
"name": "Anthropic account 3"
}
},
"typeVersion": 1.3
},
{
"id": "c5416012-86dd-4b10-8526-ce4147833572",
"name": "Code - Format Output",
"type": "n8n-nodes-base.code",
"position": [
1680,
40
],
"parameters": {
"jsCode": "// Simply pass through the AI output with proper formatting\nreturn {\n name: $json.output.name || $json.name,\n website: $json.output.website || $json.website,\n business_id: $json.output.business_id || '',\n naics: $json.output.naics || '',\n number_of_employees_range: $json.output.number_of_employees_range || '',\n yearly_revenue_range: $json.output.yearly_revenue_range || ''\n};"
},
"typeVersion": 2
},
{
"id": "12f2e1b6-48c9-42f6-a4af-9574b486d270",
"name": "Update Company Row",
"type": "n8n-nodes-base.googleSheets",
"position": [
1900,
165
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "website",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "business_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "business_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "naics",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "naics",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "number_of_employees_range",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "number_of_employees_range",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "yearly_revenue_range",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "yearly_revenue_range",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"name"
]
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bAMUxQ2UCU_rd1khEkNZ0RKqmBzal7eKk90-AnVScQE/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1bAMUxQ2UCU_rd1khEkNZ0RKqmBzal7eKk90-AnVScQE",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1bAMUxQ2UCU_rd1khEkNZ0RKqmBzal7eKk90-AnVScQE/edit?usp=drivesdk",
"cachedResultName": "n8n test"
}
},
"typeVersion": 4.5
},
{
"id": "af35ecca-cf6b-4d3a-ab18-61870f7601c4",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-180
],
"parameters": {
"width": 660,
"height": 900,
"content": "# Enrich Company Data from Google Sheets with Explorium MCP\n\nThis workflow automatically enriches company data when new rows are added or when the name/website fields are updated in your Google Sheet.\n\n### Workflow Structure:\n\n**Google Sheets Trigger** → **Filter Valid Rows** → **Loop Over Items**\n ↓\n **AI Agent**\n ↓\n **Code - Format Output**\n ↓\n **Update Company Row**\n ↓\n (back to Loop Over Items)\n\n### How the Loop Works:\n1. Loop Over Items splits the batch (size 1)\n2. Sends one item to AI Agent\n3. AI Agent enriches the data\n4. Code formats the output\n5. Google Sheets updates the row\n6. Flow returns to Loop Over Items for next item\n7. When all items are processed, loop ends\n\n### Key Points:\n- Each row is processed individually\n- The loop continues until all rows are done\n- Failed enrichments won't stop other rows\n\n### Testing:\n1. Add multiple rows with company names and websites\n2. Trigger the workflow\n3. Watch each row get processed sequentially\n4. All rows should be updated with enriched data"
},
"typeVersion": 1
},
{
"id": "6194c65f-0321-4ddc-8264-168bd04ef05b",
"name": "Explorium MCP",
"type": "@n8n/n8n-nodes-langchain.mcpClientTool",
"position": [
1380,
220
],
"parameters": {
"sseEndpoint": "https://mcp.explorium.ai/sse",
"authentication": "bearerAuth"
},
"credentials": {
"httpBearerAuth": {
"id": "7uIoZJ2gQQuHHIDb",
"name": "Bearer Auth MCP"
}
},
"typeVersion": 1
},
{
"id": "c4f2e8b5-ac31-4f29-8f7f-cf7e641efbbb",
"name": "Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1520,
220
],
"parameters": {
"jsonSchemaExample": "{\n \"name\": \"Microsoft Corporation\",\n \"website\": \"https://www.microsoft.com\",\n \"business_id\": \"a34bacf839b923770b2c360eefa26748\",\n \"naics\": \"511210\",\n \"number_of_employees_range\": \"10001+\",\n \"yearly_revenue_range\": \"100B-1T\"\n}"
},
"typeVersion": 1.2
}
],
"active": false,
"pinData": {
"Google Sheets Trigger": [
{
"json": {
"name": "Amazon.com, Inc.",
"naics": 454110,
"website": "https://www.amazon.com",
"row_number": 9,
"business_id": "8f19793b2671094e63a15ab883d50137",
"change_type": "updated",
"yearly_revenue_range": "100B-1T",
"number_of_employees_range": "10001+"
}
},
{
"json": {
"name": "Toyota North America",
"naics": 336111,
"website": "https://careers.toyota.com/us/en",
"row_number": 10,
"business_id": "9185f3ec501c674c7c788464a36e7fb3",
"change_type": "updated",
"yearly_revenue_range": "10B-100B",
"number_of_employees_range": "10001+"
}
},
{
"json": {
"name": "The Coca-Cola Company",
"naics": 312112,
"website": "https://www.coca-colacompany.com",
"row_number": 11,
"business_id": "26751be1181460baf78db8d5eb7aad39",
"change_type": "updated",
"yearly_revenue_range": "10B-100B",
"number_of_employees_range": "10001+"
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "",
"connections": {
"3870bad2-9551-4c1d-93bd-c42c44ce9584": {
"main": [
[
{
"node": "c5416012-86dd-4b10-8526-ce4147833572",
"type": "main",
"index": 0
}
]
]
},
"6194c65f-0321-4ddc-8264-168bd04ef05b": {
"ai_tool": [
[
{
"node": "3870bad2-9551-4c1d-93bd-c42c44ce9584",
"type": "ai_tool",
"index": 0
}
]
]
},
"c4f2e8b5-ac31-4f29-8f7f-cf7e641efbbb": {
"ai_outputParser": [
[
{
"node": "3870bad2-9551-4c1d-93bd-c42c44ce9584",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"36dd234e-d726-418b-b70e-7c39afea91b4": {
"main": [
[],
[
{
"node": "3870bad2-9551-4c1d-93bd-c42c44ce9584",
"type": "main",
"index": 0
}
]
]
},
"6181d60a-91b4-4068-80ab-e4c8fb6f7eac": {
"main": [
[
{
"node": "36dd234e-d726-418b-b70e-7c39afea91b4",
"type": "main",
"index": 0
}
]
]
},
"12f2e1b6-48c9-42f6-a4af-9574b486d270": {
"main": [
[
{
"node": "36dd234e-d726-418b-b70e-7c39afea91b4",
"type": "main",
"index": 0
}
]
]
},
"94f62314-ab95-4f2c-8f9c-c658a982815e": {
"ai_languageModel": [
[
{
"node": "3870bad2-9551-4c1d-93bd-c42c44ce9584",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"c5416012-86dd-4b10-8526-ce4147833572": {
"main": [
[
{
"node": "12f2e1b6-48c9-42f6-a4af-9574b486d270",
"type": "main",
"index": 0
}
]
]
},
"326f7ab3-3c5d-4b6e-bb12-9815a9179740": {
"main": [
[
{
"node": "6181d60a-91b4-4068-80ab-e4c8fb6f7eac",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 销售, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
基于AI的潜在客户信息增强（Bright Data MCP和Google Sheets）
基于AI的潜在客户信息增强：使用Bright Data MCP和Google Sheets
If
Set
Wait
+
If
Set
Wait
51 节点Cyril Nicko Gaspar
销售
HDW潜在客户越野车
使用AI代理的自动化LinkedIn潜在客户生成、评分与沟通
If
Code
Sort
+
If
Code
Sort
86 节点Andrey
销售
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+
If
Ftp
Set
113 节点I versus AI
其他
Google My Business潜在客户提取
使用Bright Data按服务或位置从Google My Business提取潜在客户
If
Code
Wait
+
If
Code
Wait
23 节点Dvir Sharon
销售
潜在客户工作流：通过 BrightData 进行 Yelp 和 Trustpilot 抓取 + OpenAI 分析
通过 Yelp 和 Trustpilot 抓取 + AI 驱动的邮件外联生成销售线索
If
Code
Wait
+
If
Code
Wait
32 节点Incrementors
销售
使用 GPT-4 自动生成并分发 LinkedIn 帖子到个人资料和群组
使用 GPT-4 自动生成并分发 LinkedIn 帖子到个人资料和群组
If
Code
Limit
+
If
Code
Limit
14 节点Yaron Been
人工智能
工作流信息
难度等级
中级
节点数量10
分类2
节点类型10
作者
explorium
@exploriumExplorium empowers businesses to build high-performance GTM agents with specialized data infrastructure. Our seamless API integrations and high-quality data drive faster agent development and better results. With years of experience and robust data sets, we deliver context-aware solutions, helping AI agents achieve human-level support. Explorium is the essential data partner for teams building agent-driven technologies.
外部链接
在 n8n.io 查看 →
分享此工作流