Google Apps Script to post a message to Slack when someone responds to a Google Form.

slack-hook.gs

/**
 * ABOUT
 * Google Apps Script to post a message to Slack when someone responds to a Google Form.
 * 
 * Uses Slack incoming webhooks - https://api.slack.com/incoming-webhooks
 * and FormsResponse - https://developers.google.com/apps-script/reference/forms/form-response
 * 
 * 
 * AUTHOR
 * Akash A <github.com/akash1810>
 * 
 * 
 * USAGE
 * Free to use.
 */

// Create an incoming webhook here - https://api.slack.com/incoming-webhooks
var POST_URL = "https://hooks.slack.com/services/XXXX/XXXX/XXXX";

function onSubmit(e) {
  var response = e.response.getItemResponses();
  
  var fields = [
    {"title": "From", "value": e.response.getRespondentEmail()},
    {"title": "When", "value": e.response.getTimestamp()}
  ];
  
  for (var i = 0; i < response.length; i++) {
    var question = response[i].getItem().getTitle();
    var answer = response[i].getResponse();
    
    fields.push({"title": question, "value": answer});
  }
    
  var summaryAttachment = {
    "fallback": FormApp.getActiveForm().getTitle(),
    "pretext": "<!channel> New response submitted to: " + FormApp.getActiveForm().getTitle(),
    "title": FormApp.getActiveForm().getTitle() + " (responses)",
    "title_link": "https://docs.google.com/spreadsheets/d/" + FormApp.getActiveForm().getDestinationId(),
    "fields": fields,
    "color": "#393939"
  };
  
  var responseAttachment = {
    "fallback": FormApp.getActiveForm().getTitle(),
    "title": "Respond via email? (mailto link)",
    "title_link": "mailto:" + e.response.getRespondentEmail() + "?Subject=" + encodeURI(FormApp.getActiveForm().getTitle())
  };

  var options = {
    "method" : "post",
    "payload": JSON.stringify({
      "username": "Feedback",
      "icon_emoji": ":speech_balloon:",
      "attachments": [summaryAttachment, responseAttachment]
    })
  };

   UrlFetchApp.fetch(POST_URL, options);
};

For response attachment to open in gmail:

var responseAttachment = {
    "fallback": FormApp.getActiveForm().getTitle(),
    "title": "Respond via email?",
    "title_link": "https://mail.google.com/mail/u/0/?view=cm&fs=1&tf=1&source=mailto&to=" + e.response.getRespondentEmail()
  };

Not working anymore?

@gchiacchio sorry, I missed your message.

I've just setup a new Google form and got it working. It didn't work right away though - I used View -> Execution transcript to debug which told me there was no Google Sheet attached to the form for responses, which is needed.

What errors are you seeing?

Hi.
Got this error for transcript...

[17-02-13 13:32:56:561 GST] Starting execution
[17-02-13 13:32:56:570 GST] Execution failed: TypeError: Cannot read property "response" from undefined. (line 21, file "Code") [0.001 seconds total runtime]

Pretty new to google scripts... so that might be really trivial.... :-S

Thanks

My bad... works perfectly: had not done the project trigger bit...

Great code. Simple and to the point

@laurentades no worries. Glad you find it useful. 😄

Hey @laurentades I also have the "TypeError: Cannot read property "response" from undefined. (line 21, file "Code") " - how did you fix? project trigger? (I've accepted the authorisations). also Thx @akash1810 for the script.

Same error for me as well.
TypeError: Cannot read property "response" from undefined. (line 21, file "Code")

I have set up the trigger, fyi.

I was having this same issue. I solved it by removing the trigger, and then creating it again.

This script is very elegant and works beautifully. However, Google Forms just released a feature where you can set a questions as 'file upload' and accept a file. How can I use this script to handle the file as a 'value' to pass to Slack? I've used the Logger to debug and I can see that the 'answer' variable can hold the file submitted through Google Forms, and pushes it to the 'fields' variable. However, it doesn't get passed through to Slack. Any suggestions to handle the new file upload question?

Nice script. How would you modify it to only apply to certain scripts? I'm not sure where to install the getId() method, whether as a variable or somehow nested in the getItemResponses method?

This is my experience as a beginner :

TypeError: Cannot read property "response" from undefined. (line 21, file "Code")

Solution : Ensure Google Sheet attached to the form for responses, in the Form Response you can click spreadsheet logo to create spreadsheet

Also :

• Ensure that you create the script inside the form,

• Ensure to create a trigger (from the script menu > Current Trigger > add Trigger

I have questions, my forms is using checkbox, it seems the answer is not posted on slack, can you help me? @akash1810 ?