A serverless robot that matches people to have coffee. Runs on Google Apps Script (free with GSuite).
🤖 Greetings, humans! I understand you enjoy partaking in hot beverages in a social setting, so I am here to assign a random other human to have coffee with you each week.
- Humans sign up for Coffeebot by putting their email and other info in a Google Sheet
- Every Monday morning, I match the humans into pairs and email them about it
- Humans receive their emails and manually set up coffee appointments in their human calendars.
-
Create a new spreadsheet in Google Sheets
-
Make the first row look like this:
Email (required) Cadence (required) Name Website LinkedIn Twitter Fun fact -
Create a new Apps Script in Google Drive.
-
Copy-and-paste the code from coffeebot.js
- Change
SHEET_ID
to point to your Google Sheet from #1 - Change
HELP_EMAIL
to point to your email address (so people have someone to complain to)
- Change
-
Create a trigger that calls the
run
function every week -
Ask people to subscribe Coffeebot by putting their names in the Google Sheet from #1
- Email: the address where the match email will be sent.
- Cadence: one of "weekly, "biweekly", "monthly", or "paused"
- Everything else: just type whatever information you want other humans to see when you're matched with them.
I wish you a pleasant human bonding activity.
Beep beep bop.