8
n8n Françaisamn8n.com

🚛🗺️ Géocodage logistique en utilisant l'API Open Route et Google Sheets

Intermédiaire

Ceci est unIT Opsworkflow d'automatisation du domainecontenant 9 nœuds.Utilise principalement des nœuds comme Set, Wait, HttpRequest, GoogleSheets, ManualTrigger. 🚛🗺️ Géocodage logistique avec l'API Open Route et Google Sheets

Prérequis
  • •Peut nécessiter les informations d'identification d'authentification de l'API cible
  • •Informations d'identification Google Sheets API

Nœuds utilisés (9)

Set
Wait
StickyNote
HttpRequest
GoogleSheets
ManualTrigger
SplitInBatches

Catégorie

Opérations IT
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
React Flow
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "meta": {
    "instanceId": ""
  },
  "nodes": [
    {
      "id": "b1d00cd4-b9e8-4d84-b580-08368fbb9396",
      "name": "Note adhésive 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        20,
        -160
      ],
      "parameters": {
        "color": 7,
        "width": 540,
        "height": 640,
        "content": "### 1. Trigger the workflow\nThis starts by collecting all the addresses (with the country code) that need geocoding information.\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: **country**, **address** , **longitude**, **latitude**, **borough**, **neighbourhood**, **localadmin**\n  [Learn more about the Google Sheet Node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets)\n\nThe last five fields must be left empty as they will be filled with the API outputs.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "32f84996-0480-4c0b-aab7-3f5ebca9dd4e",
      "name": "Au clic sur 'Tester le workflow'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        60,
        260
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "fe628240-0550-42dd-a375-7ecba134fd6c",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        600,
        -160
      ],
      "parameters": {
        "color": 7,
        "width": 1120,
        "height": 640,
        "content": "### 2. Loop to collect GPS coordinates\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- **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. List the fields to update: **longitude**, **latitude**, **borough**, **neighbourhood**, **localadmin**\n  [Learn more about the Google Sheet Node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets)\n"
      },
      "typeVersion": 1
    },
    {
      "id": "eac06796-f40d-4c94-96b2-4ad672053295",
      "name": "Collecter les adresses",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        340,
        260
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1232640606,
          "cachedResultUrl": "",
          "cachedResultName": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "",
          "cachedResultName": ""
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.6
    },
    {
      "id": "13198c2c-cdca-4a5e-893a-1fac24090f33",
      "name": "Interroger Open Route API",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        960,
        280
      ],
      "parameters": {
        "url": "https://api.openrouteservice.org/geocode/search",
        "options": {},
        "sendQuery": true,
        "sendHeaders": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "api_key"
            },
            {
              "name": "text",
              "value": "={{ $json.address }}"
            },
            {
              "name": "boundary.country",
              "value": "={{ $json.country }}"
            },
            {
              "name": "sources",
              "value": "openstreetmap"
            },
            {
              "name": "size",
              "value": "1"
            }
          ]
        },
        "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": "d0ad6f7e-8049-45c4-8022-8c16a8f71392",
      "name": "Boucler sur les adresses",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        760,
        260
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "c84f27c6-3905-455a-b8a7-bb1d6bffafe0",
      "name": "Sauvegarder les résultats",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1380,
        280
      ],
      "parameters": {
        "columns": {
          "value": {
            "id": "={{ $('Loop Over Addresses').item.json.id }}",
            "borough": "={{ $json.borough }}",
            "latitude": "={{ $json.latitude }}",
            "longitude": "={{ $json.longitude }}",
            "localadmin": "={{ $json.localadmin }}",
            "neighbourhood": "={{ $json.neighbourhood }}"
          },
          "schema": [
            {
              "id": "id",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "id",
              "defaultMatch": true,
              "canBeUsedToMatch": true
            },
            {
              "id": "country",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "country",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "address",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "address",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "longitude",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "longitude",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "latitude",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "latitude",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "borough",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "borough",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "neighbourhood",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "neighbourhood",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "localadmin",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "localadmin",
              "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": 1232640606,
          "cachedResultUrl": "",
          "cachedResultName": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "",
          "cachedResultName": ""
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.6
    },
    {
      "id": "6fa85604-4db7-431d-b0fd-b6cbb1773c12",
      "name": "Extraire les résultats",
      "type": "n8n-nodes-base.set",
      "position": [
        1180,
        280
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "e4c92077-f294-4e49-8276-20d1441c0c2c",
              "name": "longitude",
              "type": "string",
              "value": "={{ $json.features[0].geometry.coordinates[0] }}"
            },
            {
              "id": "899e5304-e7a1-4ce1-bf9a-f403d74934fb",
              "name": "latitude",
              "type": "string",
              "value": "={{ $json.features[0].geometry.coordinates[1] }}"
            },
            {
              "id": "5b35642b-dda4-42b8-b7bb-1275616bfb59",
              "name": "borough",
              "type": "string",
              "value": "={{ $json.features[0].properties.borough }}"
            },
            {
              "id": "aa74bd9a-f543-48e1-a69b-0e6472bda053",
              "name": "neighbourhood",
              "type": "string",
              "value": "={{ $json.features[0].properties.neighbourhood }}"
            },
            {
              "id": "7f303dc8-4e28-4d46-8e3e-9db00dbcac3a",
              "name": "localadmin",
              "type": "string",
              "value": "={{ $json.features[0].properties.localadmin }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "71c85728-f291-4a67-8d0d-8c7fcd38905d",
      "name": "5 secondes",
      "type": "n8n-nodes-base.wait",
      "position": [
        1560,
        280
      ],
      "webhookId": "6ecebf96-14ed-4c7b-b467-eb48c143408e",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "7ca2b5ea-9af8-425d-958e-2f6ffe01656e",
      "name": "Note adhésive 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        20,
        500
      ],
      "parameters": {
        "width": 580,
        "height": 380,
        "content": "### [Check the Tutorial](https://www.youtube.com/watch?v=IlblIlKcL0k)\n![Thumbnail](https://www.samirsaci.com/content/images/2025/06/image-10.png)"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "71c85728-f291-4a67-8d0d-8c7fcd38905d": {
      "main": [
        [
          {
            "node": "d0ad6f7e-8049-45c4-8022-8c16a8f71392",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c84f27c6-3905-455a-b8a7-bb1d6bffafe0": {
      "main": [
        [
          {
            "node": "71c85728-f291-4a67-8d0d-8c7fcd38905d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6fa85604-4db7-431d-b0fd-b6cbb1773c12": {
      "main": [
        [
          {
            "node": "c84f27c6-3905-455a-b8a7-bb1d6bffafe0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "eac06796-f40d-4c94-96b2-4ad672053295": {
      "main": [
        [
          {
            "node": "d0ad6f7e-8049-45c4-8022-8c16a8f71392",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d0ad6f7e-8049-45c4-8022-8c16a8f71392": {
      "main": [
        [],
        [
          {
            "node": "13198c2c-cdca-4a5e-893a-1fac24090f33",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "13198c2c-cdca-4a5e-893a-1fac24090f33": {
      "main": [
        [
          {
            "node": "6fa85604-4db7-431d-b0fd-b6cbb1773c12",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "32f84996-0480-4c0b-aab7-3f5ebca9dd4e": {
      "main": [
        [
          {
            "node": "eac06796-f40d-4c94-96b2-4ad672053295",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Intermédiaire - Opérations IT

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.

Workflows recommandés

🚚 Estimation du temps de conduite et de la distance en utilisant l'API Open Route
🚚 Estimation du temps et de la distance de conduite logistique avec l'API Open Route
Set
Wait
Http Request
+
Set
Wait
Http Request
9 NœudsSamir Saci
Intelligence Artificielle
🤖🚚 Agent IA de gestion des commandes de transport basé sur GPT-4o et Open Route API
🤖🚚 Agent IA pour la gestion des commandes de transport basé sur GPT-4o et Open Route API
Set
Wait
Gmail
+
Set
Wait
Gmail
26 NœudsSamir Saci
Intelligence Artificielle
Modèle Google Calendar vers Sheets v1.0
Synchroniser automatiquement les événements Google Calendar avec un suivi Google Sheets
If
Set
Code
+
If
Set
Code
20 NœudsAlex Halfborg
Opérations IT
✍️ Audit SEO et de taille des images de blog (Ghost et Google Sheets)
✍️ blog图片SEO与尺寸审计器（GhostetGoogle Sheets）
Set
Code
Ghost
+
Set
Code
Ghost
15 NœudsSamir Saci
Intelligence Artificielle
🌳 Suivi du règlement vert de l'UE (GPT-4o, Google Sheets et tâches)
🌳 utilisation GPT-4o、Google Sheets et任务功能de欧盟绿色法规追踪器
If
Set
Html
+
If
Set
Html
17 NœudsSamir Saci
Autres
🧑‍🦯 Amélioration de l'accessibilité du site Web en utilisant GPT-4o et Google Sheet
🧑‍🦯 Améliorer l'accessibilité du site Web avec GPT-4o et Google Sheets
If
Set
Code
+
If
Set
Code
14 NœudsSamir Saci
Produit
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds9
Catégorie1
Types de nœuds7
Description de la difficulté

Adapté aux utilisateurs expérimentés, avec des workflows de complexité moyenne contenant 6-15 nœuds

Auteur
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

Liens externes
Voir sur n8n.io →

Partager ce workflow

Catégories

IA Multimodale
1540
Intelligence Artificielle
1108
Création de contenu
695
Résumé IA
516
Marketing
419
Chatbot IA
251
Ingénierie
241
Étude de marché
203
Divers
193
Autres
176
Ventes
162
Opérations IT
156
Extraction de documents
147
RAG IA
146
Blocs de construction
144
Réseaux sociaux
137
Génération de leads
125
Productivité personnelle
117
DevOps
111
Ressources Humaines
101
Support
97
Nurturing de leads
87
CRM
82
Finance
81
Produit
77
Chatbot de support
76
Design
70
Gestion des tickets
67
Opérations de sécurité
57
Traitement des factures
53
Trading crypto
49
Gestion de fichiers
39
Gestion de projet
35
Wiki interne
32

Catégories: 34