A form card with checkbox circles feeding a grid of spreadsheet tiles, beside an envelope, over soft layered circles

How to Make a Google Forms RSVP (Step by Step)

Google Forms makes a perfectly good RSVP form in about ten minutes, and every reply lands in a spreadsheet. It’s free, and your guests already know how to fill one in. Here is the setup that works, then the four things it can’t do and what to use when you need them.

The quick answer: start from the RSVP template, ask name / coming? / how many / anything else, send “No” answers straight to submit, link the form to Sheets for a running headcount, and turn on email alerts. If you need reminders to people who haven’t answered, a capacity cap, or check-in at the door, use an RSVP tool like CarlyEvents instead, which knows who was invited and chases the rest for you.

1. Start from the RSVP template

Go to forms.google.com, open the Template gallery, and choose RSVP. It comes pre-titled with a few sample questions you can edit. A blank form works just as well.

Put the event name, date, time, and place in the title and description. Guests often open a form without the invitation in front of them.

2. Add the questions that matter

Keep it short. Every extra question costs you replies.

QuestionTypeRequired
Your nameShort answerYes
Will you be there?Multiple choice: Yes / No / MaybeYes
How many people, including you?Short answer, with response validation: Number, between 1 and 6Yes, if attending
Names of anyone coming with youShort answerNo
Dietary needs or allergiesParagraphNo

For the headcount question, open the three-dot menu on the question, choose Response validation, and set Number and Between so nobody types “me plus the kids.”

3. Skip the follow-ups for anyone who says no

Someone who isn’t coming shouldn’t be asked about allergies.

  1. Click Add section below the attendance question, and move the headcount, names, and dietary questions into that new section.
  2. On the attendance question, open the three-dot menu and choose Go to section based on answer.
  3. Set Yes and Maybe to go to the new section, and No to Submit form.

4. Set the response settings

Open Settings, then Responses:

  • Collect email addresses. Turn this on if you want to know exactly who replied. Verified uses their Google account; Responder input lets anyone type an address.
  • Send responders a copy of their response. A free confirmation email, once email collection is on.
  • Limit to 1 response. This stops double submissions, but it forces every guest to sign in to Google. For a party, leave it off and deduplicate in the sheet.

5. Get a running headcount in Google Sheets

In the Responses tab, click Link to Sheets and create a new spreadsheet. Every reply becomes a row.

To total the guests who are coming, add this in an empty cell, replacing the letters with your attendance and headcount columns:

=SUMIF(C:C, "Yes", D:D)

Add a second one with "Maybe" if you want the optimistic number.

6. Get an email for every new RSVP

In the Responses tab, open the three-dot menu and choose Get email notifications for new responses. You’ll get an email each time someone submits.

7. Send it, then close it at the deadline

Click Send. Copy the link (tick Shorten URL) and paste it into your group text or invitation, or send the form by email from the same screen.

When RSVPs are due, go back to Responses and switch off Accepting responses. Late guests see a “no longer accepting responses” message, which you can rewrite.

What a Google Forms RSVP can’t do

The form works. The gaps show up around it:

  • No reminders to people who haven’t answered. Forms has no guest list, only replies, so it can’t tell you who is missing. You compare the sheet against your list by hand.
  • No capacity cap or waitlist. Forms won’t stop at 40 guests unless you add a third-party add-on.
  • No real invitation. You get a header image and a theme color. The invitation itself lives somewhere else.
  • No check-in. On the day you’re ticking names off a printed sheet.

For a work lunch or a club sign-up, none of that matters. For a wedding, a big birthday, or anything you’ll host again, it adds up to an evening of spreadsheet chasing that CarlyEvents does for you.

When to use an RSVP tool instead

CarlyEvents starts from the guest list, not the form, which is why it can do the four things above:

  • It knows who was invited, so reminders can go only to the people who haven’t replied.
  • It caps the event and moves late replies to a waitlist.
  • It sends a real invitation. 48 occasions with 11 designs each, or your own HTML, with your questions and plus-ones built into the RSVP.
  • It checks people in from your phone at the door.

Guests answer from a link with no app or account, or by replying to the invitation email in plain words. You can import the same spreadsheet you’d have used for Forms.

And if you’d rather not click through any of it, connect CarlyEvents to Claude or ChatGPT and say: “Create an RSVP for Emily’s 40th on November 14 at 7pm, add a dietary question and plus-ones, import this guest list, and show me the invitation before it goes out.” Setup is in create event invitations with ChatGPT.

Common questions

Is there a Google Forms RSVP template? Yes. Open the template gallery from the Forms home page and choose RSVP.

Can Google Forms send reminders? No. Forms can email you when someone replies, but it has no list of who was invited, so it can’t remind the people who haven’t.

How do I stop people from RSVPing twice? Turn on Limit to 1 response in Settings, but it requires every guest to sign in with a Google account. Most hosts leave it off and remove duplicates in the sheet.

Can I close the form when we’re full? You can switch off Accepting responses by hand. An automatic cap needs an add-on, or an RSVP tool like CarlyEvents that moves late replies to a waitlist.

Related: guest list app, Evite alternatives, Jotform vs Google Forms, and Google Forms response limit.

Make the invitation in minutes

Pick an occasion, change the words and colors, and send. Guests answer from a link with no app, and the guest list, reminders, and check-in run from one place.

Get started
See the prompt
Read https://carlyevents.com/llms.txt and connect to CarlyEvents at https://carlyevents.com/mcp, signing up yourself if you need to. Then help me plan my event and set up the invitation. Don't send anything until I say so.