# 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