ゾルタリフォルシュング V2
中級
これはDocument Extraction, Multimodal AI分野の自動化ワークフローで、14個のノードを含みます。主にSet, Gmail, Aggregate, HttpRequest, GoogleSheetsなどのノードを使用。 Googleシートと関税APIによるHS項目コードクエリーとエンチッチメントの自動化
前提条件
- •Googleアカウント + Gmail API認証情報
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "LdR1WNr3yM5Lw9X8",
"meta": {
"instanceId": "509eaff0b96002e800c9adf0e9388b12a38c09e15983331392a1f621addc4db4"
},
"name": "Customs_Tariff_Number_Research V2",
"tags": [],
"nodes": [
{
"id": "ec7c3dd9-74ee-4008-b32c-da57d6069e30",
"name": "チャットトリガー",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
-336,
336
],
"webhookId": "170756e8-3be9-43f5-81ce-284e8cf78635",
"parameters": {
"options": {}
},
"typeVersion": 1.1
},
{
"id": "0f817acd-9c17-4756-90ba-ff1106edad53",
"name": "Customs Tariff API Query",
"type": "n8n-nodes-base.httpRequest",
"position": [
-144,
336
],
"parameters": {
"url": "=https://www.zolltarifnummern.de/api/v2/cnSuggest?term={{ encodeURIComponent($json.chatInput) }}&lang=de",
"options": {
"timeout": 10000,
"response": {
"response": {
"responseFormat": "json"
}
},
"allowUnauthorizedCerts": true
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Accept",
"value": "application/json"
},
{
"name": "User-Agent",
"value": "n8n-workflow/1.0"
}
]
}
},
"typeVersion": 4.2,
"continueOnFail": true
},
{
"id": "8d670dda-9b23-4542-bb8f-ce7074beac64",
"name": "関税番号出力",
"type": "n8n-nodes-base.set",
"position": [
48,
336
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "assignment-1",
"name": "text",
"type": "string",
"value": "={{ $json.suggestions[1].code }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "9b92a873-ecb8-43cc-929f-9514bed35c5e",
"name": "商品説明読み取り",
"type": "n8n-nodes-base.googleSheets",
"position": [
128,
560
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nJ_VAeCwOnFwF-t7rFlbftbkAuT35gig9d7YCGsurHs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nJ_VAeCwOnFwF-t7rFlbftbkAuT35gig9d7YCGsurHs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nJ_VAeCwOnFwF-t7rFlbftbkAuT35gig9d7YCGsurHs/edit?usp=drivesdk",
"cachedResultName": "Customs Numbers"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "axR2eMzXvoqKjDp2",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "f95221b2-9d6d-4dd2-bd22-7faab04341f9",
"name": "アイテムループ処理",
"type": "n8n-nodes-base.splitInBatches",
"position": [
384,
560
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "60ddfdb2-b326-4cae-bc20-10cf2631a6ae",
"name": "関税番号をシートに書き込み",
"type": "n8n-nodes-base.googleSheets",
"position": [
992,
576
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "Artikelbeschreibung",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Artikelbeschreibung",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Zolltarifnummer",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Zolltarifnummer",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"Artikelbeschreibung"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nJ_VAeCwOnFwF-t7rFlbftbkAuT35gig9d7YCGsurHs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1nJ_VAeCwOnFwF-t7rFlbftbkAuT35gig9d7YCGsurHs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1nJ_VAeCwOnFwF-t7rFlbftbkAuT35gig9d7YCGsurHs/edit?usp=drivesdk",
"cachedResultName": "Customs Numbers"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "axR2eMzXvoqKjDp2",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "9b5f275d-136a-4227-9a62-120bc32e0c0e",
"name": "Customs Tariff API Query バッチ処理",
"type": "n8n-nodes-base.httpRequest",
"position": [
592,
576
],
"parameters": {
"url": "=https://www.zolltarifnummern.de/api/v2/cnSuggest?term={{ encodeURIComponent($json['Artikelbeschreibung']) }}&lang=de",
"options": {
"timeout": 10000,
"response": {
"response": {
"responseFormat": "json"
}
},
"allowUnauthorizedCerts": true
},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Accept",
"value": "application/json"
},
{
"name": "User-Agent",
"value": "n8n-workflow/1.0"
}
]
}
},
"typeVersion": 4.2,
"continueOnFail": true
},
{
"id": "653ef025-1c47-4115-94f3-867138e1f654",
"name": "完了メール送信",
"type": "n8n-nodes-base.gmail",
"position": [
784,
352
],
"webhookId": "efe6ce0f-0470-4be7-9056-af5752cf2798",
"parameters": {
"sendTo": "test@example.com",
"message": "Job completed successfully",
"options": {},
"subject": "Completed: Customs Tariff Number Research Finished"
},
"credentials": {
"gmailOAuth2": {
"id": "a26hQ5L1HIRZTOqY",
"name": "Gmail account"
}
},
"typeVersion": 2.1
},
{
"id": "b02dc4a3-b4e0-4bb1-9d8a-112ac0301b87",
"name": "データ集計",
"type": "n8n-nodes-base.aggregate",
"position": [
560,
352
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "bb6f42bd-de6e-4adb-97d2-b89867709d5c",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-384,
256
],
"parameters": {
"color": 6,
"width": 640,
"height": 256,
"content": "## Manual Single Query for Customs Tariff Number\nEnter item description and receive suggestion #1 from the API query"
},
"typeVersion": 1
},
{
"id": "6229ef15-b823-48f2-82bb-f81d07f7f976",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-384,
528
],
"parameters": {
"width": 1552,
"height": 256,
"content": "## Batch Query from List\nAll entries in column A \nwill be enriched with customs \ntariff numbers in column B\n(select Google Sheet and tab)"
},
"typeVersion": 1
},
{
"id": "7c9e9844-9995-41d6-9ec2-db4a3af10160",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
272,
256
],
"parameters": {
"color": 4,
"width": 896,
"height": 256,
"content": "## Completion\nNotification email that process \nis finished (configure desired email address)"
},
"typeVersion": 1
},
{
"id": "18289af3-a07a-46ef-abed-10d4bc6aec29",
"name": "検索開始",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-48,
560
],
"parameters": {},
"typeVersion": 1
},
{
"id": "31ef430b-a463-4742-bf36-57509464a684",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-816,
256
],
"parameters": {
"color": 3,
"width": 416,
"height": 256,
"content": "### [Video Tutorial](https://youtu.be/UccIqmMmq7w)\n@[youtube](UccIqmMmq7w)"
},
"typeVersion": 1
},
{
"id": "18d3e9ef-6168-482f-bcd7-d05ae1789975",
"name": "データ準備",
"type": "n8n-nodes-base.set",
"position": [
800,
576
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "assignment-1",
"name": "Zolltarifnummer",
"type": "string",
"value": "={{ $json.suggestions && $json.suggestions[1] ? $json.suggestions[1].code : 'Nicht gefunden' }}"
},
{
"id": "assignment-3",
"name": "Artikelbeschreibung",
"type": "string",
"value": "={{ $('Loop Over Items').item.json['Artikelbeschreibung'] }}"
},
{
"id": "bb2fbbce-b66b-42b6-a639-baa949b763e8",
"name": "Beschreibung der Zolltarifnummer",
"type": "string",
"value": "={{ $json.suggestions[1].value.split(/<br\\s*\\/?>/i)[1].trim() }}"
},
{
"id": "f4389d75-a1f3-4ccd-9a62-0f7544923e02",
"name": "Score",
"type": "string",
"value": "={{ ($json.suggestions[1].score * 100).toFixed(1) + '%' }}"
}
]
}
},
"typeVersion": 3.4
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "7e35bde7-5057-41a1-a1a9-e332db984cff",
"connections": {
"b02dc4a3-b4e0-4bb1-9d8a-112ac0301b87": {
"main": [
[
{
"node": "653ef025-1c47-4115-94f3-867138e1f654",
"type": "main",
"index": 0
}
]
]
},
"18289af3-a07a-46ef-abed-10d4bc6aec29": {
"main": [
[
{
"node": "9b92a873-ecb8-43cc-929f-9514bed35c5e",
"type": "main",
"index": 0
}
]
]
},
"ec7c3dd9-74ee-4008-b32c-da57d6069e30": {
"main": [
[
{
"node": "0f817acd-9c17-4756-90ba-ff1106edad53",
"type": "main",
"index": 0
}
]
]
},
"18d3e9ef-6168-482f-bcd7-d05ae1789975": {
"main": [
[
{
"node": "60ddfdb2-b326-4cae-bc20-10cf2631a6ae",
"type": "main",
"index": 0
}
]
]
},
"f95221b2-9d6d-4dd2-bd22-7faab04341f9": {
"main": [
[
{
"node": "b02dc4a3-b4e0-4bb1-9d8a-112ac0301b87",
"type": "main",
"index": 0
}
],
[
{
"node": "9b5f275d-136a-4227-9a62-120bc32e0c0e",
"type": "main",
"index": 0
}
]
]
},
"9b92a873-ecb8-43cc-929f-9514bed35c5e": {
"main": [
[
{
"node": "f95221b2-9d6d-4dd2-bd22-7faab04341f9",
"type": "main",
"index": 0
}
]
]
},
"0f817acd-9c17-4756-90ba-ff1106edad53": {
"main": [
[
{
"node": "8d670dda-9b23-4542-bb8f-ce7074beac64",
"type": "main",
"index": 0
}
]
]
},
"60ddfdb2-b326-4cae-bc20-10cf2631a6ae": {
"main": [
[
{
"node": "f95221b2-9d6d-4dd2-bd22-7faab04341f9",
"type": "main",
"index": 0
}
]
]
},
"9b5f275d-136a-4227-9a62-120bc32e0c0e": {
"main": [
[
{
"node": "18d3e9ef-6168-482f-bcd7-d05ae1789975",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - 文書抽出, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
AI-Deepseek-R1t を用いた会議交通費精算申請と旅費承認
Deepseek AI、Gmail、Google Sheetsを使った会議出張承認の自動化
If
Set
Code
+
If
Set
Code
24 ノードCheng Siong Chin
文書抽出
OpenRouter経由でClaude 3.7を使用してLinkedInデータに基づくパーソナライズされたセールスメールの生成
OpenRouterを通じてLinkedInデータを使い、Claude 3.7でパーソナライズされたセールスメールを作成
If
Set
Gmail
+
If
Set
Gmail
23 ノードAdam Janes
リードナーチャリング
PDF から注文へ
AIを使ってPDFの購入注文をAdobe Commerceの販売注文に自動変換する
If
Set
Code
+
If
Set
Code
96 ノードJKingma
文書抽出
n8nノードの探索（可視化リファレンスライブラリ内）
n8nノードを可視化リファレンスライブラリで探索
If
Ftp
Set
+
If
Ftp
Set
113 ノードI versus AI
その他
GPT-5 Mini、Jira、そしてフォームインターフェースを使った敏捷開発プロジェクト設定の自動化
GPT-5 Mini、Jira、そしてフォームインターフェースを使った敏捷なプロジェクトセットアップの自動化
Set
Jira
Gmail
+
Set
Jira
Gmail
42 ノードBilly Christi
マルチモーダルAI
リランキング #1
ウェブスクレイピング、GPT-4o、WhatsAppを使用した电话営業の自動化
Set
Code
Webhook
+
Set
Code
Webhook
48 ノードKhaisa Studio
リードナーチャリング
