Slack invite integration for Google Forms

how-to.md

1. Create a Google Form with a field to collect email addresses. Pro-tip: use Data Validation to validate string is valid email.
2. Click View Responses to view form responses in Google Spreadsheets.
3. Open menu Tools > Script editor...
4. Paste in Google App Script below and make the following changes:
   • Create a Slack API token and replace the value of SLACK_API_TOKEN.
   • Replace "YOUR_TEAM_NAME" with your team's name in the value for SLACK_API_INVITE_URL.
   • Make sure EMAIL_FIELD_NAME corresponds to the header text of your Google Spreadsheet's email column.
5. Open menu Resources > Current project's triggers and add a new trigger: onFormSubmit, From spreadsheet, On form submit. Click Save and accept the authorization request to use the script.
6. You can optionally configure notifications to receive error messages by email.

invite-user.js

var SLACK_API_TOKEN = 'xxxx-xxxxxxxxxx-xxxxxxxxxx-xxxxxxxxxxx-xxxxxxxxxx';
var SLACK_API_INVITE_URL = 'https://YOUR_TEAM_NAME.slack.com/api/users.admin.invite';
var EMAIL_FIELD_NAME = 'E-mail Address';

function inviteUser(email) {

  var data = {
    email: email,
    token: SLACK_API_TOKEN,
    set_active: 'true'
  };
  
  var options = {
    method: 'POST',
    payload: data
  };

  UrlFetchApp.fetch(SLACK_API_INVITE_URL, options);
}

function onFormSubmit(e) {
  var email = e.namedValues[EMAIL_FIELD_NAME][0];
  inviteUser(email);
}

Works great!

Add

  var r = UrlFetchApp.fetch(SLACK_API_INVITE_URL, options);
  if (r.getResponseCode() != 200) {
    throw new Error('Error sending invitation: ' + r.getResponseCode() + '\n' + r.getContentText());
  }

to the end of the inviteUser function for some better error feedback!

Is this still valid to use after all these years? We are looking to use something for people who want to invite external members to our slack partners channel.

Is this still valid to use after all these years? We are looking to use something for people who want to invite external members to our slack partners channel.

🤷 give it a try? I haven't had need for it since I wrote it.

Relevant links:
https://api.slack.com/authentication/token-types
https://api.slack.com/docs/rate-limits
https://api.slack.com/methods/admin.users.invite
The last one says it's only available for "Enterprise Grid".

The schema has changed a bit so it's definitely not plug-and-play anymore.