Library / Reports, Analytics & Dashboards
Reports, Analytics & Dashboards
Calculate Business Travel CO2 Emissions from Gmail with OpenAI
When a travel request email arrives, OpenAI extracts the flight details, Carbon Interface calculates CO2 emissions, and results are recorded in Google Sheets.
What it does
### 3. Record Shipment Request Information and fetch distance and driving time using Open Route API This starts by recording all the information parsed by the AI node. Then, we use the Open Route API to complete with geocoding data *(GPS Coordinates)* that will be used to fetch driving distance and time. #### How to setup? - Setup Carbone Interface API Credentials 1. Get your free API key: Carbon Interface API Documentation 2. Fill the API key in the HTTP request node - Load records in the Google Sheet Node: 1. Add your Google Sheet API credentials to access the Google Sheet file 2. Select the file using the list, an URL or an ID 3. Select the sheet in which you want to record your working sessions 4. Map the fields: traveler_name, trip_purpose, trip_id, hotel_booked, ground_transport_booked, flight_type, from, from_code, to, to_code, flight_date, flight_number, distance_km, carbon_kg, estimated_at Learn more about the Google Sheet Node Distance, carbon emissions and estimation time will be fetched from the Carbone Interface API.
The steps
- Gmail Trigger
- Structured Output Parser
- AI Agent Parser
- OpenAI Chat Model2
- Split Out
- Record Flights Information
- Loop Over Flights
- Collect CO2 Emissions
- Load Results
Similar automations
Reports, Analytics & DashboardsCalculate Freight Shipment CO2 Emissions from Gmail with OpenAI7 stepsMCP Servers & ToolsRead CO2 Measurements as an MCP Server3 stepsEmail AutomationReply to Travel Requests by Email with Ollama5 stepsLead Generation & EnrichmentExtract Company Data and Calculate ICP Score9 steps