🚚 Open Route APIを使用してドライブ時間と距離を推定
中級
これはAI, IT Ops分野の自動化ワークフローで、9個のノードを含みます。主にSet, Wait, HttpRequest, GoogleSheets, ManualTriggerなどのノードを使用、AI技術を活用したスマート自動化を実現。 🚚 Open Route APIを使用して物流のドライビング時間と距離を估算
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "xcH7MXYzo44y7L7X",
"meta": {
"instanceId": "",
"templateCredsSetupCompleted": true
},
"name": "🚚 Estimate Driving Time and Distance with Open Route API",
"tags": [],
"nodes": [
{
"id": "ce1b3c7f-315a-4714-b616-ecdd9804ee78",
"name": "アイテムのループ処理",
"type": "n8n-nodes-base.splitInBatches",
"position": [
420,
-20
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "5a36857f-6b42-4a5b-af68-d2cfaf00ddd3",
"name": "結果の抽出",
"type": "n8n-nodes-base.set",
"position": [
980,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "4d0acd1a-c049-4353-9fb7-8eb08c138b9c",
"name": "distance",
"type": "string",
"value": "={{ $json.features[0].properties.segments[0].distance }}"
},
{
"id": "2a6ff46a-f620-4dad-a60a-018b8add76d5",
"name": "duration",
"type": "string",
"value": "={{ $json.features[0].properties.segments[0].duration }}"
},
{
"id": "de20932f-4eb5-4372-ad6d-64679df104cb",
"name": "n_steps",
"type": "number",
"value": "={{ $json.features[0].properties.segments[0].steps.length }}"
},
{
"id": "540df5ea-cf63-47cc-8d63-3d6fcac825af",
"name": "",
"type": "string",
"value": ""
}
]
}
},
"notesInFlow": true,
"typeVersion": 3.4
},
{
"id": "39a779dd-455b-4502-b17f-8c86d6e47e45",
"name": "Open Route API へのリクエスト",
"type": "n8n-nodes-base.httpRequest",
"position": [
740,
0
],
"parameters": {
"url": "https://api.openrouteservice.org/v2/directions/driving-hgv",
"options": {
"response": {
"response": {
"responseFormat": "json"
}
}
},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "api_key",
"value": ""
},
{
"name": "start",
"value": "={{ $json.longitude_departure }}, {{ $json.latitude_departure }}"
},
{
"name": "end",
"value": "={{ $json.longitude_destination }}, {{ $json.latitude_destination }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/json; charset=utf-8"
},
{
"name": "Accept",
"value": "application/json, application/geo+json, application/gpx+xml, img/png; charset=utf-8"
}
]
}
},
"notesInFlow": true,
"typeVersion": 4.2
},
{
"id": "578e34fd-8804-454b-b6be-25d534eb4283",
"name": "ルートの収集",
"type": "n8n-nodes-base.googleSheets",
"position": [
60,
-20
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Distance"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1NLNviRoVMEj2z78KiueruB5sd2CnvAb80DS7J2melVs",
"cachedResultUrl": "",
"cachedResultName": "Open Route Service"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "",
"name": ""
}
},
"typeVersion": 4.6
},
{
"id": "89320458-8aa8-4faf-8009-0f65899762e1",
"name": "結果の保存",
"type": "n8n-nodes-base.googleSheets",
"position": [
1200,
0
],
"parameters": {
"columns": {
"value": {
"id": "={{ $('Loop Over Items').item.json.id }}",
"n_steps": "={{ $json.n_steps }}",
"distance": "={{ $json.distance }}",
"duration": "={{ $json.duration }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "city_departure",
"type": "string",
"display": true,
"required": false,
"displayName": "city_departure",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "longitude_departure",
"type": "string",
"display": true,
"required": false,
"displayName": "longitude_departure",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "latitude_departure",
"type": "string",
"display": true,
"required": false,
"displayName": "latitude_departure",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city_destination",
"type": "string",
"display": true,
"required": false,
"displayName": "city_destination",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "longitude_destination",
"type": "string",
"display": true,
"required": false,
"displayName": "longitude_destination",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "latitude_destination",
"type": "string",
"display": true,
"required": false,
"displayName": "latitude_destination",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "distance",
"type": "string",
"display": true,
"required": false,
"displayName": "distance",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "duration",
"type": "string",
"display": true,
"required": false,
"displayName": "duration",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "n_steps",
"type": "string",
"display": true,
"required": false,
"displayName": "n_steps",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": ""
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": ""
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "",
"name": ""
}
},
"notesInFlow": true,
"typeVersion": 4.6
},
{
"id": "7f83e93e-a759-4724-8978-5de0f565b17d",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-240,
-440
],
"parameters": {
"color": 7,
"width": 540,
"height": 640,
"content": "### 1. Trigger the workflow\nThis starts by collecting all the routes (Departure, Destination) that need distance and driving time by **truck**.\n\n#### How to setup?\n\n- **Load records in the Google Sheet Node**:\n 1. Add your Google Sheet API credentials to access the Google Sheet file\n 2. Select the file using the list, an URL or an ID\n 3. Select the sheet in which you want to record your working sessions\n 4. Map the fields: **city_departure**, **longitude_departure** , **latitude_departure**, **city_destination**, **longitude_destination**, **latitude_destination**, **distance**, **duration**, **n_steps**\n [Learn more about the Google Sheet Node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets)\n\nThe last three fields must be left empty as they will be filled with the API outputs.\n"
},
"typeVersion": 1
},
{
"id": "0dd453dd-2a7e-4039-a15d-2936a8ad4d44",
"name": "「ワークフローをテスト」クリック時",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-160,
-20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "45b1dc8a-ed85-424f-89f6-656861b118b6",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
340,
-440
],
"parameters": {
"color": 7,
"width": 1240,
"height": 640,
"content": "### 2. Loop to collect all driving distances and time \nThis starts by collecting all the routes (Departure, Destination) that need distance and driving time by **truck**.\n\n#### How to setup?\n- **Setup API Credentials**\n 1. Get your free API key: [Open Route API Documentation](https://openrouteservice.org/dev/#/api-docs)\n 2. Fill the API key in the HTTP request node\n 3. Select the driving mode (**driving-car**: individual truck) or (**driving-hgv**: commercial truck)\n- **Load records in the Google Sheet Node**:\n 1. Add your Google Sheet API credentials to access the Google Sheet file\n 2. Select the file using the list, an URL or an ID\n 3. Select the sheet in which you want to record your working sessions\n 4. Map the fields: **city_departure**, **longitude_departure**, **latitude_departure**, **city_destination**, **longitude_destination**, **latitude_destination**, **distance**, **duration**, **n_steps**\n [Learn more about the Google Sheet Node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets)\n\nThe last three fields must be left empty as they will be filled with the API outputs.\n"
},
"typeVersion": 1
},
{
"id": "11232056-fc3b-422c-b569-8a4fc9250633",
"name": "5秒",
"type": "n8n-nodes-base.wait",
"position": [
1420,
0
],
"webhookId": "1c5df276-94b5-42b8-9748-634e389cadcf",
"parameters": {},
"typeVersion": 1.1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "91a86656-7afe-4e84-921d-3361c4114016",
"connections": {
"11232056-fc3b-422c-b569-8a4fc9250633": {
"main": [
[
{
"node": "ce1b3c7f-315a-4714-b616-ecdd9804ee78",
"type": "main",
"index": 0
}
]
]
},
"89320458-8aa8-4faf-8009-0f65899762e1": {
"main": [
[
{
"node": "11232056-fc3b-422c-b569-8a4fc9250633",
"type": "main",
"index": 0
}
]
]
},
"578e34fd-8804-454b-b6be-25d534eb4283": {
"main": [
[
{
"node": "ce1b3c7f-315a-4714-b616-ecdd9804ee78",
"type": "main",
"index": 0
}
]
]
},
"5a36857f-6b42-4a5b-af68-d2cfaf00ddd3": {
"main": [
[
{
"node": "89320458-8aa8-4faf-8009-0f65899762e1",
"type": "main",
"index": 0
}
]
]
},
"ce1b3c7f-315a-4714-b616-ecdd9804ee78": {
"main": [
[],
[
{
"node": "39a779dd-455b-4502-b17f-8c86d6e47e45",
"type": "main",
"index": 0
}
]
]
},
"39a779dd-455b-4502-b17f-8c86d6e47e45": {
"main": [
[
{
"node": "5a36857f-6b42-4a5b-af68-d2cfaf00ddd3",
"type": "main",
"index": 0
}
]
]
},
"0dd453dd-2a7e-4039-a15d-2936a8ad4d44": {
"main": [
[
{
"node": "578e34fd-8804-454b-b6be-25d534eb4283",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - 人工知能, IT運用
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
🗺️ Open Route APIとGoogle Sheetsを使用した物流ジオコーディング
🗺️ Open Route APIとGoogle Sheetsを使用して物流のジオコーディングを行う
Set
Wait
Http Request
+
Set
Wait
Http Request
9 ノードSamir Saci
IT運用
🤖🚚 GPT-4o と Open Route API ベースの配送注文管理 AI エージェント
🤖🚚 GPT-4oとOpen Route APIに基づく配送注文管理AIエージェント
Set
Wait
Gmail
+
Set
Wait
Gmail
26 ノードSamir Saci
人工知能
✍️ブログ画像のSEOとサイズ監査ツール（GhostとGoogle Sheets）
✍️ ブログ画像SEOとサイズ監査ツール（GhostとGoogleスプレッドシート）
Set
Code
Ghost
+
Set
Code
Ghost
15 ノードSamir Saci
人工知能
🌳EUグリーン規制トラッカー（GPT-4o、Google Sheets、タスク）
🌳 GPT-4o、Google Sheets、タスク機能を使用したEUグリーン法規制トラッカー
If
Set
Html
+
If
Set
Html
17 ノードSamir Saci
その他
🧑🦯GPT-4oとGoogleスプレッドシートでウェブアクセシビリティを改善
🧑🦯GPT-4oとGoogleスプレッドシートでWebアクセシビリティを改善
If
Set
Code
+
If
Set
Code
14 ノードSamir Saci
プロダクト
✈️CarbonInterface APIとGPT-4oを使用してビジネス旅行の二酸化炭素排出量を計算
✈️ Carbon Interface APIとGPT-4oを使用してビジネス旅行の二酸化炭素排出量を計算
Split Out
Http Request
Gmail Trigger
+
Split Out
Http Request
Gmail Trigger
12 ノードSamir Saci
その他
ワークフロー情報
難易度
中級
ノード数9
カテゴリー2
ノードタイプ7
作成者
Samir Saci
@samirsaciAutomation, AI and Analytics for Supply Chain & Business Optimization Helping businesses streamline operations using n8n, AI agents, and data science to enhance efficiency and sustainability. Linkedin: www.linkedin.com/in/samir-saci
外部リンク
n8n.ioで表示 →
このワークフローを共有