At 5 PM before each field day, every volunteer on the roster gets a WhatsApp message with the meeting point, start time and gear list, plus buttons to confirm or cancel. Cancellations reopen the spot and alert the coordinator when a site runs short.
Typical results
By 9 PM
Confirmed headcount for every site, the evening before
≈2 hrs/wk
Coordinator time on confirmation calls saved
≈80%
Volunteers who answer the first message
Figures reflect typical results for this kind of automation.
The challenge
Field days depend on a minimum crew at each site, for tree planting, beach cleanups or trail work. Volunteers sign up a week or more ahead, and plans change. The coordinator learns about dropouts that morning, when a site turns up three people short, tools sit unused and others who wanted a spot never got the chance to come.
Before and after
No-shows per field day
−38%Coordinator hours per week on confirmations
−67%Sites starting below minimum crew per month
−75%The automation
Make reads the Google Sheets roster at 5 PM the day before each field day and sends every volunteer a WhatsApp message with the meeting point, start time and what to bring. Two buttons, "I'm coming" and "I can't make it", record the answer on the roster. A cancellation reopens the spot on the public sign-up sheet, and the coordinator is alerted if a site drops below its minimum crew. Anyone silent by 9 PM gets one short reminder.
How it works
- 01
Roster checked at 5 PM
The day before each field day, Make reads the Google Sheets roster for every site and the volunteers signed up to it.
- 02
Details sent on WhatsApp
Each volunteer gets the meeting point, start time and what to bring, such as gloves, water and closed shoes, with two answer buttons.
- 03
Answers recorded on the roster
A tap on "I'm coming" or "I can't make it" updates the volunteer's row, and a cancellation reopens the spot on the public sign-up sheet.
- 04
Coordinator alerted when short
If a site drops below its minimum crew, the coordinator gets a WhatsApp alert with the site, the headcount and the open spots.
- 05
One reminder at 9 PM
Volunteers who have not answered by 9 PM get one short reminder, and the final headcount per site is ready for the morning.
Starts from
- Volunteer roster by site
- Field day schedule
Delivers
- Confirmed headcount per site
- Reopened sign-up spots
- Short-crew alert
The impact
No-shows drop by about 35%, because volunteers who can't come say so the evening before and their spots reopen for others to take. The coordinator knows by 9 PM which sites are short, saves about 2 hours a week of calls and texts, and field days start with full crews more often.
Questions about this automation
What if a volunteer replies with a message instead of tapping a button?
Free-text replies are passed to the coordinator on WhatsApp with the volunteer's name and site, so questions such as whether there is a ride from the train station still get an answer. The roster stays unchanged until the volunteer taps a button or the coordinator updates the row.
Can the timing and minimum crew differ by site?
Yes. Each site has its own row in the schedule with a minimum crew, a meeting point and a gear list, and the send time can be moved per field day. Early starts, such as a 6 AM beach cleanup, can get the message at noon the day before instead.
What does the group need to set this up?
A WhatsApp sender number, the Google Sheets roster and sign-up sheet the group already uses, and phone numbers for volunteers who agreed to receive messages. Simple automations like this are usually live within days, and the first field day doubles as the test run with the coordinator watching replies.