Automated NEMT Weekly Trip Volume Report
Every Monday, WebRun opens NEMT Cloud Dispatch, pulls the prior week's completed trip data, calculates volume metrics by driver, vehicle, and broker, logs everything in a running Google Sheet, and posts a concise weekly performance report to the management Slack channel.
How do I automatically generate a weekly trip volume report for my NEMT operation?
WebRun pulls the prior week's completed trip data from NEMT Cloud Dispatch every Monday, calculates volume metrics by driver and broker, and logs everything in Google Sheets. A concise performance report with trip counts, no-show rates, and week-over-week trends is posted to Slack so management starts the week informed.
- Management sees last week's trip volume, no-show rate, and top drivers every Monday morning
- Historical metrics build up automatically in Google Sheets week by week
- No manual export or spreadsheet work is needed to produce the report
Built for NEMT managers · paratransit operations directors · medical transport fleet owners
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.nemtclouddispatch.comin a real browser with your saved login - no setup, no API keys. -
1
NEMT Cloud Dispatch - pull prior week completed trip data
nemtclouddispatch.com
WebRun opens NEMT Cloud Dispatch to pull prior week completed trip data. - Open NEMT Cloud Dispatch and filter trips to completed status for the prior 7 days
- Export trip count, total miles, no-show count, and cancellation count broken down by driver and broker
- Note any driver with fewer than expected trips or a high no-show rate
Done when All completed trip data from the prior week is captured with driver, broker, and outcome breakdowns.
-
2
Google Sheets - calculate volume metrics by driver and broker
google.com
WebRun opens Google Sheets to calculate volume metrics by driver and broker. - Open the weekly trip volume Google Sheet and add a new row for the prior week
- Log total trips, total miles, no-shows, cancellations, and top-performing drivers and brokers
- Update the running trend chart if one exists
Done when Prior week's metrics are logged in the Google Sheet and the running history is updated.
-
3
Slack - post weekly performance report
slack.com
WebRun opens Slack to post weekly performance report. - Post the weekly volume report to the management Slack channel: total trips, total miles, no-show rate, cancellation rate, and week-over-week change
- Highlight the top driver and top broker by trip count
- Include a link to the full Google Sheet
Done when Management has a Slack report with last week's key metrics and a link to the full historical sheet.
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 anything to drivers or brokers?
No. The weekly report is entirely internal, posted only to the management Slack channel and logged in Google Sheets. No data goes to drivers or brokers.
Can it break down metrics by individual broker?
Yes. WebRun reads broker attribution from NEMT Cloud Dispatch and includes a per-broker trip count and no-show rate in both the Slack report and the Google Sheet.
How far back does the historical data go?
Each weekly run appends a new row to the Google Sheet, so the historical record grows week by week from the day you set it up. Prior periods are only included if that data exists in NEMT Cloud Dispatch.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.