Content: 02599.zip (41.94 KB)
Uploaded: 15.01.2026

Positive responses: 0
Negative responses: 0

Sold: 0
Refunds: 0

$6.95
# Extract shipment data from emails and calculate CO₂ emissions in Google Sheets

This automation extracts freight details from shipment confirmation emails in Gmail, calculates CO₂ emissions using the Carbon Interface API, and logs all data into Google Sheets. Designed for logistics and sustainability teams needing accurate, automated carbon tracking without manual input.

## Who it´s for
- Logistics companies tracking carbon footprint of shipments
- Environmental managers in retail with supply chains
- Sustainability specialists preparing ESG reports
- Transport operators using email confirmations for dispatch tracking

## What the automation does
- Triggers on new Gmail messages containing shipment confirmations
- Uses an AI agent (GPT-4o-mini) to parse unstructured email text and extract structured data: pickup/delivery addresses, cargo weight, distance
- Sends extracted data to Carbon Interface API to calculate CO₂ emissions
- Logs original message content, parsed fields, and emission results into Google Sheets
- Enables centralized, audit-ready recordkeeping for environmental reporting

## What´s included
- Ready-to-use n8n workflow with LangChain and HTTP API components
- Trigger logic for new Gmail messages
- Pre-built integrations with Gmail, Carbon Interface API, and Google Sheets
- Basic textual instructions for deployment and adaptation

## Requirements for setup
- n8n instance (cloud or self-hosted)
- Gmail account with read access permissions
- Valid API key for Carbon Interface
- Google Sheets access for data logging
- Properly configured credentials in n8n for all connected services

## Benefits and outcomes
- Eliminates manual data entry from shipping emails
- Accelerates ESG and sustainability reporting cycles
- Ensures calculation accuracy via standardized API methodology
- Centralizes shipment and emission data in a structured format
- Scales seamlessly across hundreds of emails
- Supports corporate sustainability and net-zero goals

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet