How to make a sign-up sheet in Google Forms

How do you make a sign-up sheet in Google Forms?

The example here is helpers for a school science night. Google moves its menus now and then, so the names below may have shifted a little.

1. Open Google Forms and start a blank form. Call it “Science night helpers”. In the description, put the day (Thursday, December 3), the place and what to wear.
2. Add a Short answer question called “Your name” and turn on Required.
3. Add a Multiple choice question called “Pick a job”, with one choice per slot and its time in the choice. Use Checkboxes instead if people may take more than one. Turn on Required.
4. Open Settings, then Responses. Under Collect email addresses, choose Responder input. Google says Verified collects the address from people's Google Account instead. (Google Docs Editors Help, checked October 26, 2026)
5. Still in Responses, set Send responders a copy of their response to Always, so everyone has a record of the job they picked. Google says this copy works only when the form collects email addresses. (Google Docs Editors Help, checked October 26, 2026)
6. Open the Responses tab at the top of the form and choose Link to Sheets. Google's help puts every response in a spreadsheet this way. (Google Docs Editors Help, checked October 26, 2026) You can then sort the answers by job.
7. Choose Publish at the top right, set General access to anyone with the link, and copy the responder link. Google says that if the form is unpublished, people with the link can't open it. (Google Docs Editors Help, checked October 26, 2026)

The choices for the slots question:

• 5:00 PM Set up tables (3 needed)
• 5:30 PM Check-in desk (2 needed)
• 6:00 PM Slime station (2 needed)
• 6:00 PM Photo booth (1 needed)
• 6:30 PM Snack table (2 needed)
• 8:00 PM Clean up (4 needed)

Put the time first, so the choices read in order. Writing the number needed in the choice tells people how many you want, though the form won't enforce it.

Which settings to leave alone, and why

• View results summary: leave it off. Google says the summary shows full text answers and is visible to anyone who can respond to the form. (Google Docs Editors Help, checked October 26, 2026) That means every helper's name, not only which jobs are taken.
• Limit to 1 response: only if everyone uses Google. With it on, people must sign in to a Google Account to fill in the form. (Google Docs Editors Help, checked October 26, 2026) Anyone without one, or not signed in on their phone, has to stop and sign in first.
• Allow response editing: worth turning on. Google lists it under Settings, then Responses. (Google Docs Editors Help, checked October 26, 2026) It lets someone change their job instead of sending you a second answer to untangle.

Can two people pick the same slot in Google Forms?

Yes. Forms' own limit counts the whole form, not each choice. The response limit Google added in January 2026 closes the form after a set number of responses, or at a date and time you pick. (Google Workspace Updates, checked October 26, 2026) So the photo booth's one spot can go to three people, and nobody finds out until the night.

To set it, choose Published, then Set close date or response limit, and enter the number of responses to accept. Google notes that if several people respond at the same moment, the form takes them all regardless of the limit. (Google Docs Editors Help, checked October 26, 2026) For the sheet above, a limit of 14 closes the form once 14 people answer, even if they all chose clean up.

Showing people what's taken has the same gap. The setting that lets helpers see other answers is View results summary, which, as Google says above, shows them everyone's full answers. So showing which jobs are filled also shows who filled them.

Ways to cope inside Google Forms

• Watch the sheet and delete full choices. Sort the linked spreadsheet by job each evening. When a job has enough people, edit the question and remove that choice. Anyone who answered in between still got it.
• Send reminders yourself. For follow-up emails to the people who answered, Google's help points to the Form Notifications add-on rather than a setting in Forms. (Google Docs Editors Help, checked October 26, 2026) Without one, copy the email column from the sheet and write to them the evening before.

When Google Forms is the better choice

Stay with a form when you need questions of your own: T-shirt sizes, allergies, a permission checkbox. Forms asks any question type, puts the answers in a Google Sheet, and is already in your account. It can also email you each time a new response comes in. (Google Docs Editors Help, checked October 26, 2026) OpenSignup asks only for a name, an email and a note, and doesn't tell you when someone signs up. You see the list on its Responses tab, and Download CSV gives you a spreadsheet file.

The same sheet with a limit on each slot

When the job is “fill these slots, this many people each”, a sign-up tool fits better than a form. Here is the science night sheet in OpenSignup. Each job is a slot with its own number of spots. A full slot stops taking people, and everyone sees what's left without seeing who took it.

1. Choose New signup. If “What are you organizing?” appears, choose Skip, fill in by hand.
2. Type “Science night helpers” in Title, add a description like the example's and choose Create signup.
3. Choose Fields, then Add field. Name it Time, pick Time and choose Add field again to save it.
4. Open the empty slot. Type “Set up tables” in What, set Date to Thursday, December 3 and Time to 5:00 PM. Set Spots to 3 and choose Done.
5. Choose Add a slot for each of the other 5 jobs, with its own time and spots.
6. Choose Publish and share, then Copy link (Share… on most phones), and send the link the way you would have sent the form.

The guide to creating and publishing a signup shows each screen. For a day of repeating shifts rather than one evening, the shift sign-up sheet has a fuller example.

What helpers get after signing up

• A confirmation email naming the signup and the slot's job, date and time, with a link to change or cancel.
• A reminder email the day before. Someone who signs up less than a day ahead gets one about an hour after signing up, though a sign-up on the day itself may get none.
• Add to calendar, which puts a 5:00 PM slot in their calendar at 5:00 PM as a one-hour event, however long the job runs.

It's free, with no ads, and helpers don't need an account. It has limits too: no text reminders, no templates and no copying a whole signup. Coming from a paid sign-up tool instead? See the free SignUpGenius alternative.

Frequently asked questions

Related reading