All templates

Automated Workiz Crew Route Optimization

Every morning, WebRun opens Workiz, pulls every job scheduled for the day with its address and appointment window, orders the stops into an efficient route per technician, logs the route order to a Google Sheet, and posts the digest to Slack before your crews leave the shop.

Runs on WebRun · Strict Lockdown policy
Every day at 6:30 AM WebRunorchestrates each step
1 Workiz pull today's scheduled jobs
2 Google Sheets log the optimized route order
3 Slack post the route digest to the crew
In short

How do I optimize my duct cleaning crew's daily route every morning?

Every morning, WebRun opens Workiz, pulls every job scheduled for the day with its address and appointment window, and orders each technician's stops to minimize drive time around any fixed windows. It logs the route to a Google Sheet and posts each crew's digest to Slack, so technicians leave the shop with an efficient plan already built.

  • Crews leave with an ordered stop list instead of figuring out the route on the fly
  • Drive time drops because stops are ordered around fixed appointment windows
  • Dispatchers spot an overloaded technician before the day starts, not halfway through it

Built for air duct cleaning companies · field service dispatchers · multi crew HVAC operators · residential service fleets

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens app.workiz.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Workiz - pull today's scheduled jobs
    workiz.com
    WebRun in Workiz: pull today's scheduled jobs
    WebRun opens Workiz to pull today's scheduled jobs.
    • Open Workiz and pull every job scheduled for today with its address, appointment window, and assigned technician
    • Group jobs by technician
    • Note any job with a fixed early or late appointment window

    Done when Every job scheduled for today is listed with its address and assigned technician.

  3. 2
    Google Sheets - log the optimized route order
    google.com
    WebRun in Google Sheets: log the optimized route order
    WebRun opens Google Sheets to log the optimized route order.
    • Open today's route sheet and order each technician's stops by location and appointment window to minimize drive time
    • Anchor the route order around fixed early or late jobs
    • Log the final stop order with estimated drive times between jobs

    Done when Today's route sheet reflects an ordered stop list for every technician.

  4. 3
    Slack - post the route digest to the crew
    slack.com
    WebRun in Slack: post the route digest to the crew
    WebRun opens Slack to post the route digest to the crew.
    • Post each technician's route digest to their crew channel
    • List stops in order with address, appointment window, and estimated arrival time
    • Flag any technician with an unusually heavy or light load for the day

    Done when Every technician has today's ordered route digest in Slack before leaving the shop.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.workiz.com
ScheduleRuns automatically on this cadence
Every day at 6:30 AM
DeliveryHow each run's result reaches you
Route digest · Slack
OutputWhat each run produces - A Google Sheet with each technician's optimized stop order and a Slack digest of the day's route per crew.
Spreadsheet + alert
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Does this change any customer facing appointment times?

No. It only reorders the sequence of stops within the appointment windows already booked in Workiz. No customer is contacted or rescheduled as part of this digest.

How does it handle a job with a fixed early or late window?

It anchors the route around any fixed appointment first, then fits the remaining stops around it to minimize drive time for the rest of the day.

Can it flag if one technician has too much on their plate?

Yes. It flags an unusually heavy or light stop count in the Slack digest, so you can rebalance the day across your crews before anyone leaves the shop.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.