Smart Route Planner
Optimizes travel routes for your Google Calendar with Google Maps.
Google Apps Script
Workspace
Built a Google Apps Script tool for a small appliance service business to improve technician scheduling. The add-on reads technician availability from Google Calendar and uses Google Maps drive-time estimates to suggest the best time slots for new jobs and generate an optimized stop order to reduce daily travel time.
Key features:
- Technician dropdown mapped to individual Google Calendars
- “Best slot” suggestions based on open gaps and estimated drive time
- Route optimization to reduce total daily travel
- Input validation and caching to improve reliability and speed