Daily route delivery predictor

Dispatchers find out a route is running late when the driver is already late.

A workflow that reads the day's routes from a spreadsheet, runs two sequential analysis passes over the same data to assess cumulative delay risk, and sends either a delay alert or an all-clear summary based on configured thresholds.

Demonstrates threshold-based operational alerting over route data. Built against sample routes.

• Workflow design
• Prompt engineering
• Evaluation & testing

1. 01Routes are read from a spreadsheet at a scheduled time.
2. 02A first pass assesses each stop; a second pass reasons over the accumulated risk across the route.
3. 03Output is routed to either a delay alert or an all-clear summary depending on the threshold.

Make.com scenario with a scheduled Sheets read, two sequential Gemini analysis steps, and a router that selects the outbound message.

• Sample route data, not live telematics or traffic feeds.
• Thresholds are configured, not learned from historical delay outcomes.