私のワークフロー6
中級
これはSales, AI分野の自動化ワークフローで、10個のノードを含みます。主にIf, Code, GoogleSheets, SplitInBatches, Agentなどのノードを使用、AI技術を活用したスマート自動化を実現。 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": "有効行のフィルタリング",
"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": "項目のループ処理",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1020,
165
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "3870bad2-9551-4c1d-93bd-c42c44ce9584",
"name": "AIエージェント",
"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": "コード - 出力フォーマット",
"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": "企業行の更新",
"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": "付箋ノート",
"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": "出力パーサー",
"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
営業
リード generationワークフロー：YelpおよびTrustpilotのクローリングにBrightDataを使用し、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で表示 →
このワークフローを共有