Add permissions to view/edit volunteer spreadsheet when new user joins data team slack

[jlegrone]

This will only work for email addresses connected to google accounts.

[jeffomatic]

@jlegrone I made a Google Apps script that grants edit privileges to members of a Slack team:

https://gist.github.com/jeffomatic/6cdc3a7c40df61da1986

I would recommend trying this out on a test spreadsheet before rolling it out to the actual spreadsheet.

To install:

• Upload the script:
  • Open the spreadsheet.
  • Go to Tools > Script editor.
  • Paste the script into the editor and save.
• Set the Slack token
  • Get an an API token for the Slack team. This API token only needs read access to the team.
  • From the script editor, go to File > Project properties > Script properties.
  • Add a new row. The key is slackToken. Paste the API token string as the value.
• Set a script trigger to run the syncSlackTeam function at whatever interval you choose. Every 5 minutes should probably suffice.

Notes:

• It should silently ignore email addresses that do not have an associated Google Drive account.
• It grants edit privileges to members of the Slack team who do not already have edit privileges.
• It doesn't keep any state, so if you remove somebody's edit privileges, but they are a member of the Slack team, their edit privileges will be restored the next time the script is run.