Automated Coffee Roaster Delivery Route Planning
The evening before each delivery run, WebRun opens Cropster, pulls tomorrow's dispatch orders, sorts them by postcode into a route summary in Google Sheets, and drafts a delivery confirmation email for each cafe in Gmail, left unsent for your ops team to approve.
How do I automatically build a delivery route plan and notify cafes the night before?
Every evening, WebRun opens Cropster, pulls the next day's dispatch orders, sorts them by postcode into a Google Sheets route plan for your driver, and drafts a delivery confirmation email in Gmail for each cafe. Your ops team reviews and sends the confirmations, so every cafe knows when to expect their coffee without any manual prep.
- Driver has a sorted route plan ready before the delivery day begins
- Each cafe gets a delivery confirmation without manual emailing
- Special access or timing instructions are flagged in the route before dispatch
Built for wholesale coffee roasters with own delivery · roastery operations managers · coffee delivery drivers and dispatchers
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
app.cropster.comin a real browser with your saved login - no setup, no API keys. -
1
Cropster - pull tomorrow's dispatch orders
cropster.com
WebRun opens Cropster to pull tomorrow's dispatch orders. - Open Cropster and filter orders to those scheduled for dispatch tomorrow
- Capture the cafe name, delivery address, order contents, and any special delivery notes for each order
- Sort orders by postcode or suburb to group them into a logical delivery sequence
Done when All tomorrow's dispatch orders are collected and sorted by delivery location.
-
2
Google Sheets - build sorted route summary
google.com
WebRun opens Google Sheets to build sorted route summary. - Open the delivery route tracking Google Sheet
- Append tomorrow's route as a new sheet tab or section: stop number, cafe name, address, order summary
- Highlight any stops with special instructions such as access codes, loading dock requirements, or time windows
Done when Tomorrow's route is laid out in the Google Sheet with stops numbered and special instructions flagged.
-
3
Gmail - draft delivery confirmation per cafe
gmail.com
WebRun opens Gmail to draft delivery confirmation per cafe. - Draft a short delivery confirmation email for each cafe on the route
- Include the expected delivery window, order summary, and a contact number for the driver
- Save every draft unsent in Gmail for your ops team or driver to review and send the evening before
Done when A delivery confirmation draft is waiting in Gmail for every cafe on tomorrow's route, unsent pending ops approval.
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
Will it send confirmation emails to cafes automatically?
No. Every confirmation is saved as a Gmail draft and left unsent. Your ops team or driver reviews and sends them the evening before delivery, so cafes never get an unverified message.
How does it sort the route?
By default it groups stops by postcode to minimize backtracking. If you have a preferred route order or zone map, you can provide it during setup and WebRun will follow your sequencing.
What if an order is added or changed after the evening run?
The run captures whatever is in Cropster at the time it runs. For late changes, trigger a manual re-run from WebRun's dashboard to refresh the route plan and draft updated confirmations.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.