Habitat for Humanity: VolunteerHub API & Sheets Integration
Opened this issue · 7 comments
Background of your organization.
We’re Habitat for Humanity of Metro Denver. We work to build homes, community and hope in the Denver area by partnering with local families and volunteers to build and repair homes. More about us.
Brief description of the project OR need (we can discuss/define the project if you have a need).
We use a program called VolunteerHub to schedule volunteers, and then we have a Google Sheet that is our “Master Volunteer Schedule.” We have hundreds of volunteers each week, and I spend a lot of time manually checking VolunteerHub and updating the numbers of people who have signed up in the Google Sheet. What I want is to connect VolunteerHub (they have an API) with the Google Sheet so that the numbers automatically update. I spent several hours trying to figure it out over the weekend, but I’m in a little over my head. I’d love to figure out how to do it but could just use some help.
How the project will be utilized to benefit the community and your organization.
It would be hugely beneficial to our supervisors to have a more accurate, real-time picture of what their numbers will look like for upcoming weeks. That would enable us to create a better volunteer experience. And it would allow me to spend more time connecting with volunteers and less time making these updates.
Definition of done or description of completed project (aka end result).
Our master schedule shows volunteer signups in real time (or is updated every hour or something).
Your contact information including email and phone number.
Katie Bonomo
kbonomo@habitatmetrodenver.org
720.496.2716
Existing technology that supports your potential project, if any.
VolunteerHub’s API
Could use an AWS Lambda function for this
I would be interested in this one. Want to learn G-suite stuff.
Hi, was this project completed? Any updates on this one?
@aishikdhar2006 We recently deployed an alpha/beta of this that they are using now. There are some minor improvements to work on if this is something you are interested in.
Thanks for the prompt reply @jberns . I wanted to know the API which you were using. Were you using GET APIs to update the Google Sheets from VolunteerHub data or were you using PUT APIs to update VolunteerHub data from Google sheets?
I am also working on something similar so I can chip on.
?
@jberns @eemshi @aishikdhar2006 Can any of you please give me an update on this, perhaps here or to njwandroid@gmail.com thanks!