This is a Slack bot that parses the Sparkbox lunch Google Sheet and reminds us who is on duty for the upcoming Friday lunch.
To run the app there are several
ENV variables that you need to set:
URL to the Google Sheet you'll be using with your team. Here's a sample Sheet you can copy to start your own.
ID of the Google Sheet you want to parse. In our sample Sheet, the ID is
The Slack bot token you received when installing and configuring the
lunch-bot in Slack Bots
Optional: The ID of the Slack group to alert.
This is an email and public key you generate for
lunch-bot to use in reading via the Google Sheets API. To generate your
openssl pkcs12 -in *.p12 -nodes -nocerts > sheets.pem
NOTE: when prompted for password, it's
Finally, share the Sheets document to service email address using the Share button on your sheet.
Thanks to the google-sheets-api npm module for providing the instructions for