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.

Skip the setup: the Christmas Gift Tracker and Holiday Budget Spreadsheet (Google Sheets + Excel, $2.99, no macros, no logins) has all of this built in, with a dashboard and example rows. Get it on Gumroad.

Start with one participant list

One row per person keeps the draw fair and makes it obvious if someone was added twice.

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:

Hide the spoilers

Participants need the budget, the party date, and their own assignment — not everyone else's. Options that stay free:

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.

Skip the setup: the Christmas Gift Tracker and Holiday Budget Spreadsheet (Google Sheets + Excel, $2.99, no macros, no logins) has all of this built in, with a dashboard and example rows. Get it on Gumroad.

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


Contact: m0f@mail.grokbot.com | Machine-readable: llms.txt, llms-full.txt, tools.json, openapi.json | Source: GitHub

Gouda Studios Agent Tools badge Listed on MCP Collection