Sign-Up Sheet with Google Forms: Free Template + Steps

Updated July 2026 · 7 min read

A paper sign-up sheet gets lost, smudged, and stuck to one physical location. A Google Forms sign-up sheet lives in everyone's pocket, updates in real time, and drops every entry into a spreadsheet you can sort. It's free with any Google account, and you can build one in about five minutes. Below are three copy-ready question sets — volunteer shifts, potluck dishes, and class seats — plus the truth about limiting slots and the fastest ways to share it.

Step 1: Start the form

On a computer, go to forms.google.com and click Blank. On a phone, either request the desktop site in your browser or use FormMaker, which builds real Google Forms through your own Google account. Title the form after the event — "Room 12 Field Trip Chaperones," not "Sign-Up Form" — and use the description for the date, location, and any deadline ("Please sign up by Friday, Oct 9").

Step 2: Pick a template — three ready-made question sets

Variant A: Volunteer shift sign-up

1. Full name — Short answer, required
2. Phone number — Short answer, required (so a coordinator can text day-of changes)
3. Email address — Short answer, or turn on email collection in Settings
4. Which shift can you take? — Multiple choice, required:
   • Setup — Saturday 8:00–10:00 AM
   • Ticket table — Saturday 10:00 AM–1:00 PM
   • Ticket table — Saturday 1:00–4:00 PM
   • Cleanup — Saturday 4:00–6:00 PM
5. Can you take a second shift if we're short? — Multiple choice: Yes / No / Maybe, ask me
6. Anything we should know? — Paragraph, optional (accessibility needs, arrives late, etc.)

Use multiple choice if each volunteer takes exactly one shift; switch to checkboxes if people may grab more than one.

Variant B: Potluck dish sign-up

1. Your name — Short answer, required
2. What category are you bringing? — Multiple choice, required: Appetizer / Main dish / Side / Dessert / Drinks / Plates & utensils
3. What exactly are you bringing? — Short answer, required ("Maria's chicken enchiladas" prevents six identical pasta salads better than a category ever will)
4. Does your dish contain common allergens? — Checkboxes: Nuts / Dairy / Gluten / Shellfish / Eggs / None of these
5. How many people does it serve? — Multiple choice: 4–6 / 8–10 / 12+

Variant C: Class or workshop seats

1. Full name — Short answer, required
2. Email — collected automatically via Settings, or a required short answer
3. Which session are you registering for? — Multiple choice, required:
   • Intro to Watercolor — Tue 6:00 PM (12 seats)
   • Intro to Watercolor — Thu 6:00 PM (12 seats)
   • Open Studio — Sat 10:00 AM (20 seats)
4. Experience level — Multiple choice: First time / Some experience / Regular
5. How did you hear about the class? — Dropdown, optional

Step 3: The honest truth about limiting slots

Here's the part most "free template" posts skip: Google Forms cannot cap a choice. If your 10 AM shift needs three people, nothing stops a fourth from picking it. There is no native slot limit or choice elimination.

You'll see add-ons like Choice Eliminator recommended for this. Know what you're getting into: they run only in the desktop editor (no help if you manage forms from a phone), and because they remove options by editing the form after each submission, they're flaky under load — two people submitting at nearly the same moment can both grab the "last" slot, and the add-on sometimes lags or stops silently.

Simpler approaches that actually hold up:

• Put capacity in the option text — "Setup shift (need 4)" — and check responses once or twice a day. When a slot fills, edit the form and change the option to "Setup shift — FULL" or delete it. Edits go live instantly; people who already answered keep their response.
• Close the whole form at total capacity. Toggle Accepting responses off in the Responses tab and set a "Sign-ups are closed" message.
• Over-collect and confirm. Let a slot go one or two over, then message the extras and offer the next opening. For volunteer events, a small waitlist is a feature, not a bug.
• Add a waitlist option — "Any shift is full? Put me on the waitlist" — so late sign-ups still leave contact info.

Step 4: Settings worth flipping

• Limit to 1 response — stops accidental double sign-ups (requires respondents to sign in to Google).
• Collect email addresses — saves you a question and guarantees a real address.
• Allow response editing — lets someone switch from the Tuesday session to Thursday without emailing you.
• Confirmation message — replace "Your response has been recorded" with something useful: "You're signed up! We'll email details Wednesday. Questions? Text Dana at ___."

Step 5: Share it — link and QR code

Click Send, choose the link icon, and check Shorten URL for a forms.gle link that survives being typed from a flyer. Drop it in the group chat, the PTA email, or the team Slack. For anything physical — a bulletin board, a table at back-to-school night, the break room fridge — a QR code beats a typed URL every time; see our QR code guide for the fastest ways to make one. FormMaker generates a shareable link and QR code for any form straight from your phone.

Step 6: Track sign-ups in Google Sheets

In the Responses tab, click the green Sheets icon to create a linked spreadsheet. Every sign-up appears as a new row with a timestamp. From there:

• Sort by the slot column to see each shift's roster at a glance.
• Use =COUNTIF() — e.g. =COUNTIF(D:D,"Setup — Saturday 8:00–10:00 AM") — to get a live count per slot, so you know the moment one fills.
• Share the Sheet view-only with co-organizers instead of forwarding screenshots.

Deleting a row in the Sheet does not delete the form response — manage cancellations in the form's Responses tab if you want the counts to match.

FAQ

Related guides

• Google Forms RSVP template
• Event registration form with Google Forms
• How to make a QR code for a Google Form