🚚 Calcul de l'émission de CO2 des frets en utilisant l'API Carbon Interface et GPT-4o
Intermédiaire
Ceci est unAI, IT Opsworkflow d'automatisation du domainecontenant 10 nœuds.Utilise principalement des nœuds comme HttpRequest, GmailTrigger, GoogleSheets, Agent, LmChatOpenAi, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. 🚚 Calcul de l'émission de CO2 des frets avec l'API Carbon Interface et GPT-4o
Prérequis
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Compte Google et informations d'identification Gmail API
- •Informations d'identification Google Sheets API
- •Clé API OpenAI
Nœuds utilisés (10)
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
"id": "umOZqpde6cAUTL8F",
"meta": {
"instanceId": "",
"templateCredsSetupCompleted": true
},
"name": "🚚 CO2 Emissions of Freight Shipments with Carbon Interface API and GPT-4o",
"tags": [],
"nodes": [
{
"id": "dc20a34f-90ff-4f4e-a2f7-7b77abb92f4c",
"name": "Déclencheur Gmail",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-320,
415
],
"parameters": {
"simple": false,
"filters": {},
"options": {
"downloadAttachments": false
},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
}
},
"credentials": {
"gmailOAuth2": {
"id": "",
"name": ""
}
},
"notesInFlow": true,
"typeVersion": 1.2
},
{
"id": "984a0707-919c-4c67-b070-6b1caaea2946",
"name": "Structured Output Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
140,
600
],
"parameters": {
"jsonSchemaExample": "{\n \"shipment_number\": \"7894-PCB-654\",\n \"pickup_location\": \"Centre de Distribution Auchan\",\n \"pickup_address\": \"77 Rue Albert Garry, 94450 Limeil-Brévannes\",\n \"expected_pickup_time\": \"2024-09-24T09:00:00\",\n \"temperature_control\": \"Frozen\",\n \"destination_store_name\": \"Auchan Store 124\",\n \"destination_address\": \"43-45 Quai Jules Guesde, 94405 Vitry-sur-Seine\",\n \"expected_delivery_time\": \"2024-09-24T18:00:00\",\n \"driving_distance_km\": 9.61,\n \"estimated_transit_min\": 16.9,\n \"cargo_quantity\": 12,\n \"cargo_weight_tons\": 2.79\n}\n"
},
"typeVersion": 1.2
},
{
"id": "de58b711-25ef-42f7-a5ab-4bc1d20fd1fc",
"name": "Agent IA Parser",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-100,
415
],
"parameters": {
"text": "=Extract the structured shipment details from the following email:\n\n{{ $json.text }}\n",
"options": {
"systemMessage": "=You are a logistics assistant. When provided with the body of a shipment confirmation email, extract the following structured JSON object:\n\n{\n \"shipment_number\": string,\n \"pickup_location\": string,\n \"pickup_address\": string,\n \"expected_pickup_time\": string (ISO 8601, e.g. \"2024-09-24T09:00:00\"),\n \"temperature_control\": string,\n \"destination_store_name\": string,\n \"destination_address\": string,\n \"expected_delivery_time\": string (ISO 8601, e.g. \"2024-09-24T18:00:00\"),\n \"driving_distance_km\": number,\n \"estimated_transit_min\": number,\n \"cargo_quantity\": number,\n \"cargo_weight_tons\": number\n}\n\n- Extract **only** what’s listed.\n- Normalize dates and times to ISO 8601 format.\n- Remove units from numbers (e.g. 9.61 km → 9.61, 2.79 tons → 2.79).\n- Return only the JSON object. No additional explanation or text."
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.9
},
{
"id": "05ca643f-774c-40a5-843f-76790c42d433",
"name": "Modèle de chat OpenAI2",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-100,
620
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "fb16f384-e73f-4c3f-be72-24fede7b2760",
"name": "Collect CO2 Emissions",
"type": "n8n-nodes-base.httpRequest",
"position": [
680,
420
],
"parameters": {
"url": "https://www.carboninterface.com/api/v1/estimates",
"method": "POST",
"options": {},
"jsonBody": "={\n \"type\": \"shipping\",\n \"weight_value\": {{ $('AI Agent Parser').item.json.output.cargo_weight_tons * 1000000 }},\n \"weight_unit\": \"g\",\n \"distance_value\": {{ $('AI Agent Parser').item.json.output.driving_distance_km }},\n \"distance_unit\": \"km\",\n \"transport_method\": \"truck\"\n}\n",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer YOUR_API_KEY"
},
{
"name": "Content-Type",
"value": "application/json"
}
]
}
},
"notesInFlow": true,
"typeVersion": 4.2
},
{
"id": "82c2db80-9a3a-421b-ad27-097a713fc3c2",
"name": "Load Results",
"type": "n8n-nodes-base.googleSheets",
"position": [
920,
420
],
"parameters": {
"columns": {
"value": {
"co2_kg": "={{ $json.data.attributes.carbon_kg }}",
"shipment_number": "={{ $('AI Agent Parser').item.json.output.shipment_number }}",
"co2_estimation_time": "={{ $json.data.attributes.estimated_at }}"
},
"schema": [
{
"id": "shipment_number",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "shipment_number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pickup_location",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "pickup_location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pickup_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "pickup_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "expected_pickup_time",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "expected_pickup_time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "temperature_control",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "temperature_control",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "destination_store_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "destination_store_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "destination_address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "destination_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "expected_delivery_time",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "expected_delivery_time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "driving_distance_km",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "driving_distance_km",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "estimated_transit_min",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "estimated_transit_min",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "cargo_quantity",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "cargo_quantity",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "cargo_weight_tons",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "cargo_weight_tons",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "co2_kg",
"type": "string",
"display": true,
"required": false,
"displayName": "co2_kg",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "co2_estimation_time",
"type": "string",
"display": true,
"required": false,
"displayName": "co2_estimation_time",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"shipment_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 877993777,
"cachedResultUrl": "",
"cachedResultName": "CO2 emissions"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1NLNviRoVMEj2z78KiueruB5sd2CnvAb80DS7J2melVs",
"cachedResultUrl": "",
"cachedResultName": "Open Route Service"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "",
"name": ""
}
},
"notesInFlow": true,
"typeVersion": 4.6
},
{
"id": "94cd225d-1bc0-42b5-a466-7fad8b445e94",
"name": "Note adhésive1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-360,
-60
],
"parameters": {
"color": 7,
"width": 180,
"height": 820,
"content": "### 1. Workflow Trigger with Gmail Trigger\nThe workflow is triggered by a new email received in your Gmail mailbox dedicated to process **shipment records**.\n\n#### How to setup?\n- **Gmail Trigger Node:** set up your Gmail API credentials\n[Learn more about the Gmail Trigger Node](https://docs.n8n.io/integrations/builtin/trigger-nodes/n8n-nodes-base.gmailtrigger)\n"
},
"typeVersion": 1
},
{
"id": "3e4989f9-2ef4-4c60-98cc-d8b988162e54",
"name": "Note adhésive2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-60
],
"parameters": {
"color": 7,
"width": 440,
"height": 820,
"content": "### 2. AI Agent to trip schedule report\nThis node will analyze the content of an email to extract structured information about a **shipment**, including **pickup/delivery times**, **addresses**, **cargo weight**, and **driving distance**.\n\n#### How to setup?\n- **AI Agent with the Chat Model**:\n 1. Add a **chat model** with the required credentials *(Example: Open AI 4o-mini)*\n 2. Adapt the system prompt to the format of emails you expect to receive *(type of information included)*\n [Learn more about the AI Agent Node](https://docs.n8n.io/integrations/builtin/cluster-nodes/root-nodes/n8n-nodes-langchain.agent)\n"
},
"typeVersion": 1
},
{
"id": "7dc4dab6-2536-4373-b058-7487fc968c33",
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
300,
-60
],
"parameters": {
"color": 7,
"width": 1180,
"height": 820,
"content": "### 3. Record Shipment Request Information and fetch emissions using the Carbon Interface API \nThis starts by recording all the structured shipment information parsed by the AI Agent node. Then, we use the **Carbon Interface API** to estimate **CO₂ emissions** based on cargo weight, distance, and transportation method.\n\n#### How to setup?\n\n- **Setup Carbon Interface API Credentials** \n 1. Get your free API key: [Carbon Interface API Documentation](https://docs.carboninterface.com/#/) \n 2. Fill the API key in the HTTP Request node headers (`Bearer YOUR_API_KEY`)\n\n- **Load records into the Google Sheet Node** \n 1. Add your Google Sheets API credentials to access your sheet \n 2. Select the file using the list, a URL, or its ID \n 3. Select the sheet where you want to log your shipping emissions \n 4. Map the fields: \n **shipment_number**, **pickup_location**, **pickup_address**, **expected_pickup_time**, **temperature_control**, **destination_store_name**, **destination_address**, **expected_delivery_time**, **driving_distance_km**, **estimated_transit_min**, **cargo_quantity**, **cargo_weight_tons**, **weight_value_g**, **co2_kg**, **co2_estimation_time**\n\n> Distance and weight values will be used to calculate carbon emissions via the Carbon Interface API.\n\n"
},
"typeVersion": 1
},
{
"id": "a51645cd-d3fe-4c3f-a7af-9bdd31eb9242",
"name": "Record Shipment Information",
"type": "n8n-nodes-base.googleSheets",
"position": [
420,
420
],
"parameters": {
"columns": {
"value": {
"cargo_quantity": "={{ $json.output.cargo_quantity }}",
"pickup_address": "={{ $json.output.pickup_address }}",
"pickup_location": "={{ $json.output.pickup_location }}",
"shipment_number": "={{ $json.output.shipment_number }}",
"cargo_weight_tons": "={{ $json.output.cargo_weight_tons }}",
"destination_address": "={{ $json.output.destination_address }}",
"driving_distance_km": "={{ $json.output.driving_distance_km }}",
"temperature_control": "={{ $json.output.temperature_control }}",
"expected_pickup_time": "={{ $json.output.expected_pickup_time }}",
"estimated_transit_min": "={{ $json.output.estimated_transit_min }}",
"destination_store_name": "={{ $json.output.destination_store_name }}",
"expected_delivery_time": "={{ $json.output.expected_delivery_time }}"
},
"schema": [
{
"id": "shipment_number",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "shipment_number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pickup_location",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "pickup_location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pickup_address",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "pickup_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "expected_pickup_time",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "expected_pickup_time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "temperature_control",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "temperature_control",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "destination_store_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "destination_store_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "destination_address",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "destination_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "expected_delivery_time",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "expected_delivery_time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "driving_distance_km",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "driving_distance_km",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "estimated_transit_min",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "estimated_transit_min",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "cargo_quantity",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "cargo_quantity",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "cargo_weight_tons",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "cargo_weight_tons",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "co2_kg",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "co2_kg",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "co2_estimation_time",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "co2_estimation_time",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"shipment_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 877993777,
"cachedResultUrl": "",
"cachedResultName": "CO2 emissions"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": "Open Route Service"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "",
"name": ""
}
},
"notesInFlow": true,
"typeVersion": 4.6
}
],
"active": false,
"pinData": {
"AI Agent Parser": [
{
"json": {
"output": {
"cargo_quantity": 12,
"pickup_address": "77 Rue Albert Garry, 94450 Limeil-Brévannes",
"pickup_location": "Centre de Distribution Auchan",
"shipment_number": "7894-PCB-654",
"cargo_weight_tons": 3.79,
"destination_address": "43-45 Quai Jules Guesde, 94405 Vitry-sur-Seine",
"driving_distance_km": 9.61,
"temperature_control": "Frozen",
"expected_pickup_time": "2024-09-24T09:00:00",
"estimated_transit_min": 16.9,
"destination_store_name": "Auchan Store 124",
"expected_delivery_time": "2024-09-24T18:00:00"
}
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "844e09c0-2706-43da-bd53-6c211b68aafc",
"connections": {
"82c2db80-9a3a-421b-ad27-097a713fc3c2": {
"main": [
[]
]
},
"Gmail Trigger": {
"main": [
[
{
"node": "AI Agent Parser",
"type": "main",
"index": 0
}
]
]
},
"AI Agent Parser": {
"main": [
[
{
"node": "a51645cd-d3fe-4c3f-a7af-9bdd31eb9242",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model2": {
"ai_languageModel": [
[
{
"node": "AI Agent Parser",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"fb16f384-e73f-4c3f-be72-24fede7b2760": {
"main": [
[
{
"node": "82c2db80-9a3a-421b-ad27-097a713fc3c2",
"type": "main",
"index": 0
}
]
]
},
"984a0707-919c-4c67-b070-6b1caaea2946": {
"ai_outputParser": [
[
{
"node": "AI Agent Parser",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"a51645cd-d3fe-4c3f-a7af-9bdd31eb9242": {
"main": [
[
{
"node": "fb16f384-e73f-4c3f-be72-24fede7b2760",
"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 - Intelligence Artificielle, 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
✈️ Utiliser l'API CarbonInterface et GPT-4o pour calculer les émissions de CO2 des voyages d'affaires
✈️ viaCarbon Interface APIetGPT-4o计算商务旅行二氧化碳排放
Split Out
Http Request
Gmail Trigger
+
Split Out
Http Request
Gmail Trigger
12 NœudsSamir Saci
Autres
🤖🚚 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
🉑 Utiliser Google Translate et GPT-4o pour générer des cartes flash de langage d'apprentissage Anki
🉑 utilisationGoogle TranslateetGPT-4ogénération语言学习Anki闪卡
If
Set
Merge
+
If
Set
Merge
21 NœudsSamir Saci
Autres
🗞️ Brief marketing de durabilité piloté par l'IA (utilise Gmail, GPT-4o)
🗞️ Brief marketing durable IA (utilisant Gmail, GPT-4o)
If
Set
Code
+
If
Set
Code
21 NœudsSamir Saci
Intelligence Artificielle
🛻 Agent IA pour le traitement des commandes logistiques (GPT-4o, Gmail et Google Sheet)
🛻 Agent IA pour le traitement des commandes logistiques (GPT-4o, Gmail et Google Sheet)
If
Code
Gmail Trigger
+
If
Code
Gmail Trigger
11 NœudsSamir Saci
Ventes
AIe-mail分诊与GPT-4警报系统及Telegramnotification
AIe-mail分诊与GPT-4警报系统及Telegramnotification
If
Set
Gmail
+
If
Set
Gmail
104 NœudsPeter Joslyn
Support
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds10
Catégorie2
Types de nœuds7
Description de la difficulté
Auteur
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
Liens externes
Voir sur n8n.io →
Partager ce workflow