Extract flight data from emails and calculate CO2 emiss

This workflow automates carbon footprint tracking for business travel: it extracts flight details from Gmail messages, calculates CO₂ emissions using AI and API calls, and stores structured results in Google Sheets. Enables accurate, hands-free data collection for ESG reporting and sustainability audits.

## Who it´s for
- Companies tracking carbon footprint of business trips
- Corporate sustainability managers
- Travel administrators automating flight logging
- Environmental auditors requiring precise emission data

## What the automation does
- Triggers on new Gmail message with travel confirmation
- Uses AI agent (GPT-4o-mini) to extract structured data: employee name, flights, dates, airports
- Splits itinerary into legs and processes each via CarbonInterface API
- Records and updates flight details, distance, transport type, and CO₂ output in Google Sheets
- Centralizes data for analysis and sustainability reporting

## What´s included
- Ready-to-use n8n workflow with LangChain and HTTP API
- Trigger and handler logic based on Gmail messages
- Integrations with Gmail, Google Sheets, OpenAI, and CarbonInterface API
- Basic text instructions for setup and adaptation

## Requirements for setup
- Gmail account with API access
- Google Sheets account with enabled API
- CarbonInterface API key
- OpenAI API key with access to GPT-4o-mini
- Configured n8n instance (cloud or self-hosted)

## Benefits and outcomes
- Fully automated collection of business travel data
- Accurate CO₂ emission calculations without manual input errors
- Ready-to-use data for annual sustainability reports
- Centralized database of employee flights
- Reduced workload for HR and admin staff
- Supports corporate ESG initiatives

## 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 в чате.