Event RSVPs on Autopilot: Forms, Sheets, WhatsApp Confirmations

Collecting RSVPs for weddings, fundraisers, community meetups, and church events in Kenya usually means chasing people through WhatsApp messages, phone calls, and group chats. You can automate event RSVP tracking with one reusable flow: a Google Form for responses, a Google Sheet for the guest list, and an optional WhatsApp confirmation so guests know their reply was.

The RSVP Problem Every Event Organiser Knows

Whether you are planning a Nairobi tech meetup, a rural fundraiser, or a wedding, the RSVP process follows the same painful pattern.

You post an announcement in a WhatsApp group. People react with thumbs up, which might mean "I'm coming" or might mean "I saw the message." Some reply with "I'll try" or "TBC." Others message you privately asking for details you already posted. A week before the event, you have no reliable count of who is actually attending.

Then the manual chase begins. You call or text individuals. Some confirm, some say "let me check," some never respond. You create a list in your notebook or Notes app. Someone tells you at the last minute they are bringing a plus-two. You revise your catering numbers for the third time.

This is not just annoying. It costs real money. A wedding caterer in Kenya charges per plate. Over-ordering by 30 plates at a reasonable amount each wastes a reasonable amount. Under-ordering means embarrassment when food runs short. Community fundraisers need accurate headcounts for venue sizing. Corporate events need name badges and seating arrangements.

The solution is a structured form that captures clear responses, a spreadsheet that tallies them automatically, and a confirmation message so guests know their RSVP went through.

What You Are Building

The automated RSVP flow has four parts:

Google Form collects the RSVP with structured fields (name, phone, attending or not, number of guests, dietary needs or other details)
Google Sheet receives all responses in one place, with automatic counts
Confirmation message (WhatsApp or SMS) tells the guest their response was recorded
Reminder message goes out a few days before the event to confirmed guests

Parts 1 and 2 are completely free and take about 30 minutes. Parts 3 and 4 require a small automation setup but save hours of follow-up work.

Step 1: Create the RSVP Form

Open Google Forms and create a new form. Name it clearly: "RSVP: [Event Name] - [Date]."

Add these fields:

Your full name (short answer, required)
Phone number (short answer, required, with validation hint: "e.g., 0712345678")
Will you attend? (multiple choice: Yes / No / Not sure yet)
Number of guests including yourself (dropdown: 1, 2, 3, 4, 5+, only visible if "Yes" is selected)
Any dietary requirements or special needs? (short answer, optional)
How will you get there? (multiple choice: Own transport / Need a ride / Public transport, optional but helpful for logistics)

For weddings, you might add: "Which ceremony will you attend?" (Church only / Reception only / Both). For fundraisers, add: "Will you contribute towards [cause]?" (Yes / I prefer to contribute on the day / Not at this time).

Tip for Kenyan events: Include a field for "M-Pesa name as registered" if your event involves payments or contributions. This makes it easier to match payments to RSVPs later.

Set the form to "Collect email addresses" only if your audience uses email regularly. For many community events in Kenya, phone number is the more reliable contact method.

Step 2: Set Up the Response Sheet

When you create the form, Google automatically creates a linked Sheet. Open it and add useful columns next to the form responses:

Timestamp	Name	Phone	Attending	Guests	Dietary	Transport	Confirmed	Notes

The "Confirmed" and "Notes" columns are ones you add manually. Use "Confirmed" to mark whether you have sent a confirmation message. Use "Notes" for anything relevant: "bride's cousin," "needs wheelchair access," "paying for table of 10."

Add a summary section at the top or on a separate tab:

Total responses: =COUNTA(D2:D)
Attending Yes: =COUNTIF(D2:D,"Yes")
Attending No: =COUNTIF(D2:D,"No")
Not Sure: =COUNTIF(D2:D,"Not sure yet")
Total guests (confirmed): =SUMIF(D2:D,"Yes",E2:E)

These formulas update automatically as new responses come in. You always have an accurate count without manually tallying.

Step 3: Share the Form Link

Where you share the link depends on your audience.

WhatsApp groups: Post the link with a short message. "RSVP for [event] on [date]: [link]. Takes 30 seconds. Helps us plan catering and seating."

Individual WhatsApp messages: For personal invitations (weddings), send the link directly. "Hi [Name], you are invited to [event]. Please RSVP here: [link]. Looking forward to seeing you."

SMS: If some guests do not use WhatsApp, send the link via SMS. Google Forms links work in any phone browser.

Social media: For public or semi-public events (meetups, community gatherings), post on Instagram Stories, X (Twitter), or Facebook with the link.

QR code on physical invitations: Generate a QR code from your form link (free at any QR code generator website) and print it on cards. Guests scan with their phone camera and the form opens. This works well for printed wedding invitations and church notice boards.

Step 4: Send Automatic Confirmations

When someone submits the form, they should know it worked. Two approaches:

