Post Google Forms Submissions to Slack with Google Scripts

P
Published in: Google Apps Script - Google Forms

Andy Chase has published a Google Script that will let you automatically post Google Form submissions to a Slack channel. You need to place the script inside the script editor of your Google Forms editor and associate the onSubmit() method with the Form Submit trigger.

// replace this with your own Slack webhook URL
// https://crowdscores.slack.com/services
var webhookUrl = 'https://hooks.slack.com/services/****/****/****';

function onSubmit(e) {
  var response = e.response.getItemResponses();

  // Setup 2:
  // Modify the below to make the message you want.
  // See: https://developers.google.com/apps-script/reference/forms/form-response
  var d = e.response.getRespondentEmail() + " | " + response[0].getResponse();

  var payload = {
    "payload": '{"text": "' + d + '"}'
  }

  var options = {
    "method": "post",
    "payload": payload
  };

  UrlFetchApp.fetch(webhookUrl, options);
};
Published in: Google Apps Script - Google Forms

Looking for something? Find here!

Meet the Author

Web Geek, Tech Columnist
A
Amit Agarwal

Amit Agarwal is a Google Developer Expert in GSuite and Google Apps Script. He holds an engineering degree in Computer Science (I.I.T.) and is the first professional blogger in India. Read more on Lifehacker and YourStory

Get in touch