Guides

How to make a sign-up sheet in Google Forms

Yes, Google Forms works as a sign-up sheet, and for most teachers and organizers it is the quickest free option: one dropdown question with a line per slot, responses straight into a Google Sheet, and a link people already know how to open. The one thing it cannot do on its own is cap each slot. A form will happily take ten sign-ups for a 4:00 pm conference that fits one family. Below is how to build the sheet from scratch, five templates you can copy the structure of, and how to close a slot when it fills.

Build a sign-up sheet in Google Forms, step by step

  1. Go to forms.google.com and start a blank form. Give it a title people will recognize in their inbox, something like "Room 12 parent-teacher conferences, March 14".
  2. Open Settings and turn on "Collect email addresses". You will want to reach the people who signed up later, and any add-on that handles a waitlist depends on this setting.
  3. Add a short-answer question for the person's name (or the student's name, if a parent is filling it in).
  4. Add a multiple-choice or dropdown question and write one option per slot: "4:00 pm", "4:15 pm", "4:30 pm" and so on. Dropdown is better once you pass eight or so options.
  5. Decide on "Limit to 1 response". It stops the same person from booking three slots, but it forces respondents to sign in to a Google account. Fine for a school where every family has a Workspace account. For a community potluck, a good share of guests will give up at the sign-in screen, so I leave it off for anything public.
  6. In the Responses tab, click the Sheets icon to link a spreadsheet. Each sign-up lands as a row with a timestamp, which is your record of who came first.
  7. Click Send. Copy the link, or paste it into any QR generator and print it for the door.

That takes about ten minutes.

Five sign-up sheet templates you can copy the structure of

Google Forms has no official sign-up sheet template, so these are question lists rather than files. Build the questions as written and you have the template.

1. Time slots (parent-teacher conferences)

Each slot fits one family, so this is the template that breaks most often without a cap.

2. Volunteer shifts

Shifts need more than one person, four on the food table, two on registration, so the cap differs per shift.

3. Potluck dishes

The point here is balance. Six desserts and no salad is the classic potluck failure. Three or four per category is about right.

4. Workshop or class seats

Put the seat count in the option text so people know what they are competing for.

5. Equipment or room booking

One honest note. A cap applies per option, not per combination of answers, so one form cannot say cart A is taken for period 2 on March 3. Make one form per day, or keep this as a request form and confirm by hand.

The problem: slots do not close by themselves

Here is the scenario that shows up in every teacher forum the week before conferences. The form goes out Monday night. Tuesday morning two parents have both picked 4:00 pm. By Wednesday, three. The teacher opens the Sheet, emails the second and third parent, offers them 4:15 and 5:30, and one of them has already arranged a babysitter around 4:00. Now she is negotiating by email with people she wanted to meet in person. Then she goes into the form editor and deletes the 4:00 option by hand, and does it again for 4:15 an hour later.

Google Forms has no per-option limit, no total response cap and no scheduled close. The native settings are "Limit to 1 response", "Collect email addresses" and the "Accepting responses" toggle, which you flip by hand. Everything else needs an add-on. I go through all the options in the guide to limiting responses in Google Forms, but for a sign-up sheet the piece you need is a cap per option.

The fix: cap each slot with Form Slots

Form Slots is the add-on I built for this. It puts a capacity on every option of a multiple-choice, dropdown or checkbox question. When an option fills, it is removed from the live form, usually within a minute, and it comes back if you delete a response or raise the limit. The form keeps its normal link and QR code. There is no hosted copy and no second URL to hand out.

Setup on the conference form above:

  1. In the form editor, open Add-ons (the puzzle icon) and pick Form Slots.
  2. Click Configure slots and pick the "Pick a time" question.
  3. Set the capacity per option. For conferences, "Set all slots to" 1 does the whole list at once. For volunteer shifts, type a different number next to each shift.
  4. Save & activate.

When a slot is full, the option disappears from the form, so the next parent only sees the times still open. The sidebar shows booked, waiting and a FULL badge per option.

