# Extract flight data from emails and calculate CO2 emissions in Google Sheets
This workflow automates the collection of business trip data and calculates its environmental impact. It triggers on receiving a flight confirmation email in Gmail, uses AI to extract structured information, and logs CO2 emissions and flight details directly into Google Sheets—eliminating manual entry.
## Who it´s for
- Companies tracking the carbon footprint of business travel
- Sustainability managers in corporations
- Travel administrators automating flight logging
- Environmental auditors with access to corporate email
## What the automation does
- Triggers on new Gmail message with a trip confirmation
- Uses an AI agent (GPT-4o-mini) to extract traveler name, flights, dates, airports, and booking details
- Splits multi-leg trips into individual flight segments
- Calculates CO2 emissions per segment using CarbonInterface API
- Logs departure/arrival airports, distance, CO2 volume, timestamp, and employee name in Google Sheets
## What´s included
- Ready-to-use n8n workflow with LangChain and HTTP API
- Trigger and processing logic based on Gmail messages
- Integrations with Gmail, Google Sheets, CarbonInterface API, and OpenAI
- Basic textual instructions for deployment and adaptation
## Requirements for setup
- n8n account with workflow execution access
- Gmail account with read permissions
- CarbonInterface API key
- OpenAI API key (for GPT-4o-mini)
- Google Sheets access for data logging
## Benefits and outcomes
- Eliminates manual data entry for flights
- Enables continuous data collection for ESG reporting
- Improves accuracy of CO2 tracking through automated parsing
- Centralizes business travel data in a single sheet
- Reduces workload for HR and admin staff
- Simplifies preparation of sustainability reports
## 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