Automated Cantaloupe Driver Performance Scorecard
Every Monday, WebRun opens Cantaloupe Seed Pro, pulls the prior week's route completion data for each driver, calculates metrics including stops completed, machines serviced, average time per stop, and revenue per stop, and writes a driver performance scorecard to Google Sheets so route managers can identify coaching opportunities and recognize top performers.
How do I automatically track and score vending route driver performance each week?
WebRun pulls the prior week's route completion data from Cantaloupe Seed Pro every Monday and calculates stops completed, machines serviced, revenue per stop, and missed stops for each driver. The results are written to a ranked Google Sheets scorecard so route managers can coach underperformers and recognize top drivers based on real data.
- Route managers have a data-backed driver scorecard every Monday without manual Cantaloupe pulls
- Missed stops and low-efficiency drivers are flagged for early coaching conversations
- Top-performing drivers are identifiable each week for recognition and route modeling
Built for vending operators · route managers · operations directors · convenience service companies
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.cantaloupe.com/products/software/seed-proin a real browser with your saved login - no setup, no API keys. -
1
Cantaloupe - pull prior week route completion data by driver
cantaloupe.com
WebRun opens Cantaloupe to pull prior week route completion data by driver. - Open Cantaloupe Seed Pro and navigate to the route or service history report
- Set the date range to the prior week
- For each driver, pull total stops completed, machines serviced, and sales collected
- Calculate average time per stop and revenue per stop where data is available
- Note any scheduled stops that were skipped or missed
Done when Prior week performance metrics are captured for every active driver.
-
2
Google Sheets - write weekly driver performance scorecard
google.com
WebRun opens Google Sheets to write weekly driver performance scorecard. - Open the driver performance scorecard Google Sheet
- Write one row per driver with stops completed, machines serviced, revenue per stop, and missed stops
- Add a rank column so managers can quickly see who led the fleet that week
- Highlight drivers with a high missed-stop rate so managers know who to follow up with
Done when Weekly driver scorecard is written to Google Sheets and ready for Monday management review.
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
Does it send performance data directly to drivers?
No. The scorecard is written to Google Sheets for managers to review. Any feedback or recognition you share with drivers is left for your management team to deliver through your normal process.
What if a driver had an unusually short week due to time off?
Drivers with fewer than a configurable minimum number of stops in the week are flagged in the sheet so managers know the metrics may not reflect a full workweek before drawing conclusions.
Can the scorecard track metrics beyond what Cantaloupe provides?
The scorecard is based on data available in Cantaloupe Seed Pro. If you track additional metrics in another system, those can be added as manual columns in the Google Sheet by your team.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.