Organization: A local community garden (nonprofit, all volunteers)
The problem
Every summer, gardeners leave town. Their tomatoes don't. The garden's watering program pairs away-gardeners with volunteers who keep their plots alive, and every match, reminder and missed date landed on one volunteer coordinator, a phone full of texts and a spreadsheet that needed babysitting. This summer, the coordinator simply didn't have the time.
What we built
- A sign-up sheet for gardeners and volunteers
- Automatic matching between gardeners who are away and volunteers who are free
- An email to both people the moment a match is made
- A dashboard that shows coverage gaps at a glance
All on Google Sheets and Apps Script, tools the volunteers already knew. Nothing new to learn. Nothing to pay for.
The result
- About two hours to design, build and test
- Zero matching by hand
- Gaps spotted at a glance, before a plot goes thirsty
- One coordinator who got her summer back
What this means for your business
Swap "gardeners and volunteers" for customers and technicians. Patients and open appointments. Clients and missing paperwork. Same problem: matching, reminding and tracking by hand. Most small businesses have a few jobs like this quietly eating hours every week. Finding them is exactly what the AI Assessment is for.