🚚 Berechnung von CO2-Emissionen für Fracht mit Carbon Interface API und GPT-4o
Fortgeschritten
Dies ist ein AI, IT Ops-Bereich Automatisierungsworkflow mit 10 Nodes. Hauptsächlich werden HttpRequest, GmailTrigger, GoogleSheets, Agent, LmChatOpenAi und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung. 🚚 Berechnung des CO2-Ausstoffs von Fracht mit Carbon Interface API und GPT-4o
Voraussetzungen
- •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
- •Google-Konto + Gmail API-Anmeldedaten
- •Google Sheets API-Anmeldedaten
- •OpenAI API Key
Verwendete Nodes (10)
Kategorie
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
"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": "Gmail-Trigger",
"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": "KI-Agent 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": "OpenAI-Chat-Modell2",
"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": "Haftnotiz1",
"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": "Haftnotiz2",
"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": "Haftnotiz",
"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
}
]
]
}
}
}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
✈️ 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
🤖🚚 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
🉑 Generieren von Sprachlern-Anki-Karten mit Google Translate und GPT-4o
🉑 Generieren von Sprachlern-Anki-Flashcards mit Google Translate und GPT-4o
If
Set
Merge
+
If
Set
Merge
21 NodesSamir Saci
Sonstiges
🗞️ KI-gestützte Nachhaltigkeits-Marketing-Briefing (mit Gmail, GPT-4o)
🗞️ KI-gesteuertes Nachhaltigkeits-Marketing-Briefing (mit Gmail, GPT-4o)
If
Set
Code
+
If
Set
Code
21 NodesSamir Saci
Künstliche Intelligenz
🛻 Logistikbestellungsbehandlungs-KI-Agent (GPT-4o, Gmail und Google Sheet)
🛻 Logistikbestellverarbeitung KI-Agent (GPT-4o, Gmail und Google Sheets)
If
Code
Gmail Trigger
+
If
Code
Gmail Trigger
11 NodesSamir Saci
Vertrieb
AI Email Triage & Alert System with GPT-4 and Telegram Notifications
If
Set
Gmail
+
If
Set
Gmail
104 NodesPeter Joslyn
Support
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes10
Kategorie2
Node-Typen7
Autor
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
Externe Links
Auf n8n.io ansehen →
Diesen Workflow teilen