The Algorithm of Donated Time: How to Optimize Volunteering with AppSheet
Spoiler: sometimes technological innovation is born not in an exclusive boardroom, but while serving meals in a soup kitchen.
A few months ago, our team spent a volunteering day at the Cucine Economiche Popolari in Padua, a community soup kitchen. Between preparing trays and chatting with the people who run the place, an everyday challenge came up: “Coordinating shifts with WhatsApp messages and sheets of paper is becoming a job in itself!”
That was when the spark came. At Miriade, we believe that digital transformation finds its highest purpose when it is put at the service of the local community. We didn't just see a stalled organizational workflow, but an opportunity to use our skills in data consulting and IT development to create real social impact.
Our response to this challenge was immediate: design a dedicated application, built entirely by our team with the low-code technology of Google AppSheet, to make the most of the kitchen's most precious resource: its volunteers' time.
Beyond WhatsApp: the need for agile organization
Until now, the complex organizational machine of the Cucine Economiche Popolari has run on word of mouth, sheets of paper, and endless WhatsApp chats. Coordinating, every day, who prepares the food, who answers the phones, and who manages the entrance had become a maze of manual messages.
The result? Phones that never stopped ringing, important messages getting lost, and a huge amount of stress for the organizers.
As we listened to stories of this daily struggle, the challenge seemed clear right away: we had to bring order without cooling the human spirit of the project. So we decided to do what we do best, building a dedicated app – easy to use on both smartphones and PCs – to retire the endless chats and make shift management smooth and automatic.
Digitizing internal processes: low-code technology
From an organizational standpoint, the main need was clear: digitize a process that until then had demanded an enormous amount of time and hands-on effort, and was fragmented across multiple communication channels. Architecturally, the goal translated into leaving the old methods behind and building a single, centralized environment able to orchestrate data and automate everything that could be automated. To do this, our team drew on Google AppSheet, a no-code/low-code platform well suited to lean business application development, whose governance implications we had already explored in our article on shadow IT and spreadsheets (in Italian).
The system's logic is based on a reactive architecture, driven both by user interactions (event-driven) and by scheduled routines:
- the trigger: the process starts either from a manual action (such as onboarding a new volunteer by entering their tasks and availability) or from a preset recurring schedule (new shifts added daily and the overview generated every Monday);
- the processing logic: AppSheet picks up the new entry and processes the data in real time. The system applies well-defined assignment rules: it reads the tasks and availability on the volunteer's profile and matches them against the actual operational needs on the calendar. Based on these criteria, the app automatically generates the volunteer's personal schedule for the next 4 weeks;
- execution and alerts: the application turns this processing into concrete actions. It automatically sends push notifications to volunteers' smartphones to prompt them about shifts and generates automatic alerts when there is no response. If a shift risks going unfilled, the system escalates further, alerting the supervisor and enabling the request to be forwarded to other volunteers.
Key features of the application
- continuous automated scheduling: the app automatically generates shift grids a month in advance, drastically reducing the administrative workload;
- coverage alerts: if a slot remains unfilled or a user does not confirm their participation, the system automatically sends an alert to the administrator so that the service is always staffed;
- personal profiles and security: each volunteer accesses a protected personal area showing only their own shifts and the relevant participation requests, which they can change on their own;
- a shared archive: the application includes a centralized document section for recipes, photos, and official communications. Content is shared only with explicitly authorized people;
- participation insights: through a reporting dashboard, management can analyze participation trends by age and role, tracking them to optimize future recruitment campaigns.
An inclusive solution: the Google for Nonprofits ecosystem
Designing a technically flawless infrastructure would have been pointless if license costs or the limits of standard free accounts had prevented real adoption. For the project to make sense and for the tool to be accessible to all volunteers without financial or technical barriers, there was one fundamental prerequisite underpinning the entire architecture: activating Google for Nonprofits.
That is why, before writing a single piece of automation logic, our team supported the association, guiding it step by step through obtaining this status. This initial strategic step was the real enabler of the project: it brought the operating costs of using AppSheet down to zero and unlocked a suite of enterprise-grade services, ensuring full scalability of the platform and secure, centralized governance of all users' digital identities.
Toward release: innovation that puts people first
The application is currently in the final stages of fine-tuning. Operational testing over the coming weeks will set the official release date.
Putting IT innovation and data consulting at the service of the nonprofit sector means remembering that behind every line of code there is a real impact on people's quality of life. Optimizing volunteer time with AppSheet is our way of saying thank you to those who care for our community, bringing the precision and strength of technology to solidarity.
Designed by Magnific
Articoli simili
Vuoi rimanere aggiornato?
Iscriviti alla newsletter e scegli il tipo di contenuto sul quale vuoi rimanere aggiornato!
Ti invieremo solo argomenti di tuo interesse.