Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

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

  1. Gmail Trigger
  2. Structured Output Parser
  3. AI Agent Parser
  4. OpenAI Chat Model2
  5. Split Out
  6. Record Flights Information
  7. Loop Over Flights
  8. Collect CO2 Emissions
  9. Load Results

Similar automations