GSheetsToSlack is a script written for Google Sheets that allows Slack's API to pull data from your spreadsheet. This means you can create a Slack Bot, a slash command or any other custom integration in Slack. In this case, this script was written to accomodate my on-campus organization's needs (UNICEF at Illinois Tech).
At UNICEF, we use Slack for communication between our members. We initially used GroupMe but realized that Slack was much more powerful and open to customization. We also use a point system to keep track of members' volunteering hours, attendance, and eligibility for prizes. This point system is updated via a private spreadsheet on Google Drive accessible only to our executive board. The biggest problem was members had no way of instantly seeing their points. This script is that answer! Members are able to see their own points by simply typing a slash command, "/points".
For reference, the spreadsheet's layout is as follows:
| First Name | Last Name | Total Points | Event 1 | Event 2 | More Events | |
|---|---|---|---|---|---|---|
| Pratik | Sampat | [email protected] | 5 | 2 | 3 | 0 |