-
-
-
"Opportunities" Sheet in Master Spreadsheet
-
"Volunteers" Sheet in Master Spreadsheet
-
"Registrations" Sheet in Master Spreadsheet
-
Google Form Sheet of an event in Master Spreadsheet
-
Starting the telegram bot @Hack4GoodBOT
-
Enrolling as a new volunteer through the telegram bot @Hack4GoodBOT
-
Finished enrolling as a new volunteer through the telegram bot @Hack4GoodBOT
-
Browsing the available volunteering opportunities
-
Registering for an event
-
Looking for attended, upcoming events, and providing feedback
-
Certificate generation
What it does
It's a very simple telegram bot for volunteers, coupled with a cloud-based Google database with spreadsheets for admin staff to manage data of volunteers and volunteering opportunities.
How we built it
We built the project from the ground up in python, because of its extensive API options, allowing us to integrate an automated workflow incorporating telegram and google spreadsheets.
How to access
Try signing up as a volunteer and browsing through volunteering opportunities through our telegram bot: @Hack4GoodBOT Peruse through our code on our github repo As a BAH admin, you may create forms here for volunteers to sign up with, and track attendance, sign ups and volunteer data here.
How to use
The telegram bot is already running on a server, so try it out in the link above. Through the bot, volunteers can:
- Sign up as a new volunteer through the /enroll function.
- Browse volunteering opportunities that Big At Heart offers through the /browse function.
- Register for upcoming volunteering opportunities through the /register function.
- Check attendance for previously attended opportunities through the /attended function.
- Submit feedback through the /feedback function.
- Request auto-generated attendance certificates through the /certificate function.
The spreadsheets on Google Sheets are organized as such:
- Opportunities: Admin staff can edit this to show volunteers upcoming opportunities to volunteer for.
- Volunteers: Keeps track of volunteers' data from the enroll function on the telegram bot.
- Registration: Keeps track of volunteers and the upcoming opportunities they have signed up for.
Log in or sign up for Devpost to join the conversation.