Skip to the content.

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

  1. Add technicians with skills, work hours and max hours per day.
  2. Enter jobs with a time window, address, estimated hours and priority.
  3. Assign a technician and a stop order, then check the Day Board for capacity and conflicts.
  4. 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.

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.

All free templates