Slackbot message integration using incoming webhooks with Google Apps Script
This can generally be used for any project involving a Slack bot sending some message based on the values of a spreadsheet.
You first need to set up a bot on Slack with an incoming webhook (see this guide). Then you can set up the script as a Google Apps Script (see this guide) and configure timed triggers to automate the messages.
For my case, I had a spreadsheet on the form
| Date | First name | Second name |
|---|---|---|
| __ | __ | __ |
| __ | __ | __ |
and I wanted the bot to tag the users (based on their first names) in a specific channel when today's date matches that of the date column. This is done with a predefined payload whose names (or tags of user IDs based on names) are inserted based on the lookup of the date.
By scheduling the script every day, this process is completely automated.
