work2026Internal tooling, evolving

Kørselsplaner route optimizer

Traffic-aware route optimizer built into Zoho CRM for driving plans.

work/2026

Overview

A ZRM ApS product adding real, traffic-aware route optimization to a custom Kørselsplaner module in Zoho CRM: an employee links stops and a time window, and a Deluge function calls Google's Route Optimization API through a self-hosted Cloud Run proxy to compute the optimal route, recreate calendar events in order, and write a Danish-language route report.

Built first for one staffing customer and designed to be redeployed per customer through configuration alone.

Highlights

  • Vehicle routing with time windows and a pinned-meeting constraint
  • Cloud Run proxy mints service account tokens, so no OAuth expiry
  • Auto-adjusts start time when a pinned meeting is unreachable
  • Human-readable route report plus a Google Maps link on the CRM record
  • Per-customer config with no code changes