Automated Camp Transportation Roster
Every evening, WebRun opens CampMinder, pulls the next day's transportation assignments and daily travel records, compiles a route-by-route bus roster in Google Sheets, and posts a summary to your operations Slack channel so drivers and staff are prepared before arrival.
How do I automatically build camp bus and transportation rosters?
WebRun opens CampMinder every evening, pulls the next day's transportation assignments, and compiles a route-sorted bus roster in Google Sheets. It then posts a summary to your operations Slack channel with a link to the full Sheet, so drivers and supervisors have accurate rosters before the first pickup of the morning.
- Drivers and supervisors have accurate rosters before the first pickup each morning
- Late additions and changes are flagged automatically so nothing is missed
- No staff member has to manually copy CampMinder transport data into a spreadsheet
Built for camp operations managers · camp transportation coordinators · summer camp directors
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.campminder.comin a real browser with your saved login - no setup, no API keys. -
1
CampMinder - pull next-day transportation assignments
campminder.com
WebRun opens CampMinder to pull next-day transportation assignments. - Open CampMinder and navigate to Transportation to view next day's daily travel assignments
- Capture each camper's name, pickup location, drop-off location, and assigned bus or route
- Note any special needs, late additions, or cancellations recorded since the last run
Done when Every camper with a transportation assignment for the next day is captured with their route and stop details.
-
2
Google Sheets - compile route-by-route roster
google.com
WebRun opens Google Sheets to compile route-by-route roster. - Open the camp transport roster Google Sheet and create or update a tab for tomorrow's date
- Sort campers by route and stop sequence so drivers can read down the list in order
- Flag late additions or changes in a highlighted row so staff spot them at a glance
Done when Tomorrow's transport roster is up to date in Google Sheets, sorted by route and stop.
-
3
Slack - post roster summary to operations
slack.com
WebRun opens Slack to post roster summary to operations. - Post a summary to your operations Slack channel listing each route, the number of campers, and any flagged changes
- Include a direct link to the full Google Sheet so drivers and supervisors can access the complete roster
Done when Operations staff have tomorrow's bus roster summary in Slack with a link to the full 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
What if a family cancels a transport booking after the roster is built?
WebRun runs again the following evening and rebuilds the roster from live CampMinder data, so cancellations are reflected by the next morning. For same-day changes, the Google Sheet can be edited manually.
Can drivers access the roster on a phone?
Yes. The Slack post includes a direct link to the Google Sheet, which is fully accessible on mobile. Drivers can open it on any device without logging in to CampMinder.
Does it include campers with special transport needs?
It captures whatever is recorded in the CampMinder transportation module for each camper. Any notes or special instructions entered there are included in the roster row.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.