EN: Google App Script to send answers of google forms to Slack (Incoming Webhook) / JA: Google Formsの回答をSlackのIncoming Webhookを使ってSlackに通知するGAS

google-forms-to-slack.js

function onFormSubmit(event) {
  try {
    var itemResponses = event.response.getItemResponses();
    var fields = [];
    for(var i = 0; i < itemResponses.length; i++) {
      var itemResponse = itemResponses[i];
      var title = itemResponse.getItem().getTitle();
      var res = itemResponse.getResponse();
      fields.push(generateAttachmentField(title, res));
    }
    var data = {
      icon_emoji: ':clap:',
      text: 'A new answer was submitted',
      attachments: [{
        color: '#FFFFFF',
        fields: fields
      }]
    };
    sendMessageToSlack(data);
  } catch(e) {
    handleError(e);
  }
}

function generateAttachmentField(title, value) {
  if(value.length < 1) {
    value = 'No Answer'
  }
  return {
    title: title,
    value: value,
    short: false
  } 
}

function handleError(e) {
  var data = {
    text: 'Error:' +  JSON.stringify(e)
  }
  sendMessageToSlack(data);
}

function sendMessageToSlack(data) {
  var webhookUrl = ''; // Replace with your webhook url
  var payload = JSON.stringify(data);
  var options = {
    method: 'POST',
    contentType: 'application/json',
    payload: payload
  };
  UrlFetchApp.fetch(webhookUrl, options);
}

How to use:
Set onFormSubmit as the trigger.
onFormSubmit をトリガーとして設定する。