Google Forms Slack Notification

googleforms2slack.gs

// Google Forms Slack Notification
// Andy Chase <github.com/andychase>
// License: CC0 1.0 Universal <creativecommons.org/publicdomain/zero/1.0>
// Install 1: This code goes in ( tools > script editor... ) of your google docs form
// Install 2: ( resources > current project triggers ) ( [onSubmit], [from Form], [On form submit] )

// Setup 1: Put your slack api url below
var POST_URL = "https://hooks.slack.com/services/";

function onSubmit(e) {
  var responses = e.response.getItemResponses();
  var fields = [];

  for (var j = 0; j < responses.length; j++) {
    var response = responses[j];
    var field = {
      title: response.getItem().getTitle(),
      value: response.getResponse()
    };

    fields.push(JSON.stringify(field));
  }

  var payload = { payload: '{ "fields": "' + fields + '"}' };

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

   UrlFetchApp.fetch(POST_URL, options);
}