Turn shipment request emails into instant delivery quotes

Reads shipment request emails, calculates driving distance and time, and sends the customer a confirmation automatically.

How the work actually flows

It branches. Every path runs.

Pattern: Parallel Split (2)

flowchart TD trig>"shipment request email arrives"]:::trig s0["AI extracts shipment details"]:::task s1["geocode pickup and delivery addresses"]:::svc s2["calculate driving distance and time"]:::svc trig --> s0 s0 --> s1 s1 --> s2 gx{"+ what to do with results"}:::gate s2 --> gx p00["log details to Google Sheet"]:::task gx -->|"log the record"| p00 p10["email customer a confirmation"]:::task gx -->|"send confirmation"| p10 p00 --> out p10 --> out out[/"customer receives instant shipment quote"/]:::out pay{{"faster quotes without manual work"}}:::pay out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepAn outside serviceEvery pathResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
AI Agents & Autonomous SystemsE-commerce & ProductEmail AutomationSpreadsheet & Database Ops
Connects
GmailGoogle SheetsOpenRouteServiceOpenAI

The problem it solves

A shipment request lands in your inbox and someone has to read it, figure out the pickup and delivery addresses, work out the driving distance and time, and then write back to confirm. When requests come in throughout the day, that manual back-and-forth slows down how fast you can respond to customers.

Who it fits

Small transportation companies or carriers that take delivery requests by email.

How it works

  1. A new email requesting a shipment arrives in Gmail
  2. An AI agent reads the email and pulls out the pickup, delivery, and contact details
  3. The addresses are converted into map coordinates
  4. OpenRouteService calculates the driving distance and time for a truck route
  5. The details are logged to a Google Sheet and a confirmation email is sent back to the customer
What you get

Shipment emails answered without touching a map

You get shipment request emails read automatically, with driving distance and time calculated and a confirmation sent straight back to the customer.

What you get

A logged shipment record and an automatic confirmation email with distance and estimated driving time.

What you need

A Gmail account, a Google Sheets account, an OpenRouteService API key, and an OpenAI API key.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Turn pickup request emails into optimized delivery routes

Reads pickup request emails, plans the best multi-stop route, and emails back a ready-to-use pickup plan.

Advanced

AI customer service agent for order tracking and support

Answers customer questions, tracks orders, and places new orders through a chat assistant that remembers each conversation.

Advanced

Automatically reconcile Stripe, bank, and store transactions

AI agents compare Stripe, bank, and store data, flag mismatches, and log corrections to a spreadsheet.

Advanced

Flag high-risk orders before refunds and chargebacks happen

Every new order is scored for refund and chargeback risk, with high-risk orders logged and flagged instantly.

Advanced
Back to the AI Playbook