Automated Dental Lab Delivery Route Planning
Every morning, WebRun opens Evident and collects all cases scheduled for delivery today, groups them by delivery zone using the driver route plan in Google Sheets, and posts a confirmed route sheet to Slack so drivers and dispatch know exactly which cases go to which practice and in what order before anyone leaves the lab.
How do I automatically plan and confirm dental lab delivery routes each morning?
Every morning before drivers leave, WebRun reads today's outbound cases from Evident, groups them by delivery zone using Google Sheets, and posts a sequenced route sheet to Slack. Urgent cases are flagged at the top of each zone so drivers can prioritize patient-appointment deliveries and every case reaches the right practice on time.
- Drivers start every day with a confirmed, sequenced route, not a guessed one
- Urgent cases are flagged at the top of the route so patient appointments are never missed
- Route history is logged in Google Sheets for tracking and zone optimization
Built for dental lab dispatch teams · dental lab drivers · dental laboratory operations managers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
www.evidentdigital.comin a real browser with your saved login - no setup, no API keys. -
1
Evident - read outbound cases for today
- Open Evident and navigate to the driver route planning section
- Collect all cases marked for outbound delivery today, with doctor name, practice address, and case type
- Flag any case marked urgent or with a patient appointment due today
Done when All outbound cases for the day are listed with their destination and priority.
-
2
Google Sheets - group cases by delivery zone
google.com
WebRun opens Google Sheets to group cases by delivery zone. - Open the delivery zone master sheet and match each case's practice address to its zone
- Group cases by zone and sort within each zone by optimal delivery sequence
- Log the day's route with case count per zone and any flagged urgent stops
Done when Cases are grouped and sequenced by zone in the Google Sheets route log.
-
3
Slack - post the confirmed route sheet
slack.com
WebRun opens Slack to post the confirmed route sheet. - Post the confirmed route sheet to the lab dispatch Slack channel
- List each zone with its stops in order, showing case number, doctor name, and practice address
- Flag urgent cases at the top of their zone list
Done when Drivers and dispatch have today's confirmed route sheet in Slack before departure.
How is each run configured?
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.
Every action is checked against this policy before it runs.
Questions, answered
What if a case is added to the schedule after the route sheet is posted?
The dispatch manager can trigger a manual re-run at any time to regenerate the route sheet with the latest cases from Evident before drivers depart.
How does it know which zone each practice belongs to?
It reads the zone assignments from the delivery zone master sheet in Google Sheets. Update the sheet to add a new practice or reassign a zone and the next run picks it up.
Does it notify dentist offices about delivery times?
No. The route sheet is an internal dispatch tool only. Any communication with a dental practice about delivery timing is left for your dispatch team to send.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.