Stella
Weddings and events

Count wedding RSVPs when some guests replied twice

Form responses and an invite list as one headcount, meal totals and a no-reply list.

Download StellaFree with the plan you already have.

A real run on 14 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 1 min 50 s in real time.

The short answer.

Sort the form responses by time, keep only each household's latest reply (Remove Duplicates on email, after sorting newest first), then add up the number coming and count each meal with SUMIF and COUNTIF. Look each invite-list email up in the responses to find who hasn't replied. Stella (stella.sh) does all of that on your computer from the two files and writes the totals and lists into a spreadsheet.

Stella does this on Windows, Mac and Linux.

What happened.

A summary spreadsheet in under two minutes. Checked afterwards against an answer key written before the run: 46 people coming (adding up every form row gives 53), chicken 11, salmon 16, vegetarian 13, kids' meal 6, all five invitations without a reply listed and no household that replied among them, and both input files unchanged.

The guests, emails and replies are made up for this run. The work is sped up 6×.

How Stella does it.

  1. Reads the form responses in Downloads and the invite list in Documents, and matches every reply to an invitation
  2. Keeps each household's latest answer: one changed from No to Yes, one from 4 coming to 3, one sent the same reply twice
  3. Counts 46 people coming and one meal per guest: 16 salmon, 13 vegetarian, 11 chicken and 6 kids' meals
  4. Lists the five invitations with no reply (up to 12 more guests), with their emails for a reminder, and the three that declined
  5. Flags nine invitations bringing fewer people than invited, and saves it all as Wedding RSVP summary.xlsx in Documents

The prompt.

Our wedding RSVPs came in through a form. The responses are in my Downloads and the invite list is in my Documents. How many people are coming, how many of each meal, and who still hasn't replied? A few people filled the form in twice, so use their latest answer. Put it in a spreadsheet.

Paste it into Stella and press Enter.

This is the exact prompt from the recording. If your files are somewhere else, say where.

Do it yourself.

  1. Keep each household's latest reply

    Open the form responses in Excel or Google Sheets. Sort by Timestamp, newest first. Then Data, Remove Duplicates, ticking only the email column: Excel keeps the first row it finds, which is now the latest answer.

  2. Add up the headcount and meals

    For people coming, =SUMIF(D:D,"Yes",E:E) with your Attending and Number columns. For meals, count each choice across the guest meal columns, for example =COUNTIF(F:I,"Salmon"), and check the meal total equals the headcount.

  3. Find who hasn't replied

    In the invite list add a column =IF(ISNA(MATCH(B2,Responses!C:C,0)),"No reply","Replied") with the email columns, then filter it to No reply. Match on email, not names: people type their names differently.

  4. Check the odd ones

    Compare the number each household said is coming against how many were invited. Fewer can be right (one partner can't come) or a typo worth a quick message.

Where it stops.

  • Stella counts what the form says. It doesn't email guests; it can draft reminder messages for the no-replies if you ask.
  • It matches replies to invitations by email and name. A guest who used a different email and spelled their name differently may need you to confirm the match; Stella lists anything it couldn't match.
  • Guest names, emails and meal choices go to the AI model you use in Stella. The spreadsheet is made on your computer, with no RSVP website involved.
  • Recorded on Linux, where Stella used Python tools already on the computer. On a Mac or Windows PC it may install Python first, which wasn't recorded.

Questions.

My RSVPs are in Google Forms. Does this work?

Yes. In the form's Responses tab, open the linked sheet and download it as Excel or CSV, then point Stella at it.

Can it do the seating chart next?

Yes, once tables are assigned in your guest list: see make a wedding seating chart and place cards from a guest list.

Can it give the caterer a meal list by table?

Yes, ask for meals per table, with names, from the same files plus your table plan.

What if replies came by text or email instead of a form?

Paste or save them into a document and ask Stella to read them into the same summary; check its reading of anything ambiguous.

Is Stella free for this?

Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.

Can I control what Stella changes on my computer?

Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.

Checked against these sources on 14 November 2026.

Stella