Waitlist: with "Collect email addresses" on, extra sign-ups wait in line in the order they arrived. When a seat opens, because a family cancelled and you deleted their response, or because you raised the limit, the next person is confirmed automatically and gets an email. The emails come from Form Slots (notifications@mail.formslots.com), not from your account, and only about that person's own booking. Without email collection the caps still work, you just get no waitlist and no emails. There is more on this in the waitlist guide.

One detail that matters on a popular form: bookings are decided on Form Slots' own server, one at a time per form. Two parents submitting in the same second cannot both get the last 4:00 slot. Most other limiter add-ons check after the response is already saved, so on a busy form one or two extra can slip through. I compared five of them here.

Next term, click Reset. Every response is backed up to a new Google Sheet first, then the responses are cleared and the options restored. Change the dates in the option text and send the same link again.

Free covers one live form at a time with every feature, which is enough for a single teacher. Pro is $6 a month or $49 a year for unlimited live forms (pricing). Grid questions (multiple choice grid, checkbox grid) are not supported, so keep the slot question as a plain dropdown or multiple choice.

Google Forms vs SignUpGenius for sign-up sheets

SignUpGenius and SignUp.com exist because of this exact gap. Slots are built in, each one has a count, and the sheet closes a slot when it fills. If you have never used Google Forms and only need one sheet a year, they are a reasonable pick.

The trade-offs: the sign-up lives on their site under their link, the free plan shows ads next to your conference list, and the data sits in their account rather than your Drive. Parents get one more service to learn. With Google Forms the responses go into a Google Sheet you already own, the link is the same kind you send for everything else, and an add-on gives you the slot caps. For a school that already runs on Workspace, I would stay with Forms.

Google Forms (native)Google Forms + Form SlotsSignUpGenius
Slot capsNoYes, per optionYes
WaitlistNoYes, automaticVaries by plan
Where the data livesYour DriveYour DriveTheir site
LinkYour form linkYour form linkTheir link
AdsNoneNoneOn the free plan

Frequently asked questions

Can Google Forms limit the number of sign-ups per slot?

Not on its own. An add-on adds the cap and removes the option when it is full.

How do I make a sign-up sheet with time slots?

Dropdown question, one option per time, responses linked to a Sheet for the timestamps. Cap each option at 1 with an add-on so two people cannot pick the same time.

Can people see who else has signed up?

No. Responses are private to the form owner. For a visible roster, share the linked Sheet as view-only with the email column removed.

How do I stop one person taking several slots?

"Limit to 1 response" does it, at the cost of a Google sign-in. With Form Slots and email collection on, a second submission from the same email replaces the first.

Questions people ask

Can Google Forms limit the number of sign-ups per slot?

Not on its own. Google Forms has no per-option limit, no total response cap and no scheduled close. A Forms add-on such as Form Slots adds a capacity to each option and removes the option from the form when it is full.

Is there a Google Forms sign-up sheet template?

Google does not ship one, but a sign-up sheet is just a name question plus a dropdown or multiple-choice question with one option per slot. The five structures in this guide cover time slots, volunteer shifts, potluck dishes, class seats and room booking.

How do I make a Google Forms sign-up sheet with time slots?

Add a dropdown question and write one option per time (4:00 pm, 4:15 pm, 4:30 pm). Link the responses to a Google Sheet so you get a timestamp per sign-up. To stop two people picking the same time, install an add-on that caps each option at 1.

Can people see who else has signed up?

No. Responses are private to the form owner. If you want a visible roster, share the linked Google Sheet as view-only, with the email column removed.

How do I stop one person taking several slots?

Turn on Limit to 1 response, which requires a Google sign-in. With Form Slots and email collection on, a second submission from the same email replaces the first one, so nobody holds two seats.

Is Google Forms better than SignUpGenius for sign-up sheets?

SignUpGenius has slots built in but puts your sheet on its site, with ads on the free plan and its own link. Google Forms keeps the data in your Drive and uses the link people already know, and an add-on gives it slot caps.