Built-in Google Forms confirmation. In the form settings, edit the confirmation message that appears after submission. Instead of the default "Your response has been recorded," write something useful: "Thank you for your RSVP! You are confirmed for [event] on [date] at [venue]. We will send a reminder closer to the date. If your plans change, fill in the form again or contact [organiser] at [number]."

This is the simplest option and requires no extra tools.

WhatsApp or SMS confirmation via Make/Zapier. If you want guests to receive a WhatsApp or SMS message confirming their RSVP, connect Google Sheets to a messaging service. The trigger: "New row added to spreadsheet." The action: "Send WhatsApp message" (through the Business API) or "Send SMS" (through Africa's Talking or a similar service).

The message template: "Hi [Name], your RSVP for [event] is confirmed. Date: [date]. Venue: [venue]. Guests: [number]. See you there!"

This second option adds a personal touch and ensures the confirmation reaches the guest's phone directly. The business automation guide for Kenyan SMEs explains how to connect Google Sheets to messaging tools step by step.

Step 5: Send a Reminder Before the Event

Two to three days before the event, send a reminder to everyone who said "Yes." Export the "Yes" responses from your sheet (filter the Attending column), and send a message:

"Reminder: [Event] is on [day], [date] at [time]. Venue: [location]. [Any instructions: parking, dress code, what to bring]. See you there!"

If you built the Make/Zapier automation for confirmations, you can schedule this reminder as part of the same workflow. If not, copy the message and send it via WhatsApp Broadcast to the confirmed attendees.

For the "Not sure yet" group, send a softer follow-up: "Hi [Name], just checking if you have decided about [event] on [date]. We are finalising numbers. Let us know when you can."

Adapting the Flow for Different Events

Weddings. Add a "Table preference" field (family, friends, workmates) to help with seating. Add "Song request" for fun. Set the RSVP deadline two weeks before the wedding to give the caterer time. For harambee/contributions, include M-Pesa details in the confirmation message.

Corporate meetups and tech events. Add "Company/Organisation" and "Job title" fields for networking name badges. Add "Topics you are interested in" if the event has breakout sessions. Set up a waitlist by closing the form after reaching capacity and switching to a "Join the waitlist" version.

Community fundraisers. Add "Pledge amount" as an optional field. Track pledges in a separate sheet tab against actual contributions received via M-Pesa. Send a thank-you message after the event with the total raised.

Church events. Add "Ministry/Group" to know which part of the congregation is attending. Include "Can you volunteer to help?" with options (setup, ushering, parking, cleanup). This simultaneously collects RSVPs and builds your volunteer roster.

Handling Changes and Cancellations

Add a "Status" column to your sheet with values: Confirmed, Cancelled, Updated. When someone messages you to cancel, update the status and adjust your guest count formula to exclude cancelled rows:

=SUMIFS(E2:E, D2:D, "Yes", H2:H, "<>Cancelled")

For larger events (100+ guests), create a separate "Update My RSVP" form that asks for the guest's phone number and their updated response. Match it to the original RSVP by phone number and update the main sheet. This avoids duplicate entries.

The Reusable Part

The beauty of this system is that you build it once and duplicate it for every future event. Copy the Google Form, change the event-specific details (name, date, venue), and you have a new RSVP form in five minutes. The Sheet formulas, summary section, and automation connections stay the same structure.

Event organisers who run regular events (monthly meetups, quarterly church events, annual fundraisers) save significant time by reusing this flow rather than starting the WhatsApp chase from scratch each time.

To learn how all these tools connect and how to build more advanced workflows, the free welcome module of the AI and Automation course covers the foundations step by step.

FAQ

What if guests do not click the form link and just reply in WhatsApp instead?

This happens often. Some people will always reply "I'm coming" in the chat instead of clicking the link. Accept it gracefully and add their response to the sheet manually. Over time, as people see the confirmation message that form respondents get, more of them will use the form. You can also gently redirect: "Thanks! Could you fill in the quick form so we count your guests and dietary needs? [link]"

How do I handle last-minute cancellations?

Add a note in your confirmation message: "If your plans change, please let us know by [date] so we can adjust." When someone cancels, update their row in the sheet (change "Yes" to "Cancelled" in the Status column) rather than deleting it. This keeps an accurate record of everyone who was invited and their final status.

Can I use this for paid events where guests need to buy tickets?

Yes, with a small modification. Add a "Payment status" column to your sheet. After someone RSVPs, send them payment instructions (M-Pesa Paybill or Till number). When payment comes in, match it to the RSVP by name or phone number and mark "Paid." Only count paid RSVPs as confirmed for catering purposes. Unpaid RSVPs are intentions, not commitments.

What if I am organising a very large event (500+ guests)?

The Google Form and Sheet approach works for events of any size since Google Sheets supports hundreds of thousands of rows. The manual parts (sending WhatsApp confirmations individually) become the bottleneck at scale. For large events, the Make/Zapier automation for confirmations and reminders is worth the setup effort. You might also consider dedicated event platforms like Eventbrite (which works in Kenya) for ticketed events, though they charge a fee per ticket.