Blog · October 27, 2026

How to make a volunteer sign-up sheet in Google Forms with limited spots

A volunteer sign-up needs one thing a plain Google Form can't do: close a shift once it has enough people. This guide builds one where full shifts disappear on their own, so you stop getting eight people for the 9 am setup and nobody for cleanup.

What you'll end up with

• A Google Sheet listing each shift and how many people it needs.
• A Google Form where volunteers pick a shift from that list.
• Shifts that drop off the form once they're full, and come back if someone cancels.

It takes about ten minutes. You'll use a free add-on, Audeza Choice Sync, which we make, to connect the sheet to the form and count sign-ups. If you'd rather not use an add-on, our guide to limiting responses per option covers manual and formula-based ways.

Step 1: list the shifts in a sheet

Create a Google Sheet with two columns:

Write each shift the way you want volunteers to read it on the form. Put the day, the time and the job in one cell, so volunteers don't have to cross-check two questions. Keep row 1 as the header. Blank rows and repeated shifts are skipped, so a messy list won't break anything.

Step 2: create the form

1. Make a new Google Form. Ask for the volunteer's name and email (or turn on email collection in Settings).
2. Add a question like "Which shift can you take?" Choose Multiple choice if each person takes one shift, or Checkboxes if they can take several. Dropdown works too.
3. Leave the options empty. The add-on fills them in.

Step 3: link the question to the sheet

1. Install Audeza Choice Sync from the Google Workspace Marketplace.
2. In the form, open Add-ons (the puzzle icon) > Audeza Choice Sync > Open, and click Link.
3. Pick the shift question, then your spreadsheet in Google's file picker, then the Shift column. The preview shows the exact choices before you save.

Step 4: turn on the spot limits

In the same link dialog, turn on Remove a choice once it has been picked enough times, and choose Spots as the limit column. Each shift now closes after its own number of sign-ups: setup after 4, the bake sale after 2.

A row with no number uses the default limit, which is 1. So for a list where every shift needs one person, you can skip the Spots column.

Save, then click Sync now. The shift question fills with your list.

Step 5: test it before you share

Open the live form (the eye icon) and sign up for the bake sale shift twice, using two quick test responses. After the second one, wait a few seconds and reload. The bake sale shift should be gone. Then delete both test responses from the Responses tab and click Sync now. The shift comes back.

Testing takes two minutes and catches the most common mistake: picking the wrong column for limits.

Step 6: share the form

Send the form link as usual: email, a group chat, a QR code on a flyer. Volunteers don't install anything. From now on the add-on recounts after every response, every hour, and whenever you click Sync now.

What volunteers see when every shift is full

Google Forms needs at least one choice in a question, so when every shift is taken the question shows a single placeholder: "All options are taken". You can change that text in the link dialog to something more useful, like "All shifts are full. Email pta@yourschool.org to join the waitlist." You can also close the form from the Responses tab.

Handling cancellations

When a volunteer drops out, delete their response in the form's Responses tab. Their spot opens again at the next sync. Click Sync now if you want it back right away.

Want to keep a record of who cancelled? Copy their row from the responses sheet to a "Cancelled" tab before deleting the response. The count comes from the form's responses, not the sheet, so editing the responses sheet alone won't free the spot.

Variant: potluck or snack schedule

The same setup works for "who brings what" lists.

• Potluck. List dishes in column A ("Main dish", "Salad", "Dessert", "Drinks") and how many of each you need in column B. Three people can bring dessert; once the third signs up, dessert disappears.
• Team snack schedule. List each game date in column A, leave column B empty, and every date can be claimed once. Parents see only the dates still open.
• Classroom supplies. One row per item, with the quantity you need as the limit.

For the school version of this, see parent-teacher conference sign-ups or time slot sign-ups.

Good to know

• Same-moment sign-ups. Google Forms doesn't hold a shift while someone is filling in the form. If two people submit within the same few seconds, both can get the last spot. This is true for every add-on that uses the normal form link. You'll see both responses in the sheet.
• Edits to the sheet aren't instant. Google doesn't let a Forms add-on watch a sheet. New shifts appear after the next response, on the hour, or when you click Sync now.
• If something breaks, you hear about it. If the Shift header is renamed or the column comes up empty, the form keeps its current shifts, and you get an email from alerts@audeza.com saying why.
• Privacy. The add-on opens only the spreadsheet you picked. Volunteer names and answers stay in your Google account and aren't copied to our servers.

The add-on is free for up to 3 linked questions per form, which covers most volunteer sign-ups.

Questions

Do volunteers need to install anything?

No. Only the organizer installs the add-on. Volunteers open the normal Google Forms link on any phone or computer.

Can a volunteer sign up for several shifts?

Yes. Use a checkbox question, and each ticked shift counts toward its own limit.

Can two people take the last spot?

Only if they submit within the same few seconds, because Google Forms doesn't hold a choice while someone is answering. It's rare, and you'll see both responses in the sheet.

Can I add shifts after sharing the form?

Yes. Add rows to the sheet, then click Sync now, or wait for the next sync after a response or on the hour.