8
n8n Deutschamn8n.com

🚚 Fahrzeit und -distanz mit Open Route API schätzen

Fortgeschritten

Dies ist ein AI, IT Ops-Bereich Automatisierungsworkflow mit 9 Nodes. Hauptsächlich werden Set, Wait, HttpRequest, GoogleSheets, ManualTrigger und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung. 🚚 Schätzung von Logistik-Fahrzeit und -Entfernung mit Open Route API

Voraussetzungen
  • •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
  • •Google Sheets API-Anmeldedaten

Verwendete Nodes (9)

Set
Wait
StickyNote
HttpRequest
GoogleSheets
ManualTrigger
SplitInBatches

Kategorie

Künstliche Intelligenz
IT-Betrieb
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
React Flow
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in 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": "Elemente durchlaufen",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        420,
        -20
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "5a36857f-6b42-4a5b-af68-d2cfaf00ddd3",
      "name": "Ergebnisse extrahieren",
      "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 anfragen",
      "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": "Routen sammeln",
      "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": "Ergebnisse speichern",
      "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": "Notiz2",
      "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": "Bei Klick auf 'Workflow testen'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -160,
        -20
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "45b1dc8a-ed85-424f-89f6-656861b118b6",
      "name": "Notiz",
      "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 Sekunden",
      "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
          }
        ]
      ]
    }
  }
}
Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Fortgeschritten - Künstliche Intelligenz, IT-Betrieb

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.

Verwandte Workflows

🚛🗺️ Geocodierung für Logistik mit Open Route API und Google Sheets
🚛🗺️ Logistisches Geocoding mit Open Route API und Google Sheets
Set
Wait
Http Request
+
Set
Wait
Http Request
9 NodesSamir Saci
IT-Betrieb
🤖🚚 KI-Agent zur Verwaltung von Transportaufträgen basierend auf GPT-4o und Open Route API
🤖🚚 KI-Agent zur Verwaltung von Transportaufträgen basierend auf GPT-4o und Open Route API
Set
Wait
Gmail
+
Set
Wait
Gmail
26 NodesSamir Saci
Künstliche Intelligenz
✍️ SEO- und Größen-Auditor für Blog-Bilder (Ghost und Google Sheets)
✍️ Auditor für Blog-Bilder-SEO und -Dimensionen (Ghost und Google Tabellen)
Set
Code
Ghost
+
Set
Code
Ghost
15 NodesSamir Saci
Künstliche Intelligenz
🌳 EU-Grüne-Vorschriften-Tracker (GPT-4o, Google Sheets und Aufgaben)
🌳 EU-Grün-Dauernachverfolger mit GPT-4o, Google Tabellen und Aufgabenfunktionen
If
Set
Html
+
If
Set
Html
17 NodesSamir Saci
Sonstiges
🧑‍🦯 Barrierefreiheit von Websites mit GPT-4o und Google Tabellen verbessern
🧑‍🦯 Website-Barrierefreiheit mit GPT-4o und Google Tabellen verbessern
If
Set
Code
+
If
Set
Code
14 NodesSamir Saci
Produkt
✈️ Berechnung des CO2-Fußabdrucks von Geschäftsreisen mit CarbonInterface API und GPT-4o
✈️ Berechnung von CO2-Emissionen für Geschäftsreisen über Carbon Interface API und GPT-4o
Split Out
Http Request
Gmail Trigger
+
Split Out
Http Request
Gmail Trigger
12 NodesSamir Saci
Sonstiges
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes9
Kategorie2
Node-Typen7
Schwierigkeitsbeschreibung

Für erfahrene Benutzer, mittelkomplexe Workflows mit 6-15 Nodes

Autor
Samir Saci

Samir Saci

@samirsaci

Automation, 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

Externe Links
Auf n8n.io ansehen →

Diesen Workflow teilen

Kategorien

Multimodales KI
1540
Künstliche Intelligenz
1108
Content-Erstellung
695
KI-Zusammenfassung
516
Marketing
419
KI-Chatbot
251
Engineering
241
Marktforschung
203
Verschiedenes
193
Sonstiges
176
Vertrieb
162
IT-Betrieb
156
Dokumentenextraktion
147
KI RAG
146
Bausteine
144
Soziale Medien
137
Lead-Generierung
125
Persönliche Produktivität
117
DevOps
111
Personalwesen
101
Support
97
Lead-Pflege
87
Kundenbeziehungsmanagement
82
Finanzen
81
Produkt
77
Support-Chatbot
76
Design
70
Ticketverwaltung
67
Sicherheitsbetrieb
57
Rechnungsverarbeitung
53
Krypto-Handel
49
Dateiverwaltung
39
Projektmanagement
35
Internes Wiki
32

Kategorien: 34