Hello 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) | Name | Website | Fun fact | isActive |
|---|
- 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)
- Create a weekly trigger to call the
runfunction every week - Ask people to subscribe Coffeebot by putting their names in the Google Sheet from #1
If the isActive column is 'paused', then the user will be skipped. Good for vacations, etc.