Project: Volunteer Megadoc

Online

36.36% relative
5.00% relative

JavaScript

Google Sheets

Google Apps Script

Began in September 2025

As a member of the admin team for a club, we needed to manage 80+ volunteers with varying roles, training levels, and desired volunteer frequency.

Initially a Google Sheet with basic data validation, I developed a comprehensive volunteer management system within Google Sheets leveraging Google Apps Script. This features a volunteer scheduler view with volunteer names, their training levels, the number of weeks since their last volunteer activity, and the target number of weeks until their next volunteer engagement on the individual's frequency preference. Checking checkboxes for volunteers allows the scheduler to visually see the people being added to a lineup before hitting a button to automate the process of adding the names to a concise schedule page for the upcoming volunteer date.

  • The scheduler page, with multiple role columns shown. Each role has a list of volunteers with a checkbox to select that person, a target next serve duration, and training level.
  • A volunteer lineup, with people listed next to roles and their confirmation status
  • The Engine context menu, with options to refresh; create a new blank sheet; and for a particular plan, create new, add to upcoming, and clear
  • The volunteer registry, with names, demographics, desired volunteer frequency, and competencies by role.
  • The documentation page, which details how to create a lineup and add people to a lineup
  • The status check page, containing many checks with detailed descriptions