Free Google Sheets Dispatch Schedule
For an office that assigns several technicians a day and needs one screen showing who is booked, who is free and which jobs nobody has yet.
Open the template · Make a copy · Google Sheet, free, no sign-up
What is inside
| Tab | What it holds |
|---|---|
| Dashboard | Totals and views built from Jobs and Technicians, no typing needed. |
| Jobs | Columns Job ID, Date, Window start, Window end, Client name, Phone, Street, City, ZIP and 7 more. |
| Technicians | Columns Technician ID, Name, Phone, Skills or trade, Work start, Work end, Max hours per day and Active. |
| Day Board | Totals and views built from Jobs and Technicians, no typing needed. |
| Week | Totals and views built from Jobs and Technicians, no typing needed. |
| Settings | Your own dropdown lists (service, priority, status and active), so the choices match how you work. |
How to fill it in
- Add technicians with skills, work hours and max hours per day.
- Enter jobs with a time window, address, estimated hours and priority.
- Assign a technician and a stop order, then check the Day Board for capacity and conflicts.
- Send the route with the Google Maps link on each job.
A tip from the field
The Window overlap and Capacity alert columns catch double booking before the technician discovers it at the door.
Starter files
Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.
- Jobs (12 sample rows)
- Technicians (4 sample rows)
Related templates
- Free Google Sheets Scheduling Template
- Free Google Sheets Job Tracker
- Free Google Sheets Mileage Log
When you outgrow it
Smarfle has a drag and drop dispatch board, and the technician sees the change on their phone right away. See how it works on smarfle.com.