Free Coffee Roulette Spreadsheet Template
(and When to Stop Using One)
If you're randomly pairing colleagues for coffee chats using a spreadsheet, this template will save you an hour every time you run it. If you've been running it for six months and it's becoming a part-time job, you'll also want to read the second half.
The free template
Here's the simplest structure that actually works. You can build this in Google Sheets or Excel in about 20 minutes.
Tab 1: Members
Tab 2: Match History
The random pairing formula (Google Sheets)
Put this in a helper column to generate a random sort order for your active members, then match row 1 with row 2, row 3 with row 4, etc:
=IF(D2="Y", RAND(), "")
Then sort by this column. Each time you want new pairs, clear the column and recalculate. Important: paste-as-values before sharing, otherwise the pairs will reshuffle every time someone opens the sheet.
The email template
Once you have pairs, you need to tell people. The most common mistake is sending a group announcement — most people skim it and assume someone else will reach out. Individual emails work better.
Subject
☕ Coffee match: you and [Name] — [Month]
Body
Hi [Name],
This month's coffee match has you paired with [Match name] ([Match team]).
They're at [match email] — whoever reaches out first gets a virtual coffee. 15–30 mins, no agenda needed.
Hope you have a great chat!
[Your name]
Tip: add the match's job title if you have it. "You're matched with Sarah in Product" is much more compelling than just an email address.
What to track
Most spreadsheets collapse because nobody tracks whether meetings actually happen. Add a fifth column to your Match History tab:
Ask people to reply to your email with a simple "We met!" — it's a two-second ask and gives you real data. If a match consistently shows "N", investigate: did one person leave? Are they in incompatible time zones? Are your rounds too frequent?
When the spreadsheet stops working
The spreadsheet works brilliantly when you have 8–25 people and you enjoy running it. It breaks down in predictable ways:
It takes 45 minutes a month
At 40 people, generating pairs manually, checking history to avoid repeats, personalising 20 individual emails, and chasing non-responses adds up. The person running it is burning significant goodwill for a job that should be automated.
The organiser goes on holiday
Coffee roulette only works if it runs consistently. When the spreadsheet person is away for two weeks, the whole thing stops. People assume it's been cancelled. Re-engagement after a gap is hard.
The team grows past 30
Managing pauses, opt-outs, people who joined mid-cycle, different cadences (some people monthly, some quarterly), and avoiding repeats across 30+ people in a manual spreadsheet is genuinely hard. Something breaks every round.
The organiser leaves
The spreadsheet is undocumented institutional knowledge. When the organiser moves teams or leaves the company, coffee roulette usually dies with them — even if someone new wants to keep it going.
The hybrid: keep your credit, lose the admin
The reason people keep running the spreadsheet long after it becomes painful is that they want credit for the programme. Being "the person who runs coffee roulette" is a genuine contribution to team culture — it shouldn't disappear just because you automate the mechanism.
CoffeeMatch is designed around this. When you switch from a spreadsheet:
- → Individual match emails go directly to members — nobody is waiting on you
- → Three days before each round, you get a pre-written announcement to share in your team channel (you can edit it, add context, make it yours)
- → After the round runs, you get a post-match summary to share — again, editable
- → History is tracked automatically so you never pair the same people twice in a row
- → Members can pause themselves if they're on holiday — you don't have to manage it
You're still the organiser. You still get the Slack message saying "this is brilliant, thanks for running it." You're just not the bottleneck anymore.
Getting started in 15 minutes
The fastest onboarding path:
-
1
Create a group in the app. Name it, set your cadence, and you'll get a join link to share with your team — paste it into Slack, forward it to your distribution list, or drop it in a team email. Each person clicks once to join.
-
2
Or paste your list manually. In the group creation wizard, paste your team's email addresses. Everyone gets an invite link — they click once to join.
-
3
Set your cadence. Monthly is the most popular for teams of 15–50. Weekly works for tight cohorts of 8–12.
-
4
The first match runs automatically. You'll get an email to preview and share. Members get matched directly.
Free to try — 1 group included free
No credit card needed. Pro from £19/mo billed annually.