How to Make a Potluck Sign Up Sheet in Google Sheets

To make a potluck sign up sheet in Google Sheets, open a blank sheet, add a header row with columns for Name, Dish, Category, Serves, and Dietary notes, turn the Category column into a dropdown, then set sharing to "Anyone with the link can edit" and send the link. That gives you a working sheet in about five minutes. The catch is that a spreadsheet cannot cap dishes, stop duplicates, or send reminders, so you become the manual glue holding it together.

Below is the exact build, then the honest limits, then a faster option if you would rather not police a grid all week.

How do you make a potluck sign up sheet in Google Sheets?

Here is the step-by-step version of a potluck sign up sheet in Google Sheets that actually forces the details you need out of every guest.

1. Create the file. Open a blank Google Sheet and name it something guests will recognize, like Thanksgiving Potluck - Nov 27.
2. Build the header row. In row 1, add these columns: Name, Dish, Category, Serves how many, Dietary notes. Skip the vague single-column list. You want structure.
3. Lock the categories. Select the Category column, open Data > Data validation > Dropdown, and enter a fixed set: appetizer, main, side, dessert, drinks. Now people cannot invent their own.
4. Add a target block. Off to the side, list how many dishes you want per category (for example 5 appetizers, 4 mains, 6 sides, 5 desserts, 2 drink runs). This is your plan. Guests will not follow it on their own.
5. Open editing. Click Share, set "Anyone with the link can edit," and copy the link. This is the only way people add themselves without you approving each one.
6. Send the link. Text or email it to your guest list and ask everyone to fill one row.

That is the whole thing. It is free, instant, and for a six-person dinner among friends it is genuinely fine.

What can't a Google Sheet do for a potluck?

A Google Sheet has no idea what a potluck is. It is a grid, and every guardrail has to be enforced by you, by hand. Here is where a 30-person potluck turns into an evening of cleanup.

• Nothing stops overbooking. Your plan says 4 mains. The sheet will happily accept the ninth turkey. You are the capacity limit, checking the file and messaging people to switch to a side.
• People break the layout. One guest types over a neighbor's row, deletes a column, or pastes a paragraph into a cell and shoves everything sideways. With open edit access, you may not notice until the day before.
• No reminders. The sheet will not tell anyone the potluck is Thursday. You send those texts, then send them again to the three people who forgot.
• Phone editing is rough. Half your guests open the link on a phone, and editing a multi-column spreadsheet on a small screen is fiddly enough that fewer people bother.
• Duplicates and blanks. People add themselves twice, leave Category empty, or write "dessert?" with a question mark. You clean it up every time.

None of this makes the spreadsheet useless. The trouble scales with the guest count and with how much you care about a balanced spread.

When should you use a potluck signup tool instead?

Once you are past a dozen people, a purpose-built potluck signup removes the manual steps. You set slots for each dish category, cap how many of each, and share one link. When mains fill, that option locks and guests see only what is still needed. No policing required. Here is the side-by-side.

Two more conveniences worth knowing. If you would rather not build the categories by hand, describe the event in plain language and let AI-powered signup forms lay out the slots, then edit anything afterward. And if you run the same event every season, saving a reusable template skips the rebuild. The same setup carries over to a church potluck signup or any recurring group meal.

Which should you pick?

Use the spreadsheet if the group is small, everyone is comfortable in Google Sheets, and hitting exact category targets does not matter much. Switch to a form when you need caps that enforce themselves, reminders you do not have to send, clean data you do not have to fix, and a link that works painlessly on a phone.

Ready to skip the casserole pileup? Build your potluck signup, cap your mains at four, and share the link.