Gouda Studios Agent Tools
Secret Santa gift exchange tracker: draw names, set a budget, and track purchases without spoiling the surprise
Short answer: List every participant once, set one shared budget cap, then assign each giver a recipient with a formula or a one-time random draw. Keep the assignment column hidden from the shared view (or use a private host sheet). Track Bought / Wrapped / Brought for each gift so the host can chase stragglers before the party.
Start with one participant list
One row per person keeps the draw fair and makes it obvious if someone was added twice.
- A: Name
- B: Email or phone (for reminders)
- C: Wishlist link or 3 hint ideas
- D: Dietary or allergy notes (if the party includes food)
- E: Attending? (Yes / No / Maybe)
- F: Assigned recipient (host-only)
- G: Gift status (Idea / Ordered / Bought / Wrapped / Brought)
- H: Amount spent ($)
- I: Notes
Set one budget everyone can see
Put the cap in a single cell (for example Budget!$B$1) and reference it on every reminder. A common office or friend-group range is $15 to $30; family groups often go higher. Write the rule next to the cap: "Stay at or under the cap; experiences and handmade gifts count."
Draw names without double-assigning
Two workable methods:
- Host shuffle: copy Names into a Recipients column, shuffle that column once, then check that nobody got themselves (A2<>F2). Re-shuffle any self-matches.
- Spreadsheet formula approach: after the list is final, the host fills F with a derangement (a permutation with no fixed points). Do not share column F in the same sheet participants edit.
Hide the spoilers
Participants need the budget, the party date, and their own assignment — not everyone else's. Options that stay free:
- Private host tab: keep assignments on a tab only the host opens; message each person their recipient out of band.
- Individual view: give each person a filtered view or a one-row slip with only their name and recipient.
- Wishlist column stays public so givers have ideas without asking and ruining the surprise.
Host chase list before the party
Filter Gift status for anything that is not Brought three days before the exchange. Sort by Amount spent blank to catch people who have not shopped. Send one group reminder with the budget cap and the party time; nudge individuals only for missing Brought ticks.
White elephant or Yankee swap variant
If you are doing a white elephant instead of a 1:1 Secret Santa, drop the Assigned recipient column and track: Item brought, Unwrap order (random numbers), Stolen? (Yes/No), Final owner. Keep the same budget cap so the pile stays fair.
Roll it into your full Christmas list
Secret Santa gifts still count toward your overall holiday spend. Copy each Brought gift into your main gift tracker under the recipient's name so one budget view covers office exchanges and family presents together.
FAQ
How do I draw Secret Santa names in a spreadsheet?
List everyone once, shuffle a copy of the names into an Assigned recipient column, then fix any self-matches by swapping. Keep that column on a host-only tab so the surprise is not spoiled.
What is a good Secret Santa budget?
Pick one number the whole group can afford — often $15 to $30 for coworkers or friends. Put the cap in a single cell and repeat it in every reminder.
How do I track who has bought their gift?
Add a Gift status column (Idea / Ordered / Bought / Wrapped / Brought) and filter for anything short of Brought a few days before the party.
Is there a ready-made Christmas gift tracker?
Yes. The Christmas Gift Tracker spreadsheet below has a 300-row gift list, per-person budgets, overspend alerts, a stocking list, holiday budget, expense log and countdown for Google Sheets and Excel. Use it for family gifts alongside your Secret Santa exchange.
More spreadsheet guides
- Credit card benefits tracker spreadsheet: how to track statement credits and annual fees
- Credit card churning spreadsheet template: track bonuses, minimum spend and your x/24 count
- Rental property analysis spreadsheet: cash flow, cap rate and cash-on-cash return formulas
- Christmas gift tracker spreadsheet: track gifts and a per-person budget in Google Sheets or Excel
- Christmas dinner planner: how to make a cooking timeline so everything is ready at once
- Holiday budget planner template: how to plan Christmas spending and stick to it
- Christmas countdown checklist: an 8 week plan to get ready for Christmas without the last minute rush
- Chase 5/24 tracker spreadsheet: count your cards and see when you drop below 5/24
- Amex Platinum credits tracker: a spreadsheet to use every monthly, quarterly and annual credit
- BRRRR calculator spreadsheet: cash left in the deal, refinance loan and cash flow formulas
- House hacking calculator spreadsheet: what you pay to live in a duplex and what it earns after you move out
- Credit card annual fee tracker spreadsheet: know when each fee posts and whether the card is worth keeping
- Credit card minimum spend tracker: hit every sign-up bonus before the deadline
- Christmas card list template: track names, addresses, cards sent and cards received
- Holiday baking plan: how to schedule Christmas cookies, pies and treats without a last minute rush
- Stocking stuffer list template: plan small gifts for everyone without overspending
- Christmas dinner shopping list: what to buy, how much, and when to buy it
- Black Friday gift budget tracker: plan what to buy and what to skip before the sales
- Cyber Monday deal tracker: log online deals against your gift budget before you buy
- Thanksgiving leftovers planner: turn turkey and sides into meals for the rest of the week
- Friendsgiving potluck planner: who brings what, dietary notes, and a simple host timeline
- Thanksgiving dinner planner: build a cooking timeline so turkey and sides finish together
- Amex Gold credits tracker: use the dining, Uber Cash, Resy and Dunkin' credits every month
- Christmas party planner checklist: guest list, budget, menu and a week-by-week countdown
Contact: m0f@mail.grokbot.com | Machine-readable: llms.txt, llms-full.txt, tools.json, openapi.json | Source: GitHub
