The Brooklyn Bridge Park Boathouse is a non-profit runs a variety of human powered boating programs for both kids and adults on the Brooklyn waterfront. We have a free kayaking program that puts nearly 4,000 people on the water. We have over 100 volunteers and in any given week, we might have 25 or 30 people staffing our program.
That presents quite a coordination problem that is only going to get worse as we scale--manually gathering responses, filling holes in our schedule, etc.
We'd like to great a simple tool that attaches to a gmail account that gathers replies by e-mail into a Google Sheet, and updates volunteers on our current staffing status.
Here's what would happen:
1) A note will go out saying "Hey, who wants to volunteer? What times can you come by?" We could either have specific slots that they could pick by number, or they might answer "Thursday, 5pm-7pm."
2) We'd like to gather all of their names, e-mails and phone numbers into a simple calendar page that shows a Gantt-like chart of the volunteers, and when they're staffing the program, and how many are present at any given time.
3) It would be amazingly cool if the chart were available in an image, so if someone got the e-mail on Monday, but ignored it until Wednesday, they'd see how many people have already signed up just by reopening the e-mail.
This would save our volunteer coordinator hours and hours, and undoubtedly be useful for lots of other volunteer coordination efforts. Any hacker interested in helping out over the next couple of weeks?