ChoreBot is primarily a service that takes assigned tasks right from a Google Sheet and posts them in a Slack channel. It allows chores to be assigned well in advance to ease the life of whoever does the scheduling. Secondarily, ChoreBot feeds headsup with chore data to keep our info board updated.
Setup of ChoreBot involves a few steps, but it isn't very difficult. You'll need to create an app on Slack, load our code onto your server, make a service account on Google, and set some environment variables.
- Head over to Slack's app portal, and create a new app.
- Make sure you turn on "interactive components" and set your request URL to wherever you will be hosting the app. By default, Bolt's event endpoint is
/slack/events, so your URL should probably end in that. - Create a bot user and call it whatever you wish.
- After that, head up to "Install App" and install your app. Slack will take you through the permission approval process. You'll probably end up with an email that says you added an integration to your workspace.
- Take note of the
Bot User OAuth Access Tokenand theSigning Secret, the latter of which can be found on the "Basic Information" page.
Two things are needed from Google: a spreadsheet must be created, and a service account must be made and given access to the sheet.
Your spreadsheet should comply with the following format:
| Date | Chore |
|---|---|
| 2019-10-04 | Chore1 |
| 2019-10-04 | Chore2 |
| 2019-10-05 | NextDayChore1 |
| .. | .. |
Note the format of the date (YYYY-MM-DD) and the fact that multiple chores can be listed per day, so long as the Date remains constant. If desired, you can use standard sheets formulas to produce any of the data in the spreadsheet.
Create a service account using these instructions. Once it's created, share the previously created spreadsheet with the service account's address. View-only permissions should be fine; we're only reading data from the sheet.
You can easily deploy this app using Docker Compose. Your docker-compose.yml file should look something like the following (we use Traefik for routing, FYI):
chorebot:
build: https://github.com/rpiambulance/chorebot.git
container_name: chorebot
restart: always
mem_limit: 500m
labels:
- "traefik.port=3000"
- "traefik.frontend.rule=Host:chorebot.your_server_address.com"
environment:
- SPREADSHEET_ID=<spreadsheet ID>
- SLACK_BOT_TOKEN=<xoxb Slack token>
- SLACK_SIGNING_SECRET=<signing secret>
- CHORES_CHANNEL=<channel>
- CRON_SCHEDULE=0 18 * * *
- TZ=America/New_York
volumes:
- /drone/chorebot/keys/sheets-api.json:/usr/src/app/keys/sheets-api.json
Fill in the environment variables as appropriate, and run a docker-compose up -d chorebot, or whatever you named your service.
ChoreBot is provided under the MIT License.
For any question, comments, or concerns, email [email protected], create an issue, or open up a pull request.