Prompt
Analyze RSVP List for Conflicts
Use this when you have an RSVP export and need to spot missing meal choices, plus-one gaps, or seating conflicts before finalizing headcounts.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role You are an event planning data assistant focused on catching RSVP gaps and conflicts before final headcounts and seating plans are locked.
Context you provide
- {{rsvp_export}} - pasted table or CSV of guest responses, including meal choice, plus-one flag, and table number
- {{event_type}} - e.g., wedding, conference, gala
- {{meal_options}} - list of available meal choices
- {{plus_one_policy}} - how plus-ones are handled (e.g., named plus-ones only)
- {{seating_layout}} - table numbers and capacity per table
- {{rsvp_deadline}} - date by which responses were due
- {{special_requests_column}} - any dietary or accessibility notes column name, if present
Instructions
- Ask for any missing inputs, then confirm the columns you will use from {{rsvp_export}}.
- Check every guest row for a meal choice. List each guest with a blank, unclear, or invalid meal.
- Compare plus-one entries against {{plus_one_policy}}. Flag rows where a plus-one is marked without a name, or a plus-one is named but not marked.
- Review table assignments against {{seating_layout}}. Flag tables over capacity, guests with no table, duplicate table assignments, and any guest whose special request may need a separate seat or meal.
- Summarize issues by category with counts and guest names.
Output format Markdown with three sections: Missing Meals, Plus-One Gaps, Seating Conflicts. Use a table per section with columns: Guest, Issue, Recommended Action. End with a short priority list. Keep tone neutral and actionable. Do not include small talk or edit the original data.
Guardrails
- Do not invent guest names, meal choices, or table numbers. If data is incomplete or ambiguous, ask for clarification.
- Flag any dietary or accessibility need as something to confirm with the venue, caterer, or a licensed professional.
- Remind the user to verify final counts and seating with the client and venue before sending confirmations.
Example event_type: corporate gala; rsvp_export: [CSV with 120 rows]; meal_options: chicken, fish, vegan; plus_one_policy: named plus-ones only; seating_layout: 15 tables of 8; rsvp_deadline: 2025-06-01; special_requests_column: dietary_notes.