At 6:15 AM each school day, the bus stop lists for a private school's three routes are rebuilt from the day's absences and pickup changes, and every driver gets the ordered stops, children per stop and a map link on WhatsApp.
Typical results
6:15 AM
Morning stop lists in every driver's WhatsApp
2 runs
Per day: morning pickup and afternoon drop-off
≈90%
Fewer wasted stops at absent children's homes
Figures reflect typical results for this kind of automation.
The challenge
Bus drivers at a school with three routes start the day with a fixed stop list, while absences and pickup changes arrive by phone and message the evening before and early in the morning. The office calls drivers one by one before 7 AM, buses still stop at the homes of absent children, and afternoon changes for clubs get missed.
Before and after
Office minutes on driver calls per school day
−86%Wasted stops at absent children's homes per week
−90%The automation
Parents' absence notices and pickup changes land in the school's attendance sheet in Google Sheets. At 6:15 AM each school day, the automation reads them and rebuilds each route's stop list. Every driver gets a WhatsApp message with the ordered stops, the children expected at each one, the stops to skip and a map link for the route. A second run at 1:00 PM does the same for afternoon drop-offs and lists children staying late for after-school clubs separately.
How it works
- 01
Morning run at 6:15 AM
Each school day, the automation reads the absence notices and pickup changes entered in the attendance sheet.
- 02
Stop lists rebuilt
Each route's ordered stop list is updated with the children expected at each stop and the stops to skip.
- 03
Drivers get WhatsApp
Every driver receives the ordered stops, the children at each one, the skipped stops and a map link for the route.
- 04
Afternoon run at 1:00 PM
A second run rebuilds the drop-off lists from the latest absences and pickup changes.
- 05
Club children listed
Children staying late for after-school clubs are moved to a separate late drop-off list, so nobody is left off a bus.
Starts from
- Attendance and absences
- Pickup changes
Delivers
- Driver stop list on WhatsApp
- Route map link
- Late-stay drop-off list
The impact
Drivers start every route with the day's actual list, and the office saves about 30 minutes of morning calls each school day. Wasted stops at absent children's homes drop from around 20 a week to 2, and children staying for clubs are no longer left off the late drop-off.
Questions about this automation
Where do the absence notices come from?
Parents report absences and pickup changes through the school's usual form, or the office enters them, and both land in the attendance sheet in Google Sheets. Anything entered before 6:15 AM is included in the morning list, and the office can resend a route's list after a late change.
Do drivers need a special app?
No. Drivers receive a plain WhatsApp message on their own phone with the stop order, the children at each stop and a map link that opens in their usual navigation app. Nothing needs to be installed, and the message layout stays the same every day so it is quick to read.
What does the school set up before the first run?
Its route and stop lists, the children assigned to each stop and the drivers' WhatsApp numbers, all kept in Google Sheets. Simple automations like this are usually live within days, and the first week can run alongside the old morning calls as a check.