Band Booster Scheduler
Enter your password to continue
Checking password…
Connect to Google Sheets

This syncs your data to Google Sheets so it works across all your devices. Complete these steps once:

  1. Go to sheets.google.com → create a new blank spreadsheet named Band Booster Scheduler.
  2. In the spreadsheet click Extensions → Apps Script. Delete all default code, paste in BandBoosterBackend.gs, set your passphrase on line 10, Save.
  3. In Apps Script click Deploy → New deployment → Web app → Execute as Me → Access Anyone → Deploy → copy the URL.
  4. In your Vercel dashboard → your project → Settings → Environment Variables, add:
    APPS_SCRIPT_URL = the /exec URL
    API_KEY = your passphrase
  5. In Vercel → Deployments → Redeploy.

Click below to test the connection.

Band Booster Scheduler
Manage volunteer assignments for each event
Google Sheets sync
The connection is configured via Vercel environment variables.
Checks the connection and pulls the latest data down from Google Sheets, overwriting what's shown in this browser. Safe — doesn't touch the sheet.
Read-only connection test. Checks that Vercel and Apps Script are configured correctly and reports what's wrong if not. Makes no changes.
Only affects this browser — deletes the locally cached copy of the data and reloads the page. Your Google Sheet is never touched by this. There is no button anywhere in the app that deletes data from the Sheet itself; deleting a schedule, volunteer, or job only removes that one item, and even that requires confirmation first.
Schedules
Assign
Master roster
Configuration
History
Create new schedule
First row is headers. Two columns: Name, Date (date format YYYY-MM-DD).
Drag volunteers from the pool or any position row — drop onto a job to append, onto a specific row to insert, or back to the pool to unassign.
Assign import to a schedule
Choose a future schedule:
CSV import — assign to a schedule
Add volunteer manually
Master roster
Click any cell to edit inline.
FirstLastEmailPhoneThis week
Add job
Job roster
Click any cell to edit inline. Position #1 is always the lead.
Job titleNotesSlots
Add halftime job
Halftime jobs
These appear as options in the halftime dropdown on each position. Click to edit inline.
Name
Bus configuration
Sets the number of buses available in the bus dropdown when assigning volunteers.
1st & 2nd half jobs
These appear as dropdown options for 1st half and 2nd half assignments on each volunteer row.
Name
Board members
This list is set once per year. On the Assign tab you'll check off which board members are covering each event.
Name
Password management
Passwords are stored in the AppPasswords tab of your Google Sheet. Load current passwords to edit, then save back to the sheet. Leave a field blank to keep the existing password unchanged.
Role New password Confirm
Logistics
General
Admin
Add volunteer to this week
Pick from master roster volunteers not already on this schedule.
Print assignments
Events are automatically saved to history the day after they occur. Click any field to edit inline.