# Turn your RSVP list into a drag-and-drop seating chart

> Drag a guest to a new table and the spreadsheet updates itself, meal counts included.

Open your guest list in Google Sheets and ask Gemini to create a canvas. You get a seating chart where you drag guests between tables, and every move updates the sheet for your co-planner too.

- Page: https://thesolocreators.com/prompts/rsvp-list-to-drag-and-drop-seating-chart/
- Category: Upgrade your everyday
- Made for: Everyone
- Works in: Gemini
- Time: About 30 minutes to set up, then seconds per change
- Effort: Advanced
- Note: Needs Google AI Pro or Ultra, or an eligible Workspace plan. Desktop only, in English, and it reads one Sheet tab.

## The prompt

Fill in the parts in [square brackets], or leave them and the AI will ask you for them.

```text
Create a seating chart canvas from this sheet for [EVENT NAME, e.g. our wedding reception]. We have [TABLE COUNT, e.g. 14] round tables with [SEATS PER TABLE, e.g. 8] seats each, plus a head table for [HEAD TABLE SIZE, e.g. 10 people]. Show each table as a circle with guest name cards around it that I can drag between tables, and write every move back to the Table column. Keep a 'Not seated yet' list on the side. Color the cards by meal choice and show a warning when a table is over capacity. Keep people from the same party together by default, and flag these pairs to keep apart: [KEEP APART, e.g. rows 12 and 30]. Show seated guests and meal counts for each table at the top, so I can send totals to the caterer.
```

## Step by step

1. Put your guests on one Google Sheets tab with name, party, meal choice and table columns.
2. Select Insert, then Create a canvas, and paste the prompt.
3. Drag a few guests to new tables and check that the Table column changes too.
4. Ask Gemini for fixes, like a list of guests who still don't have a seat.
5. Check the meal counts against your RSVPs before you send the totals to the caterer.
6. Select Copy link and share the sheet with your co-planner as an editor.

## What you'll get

An interactive seating chart inside your sheet, with drag-and-drop tables, capacity warnings and meal counts that stay in sync.

## Good to know

**Which AI tools does this work in?** It works in Gemini. On this page, one tap copies the prompt and opens the app, so you just paste. Needs Google AI Pro or Ultra, or an eligible Workspace plan. Desktop only, in English, and it reads one Sheet tab.

**How long does it take?** About 30 minutes to set up, then seconds per change. It's rated "Advanced". There are 6 steps, listed above.

**What do I need before I start?** Just your details for 5 blanks: event name, table count, seats per table, head table size and keep apart. You can skip any, and your AI will ask for them.

**What will I get back?** An interactive seating chart inside your sheet, with drag-and-drop tables, capacity warnings and meal counts that stay in sync.

Idea spotted on the official docs, shared by Eric Birnbaum, Google: https://blog.google/products-and-platforms/products/workspace/sheets-canvas-for-google-sheets-spreadsheets/. The prompt is The Solo Creators' own version.

## Go further

Ready-made skills in the Solo Creators AI Studio (https://thesolocreators.com/studio/) that fit this: TLDR (Your AI stops writing walls of text: every reply leads with the next action, numbered and skimmable); Second Brain (Give your AI a memory it reads across every project, so it finally knows your business).

From AI Use Cases and Prompts by The Solo Creators: https://thesolocreators.com/prompts/. Free to use; please link back to the page when you share it.