How to track RSVPs in a Google Sheet
A Google Sheet makes a good RSVP tracker as long as it is built around one row per invitation, a seats column separate from the reply, and formulas that keep the headcount current for you. The part worth automating is getting replies into it without retyping them.
Last updated: 7 September 2026
Why a spreadsheet, and where it stops working
A sheet is the right tool for a guest list. It is shareable, it is easy to sort and filter, and everyone involved in the event already knows how to read one. Dedicated RSVP apps mostly lose to it on flexibility.
Where a sheet stops working is data entry. If replies are arriving as text messages, emails, and remarks at the school gate, somebody is retyping them, and that person is the bottleneck. The sheet is only ever as current as the last time they sat down with it.
So the goal is a sheet whose structure does the counting for you, fed by something that is not your own typing.
The columns to start with
Six columns cover almost every private event.
- Guest— the name as you would address them in a message. “The Okonkwo family” is a perfectly good value.
- Phone number — in international format, starting with a plus and the country code, no spaces or dashes.
- Relationship — how you know them. Useful for seating, and for deciding who gets chased personally.
- Reply — Yes, No, or blank for no answer yet. Keep it to those three values so formulas stay simple.
- Seats — how many people this row accounts for. This is the column your caterer cares about.
- Dietary — free text, only if you are serving food you can actually change.
Keep the reply and the seats apart
The most common mistake is a single column holding “Yes + 2”. It reads fine and it cannot be counted. Separating the answer from the number is what lets one formula give you a reliable headcount.
Format the phone column as plain text
Sheets will happily strip a leading plus or turn a long number into scientific notation. Select the column, then Format, then Number, then Plain text, before you paste anything in.
Four formulas that keep the count current
Put these somewhere above the list so they are visible without scrolling. Assuming replies are in column D and seats in column E:
- Parties accepting:
=COUNTIF(D:D,"Yes") - Confirmed headcount:
=SUMIF(D:D,"Yes",E:E) - Declined:
=COUNTIF(D:D,"No") - Still to answer:
=COUNTBLANK(D2:D500)
The first two are different numbers and both matter. Twelve parties accepting might be twenty-six people. Quoting the wrong one to a venue is an expensive mistake.
Add conditional formatting on the reply column so accepted rows go green and declined rows grey. It turns the list into something you can read at a glance rather than something you have to filter.
Getting replies into the sheet
There are three realistic approaches, in increasing order of how little work they leave you.
Type them in yourself
Honest and fine for a small list. The risk is not effort but staleness: the sheet is accurate only as of the last time you updated it, and the day you most need it right is the day you are busiest.
A Google Form feeding the sheet
A form writes responses into a linked sheet with no typing at all. The cost is at the other end: guests have to open a link and fill in a page, and every extra step loses you replies. It also puts the responses on a new tab in their own shape, which you then have to reconcile against your guest list.
Let the replies write themselves
The version with the least friction for everyone is one where the guest answers in the app they are already in and the sheet updates itself. That is what Avently does over WhatsApp.
Connecting your sheet to Avently
- Step 01
Set up the two required columns
Your header row needs a column called Guest and one called Phone number. Capitalisation does not matter. Any other columns you keep are left alone.
- Step 02
Share the sheet with the service account
Avently shows you an email address when you connect a sheet. Share the sheet with that address as an Editor, so replies can be written back. Without Editor access the connection will be refused with a permissions error.
- Step 03
Paste the sheet URL into Avently
Avently reads the header row, checks the two required columns are there, and tells you immediately if anything is missing rather than failing at send time.
From then on, each guest’s answer is written to their row as it arrives, including the follow-up questions you set, such as additional guests and dietary requirements. The sheet stays yours throughout, and the data in it is used only to send the invitations you authorise.
A note on privacy
A guest list with mobile numbers is personal data about people who did not choose to be in your spreadsheet. Two habits cover most of the risk. Share the sheet with named people rather than turning on link sharing, and delete the numbers once the event is over and you no longer need them.
Common questions
What columns should an RSVP tracker have?
+
At minimum: guest name, phone number in international format, invitation status, their reply, and the number of seats that reply accounts for. Add a dietary column and a notes column if you are serving food. Keep one row per invitation rather than per person, so a couple is one row with two seats.
How do I count RSVPs in Google Sheets?
+
Use COUNTIF to count replies of a given kind and SUMIF to total the seats behind them. If your reply column is E and your seats column is F, then =COUNTIF(E:E,"Yes") gives the number of accepting parties and =SUMIF(E:E,"Yes",F:F) gives the actual headcount. Those two numbers are different, and the second is the one your caterer needs.
Can Google Sheets collect RSVPs on its own?
+
Not directly, but a Google Form writes responses straight into a sheet, which works if guests are willing to open a link and fill in a form. The trade-off is response rate: a form is another page to load, and it needs the guest to find the link again if they put it off.
How do I get WhatsApp replies into a Google Sheet automatically?
+
You need something sitting between WhatsApp and the sheet that reads incoming messages and writes them to the right row. Avently does this: it sends each invitation, interprets the reply, and writes the answer back to your sheet as it arrives, so the sheet is current without anyone transcribing.
Should I use one row per guest or one row per household?
+
One row per invitation. If you are sending a single message to a couple or a family, that is one row with a seats value of two or four. Splitting a household across rows means either sending duplicate invitations or leaving rows that never get a reply of their own.
How do I keep the guest list private?
+
Share the sheet with named people rather than by public link, and check the sharing settings before you add phone numbers. A guest list with mobile numbers is personal data, and a link that anyone can open is the usual way it leaks.
Avently sends your invitations over WhatsApp and writes every reply into this sheet as it arrives, so the count in front of you is the current one. See collecting RSVPs over WhatsApp for the sending side.
Start free