GoogleFrom to Slack by GAS

google_form_to_slack_by_gas.md

1. set incoming-webhook at slack

• click channel name
• Add an app
• incomming-webhook
• add configration
• set target channel and bot name
• get url

2. add gas

function sendToSlack(body) {
  var url = "https://hooks.slack.com/services/xxxxxxxxxx";
  var data = {
    "icon_emoji": ":xxxxxx:",
    "attachments": [{
      "color": "good",
      "title": "Google Form",
      "text" : body,
    }],
  };
  var payload = JSON.stringify(data);
  var options = {
    "method" : "POST",
    "contentType" : "application/json",
    "payload" : payload
  };
  var response = UrlFetchApp.fetch(url, options);
}

function onFormSubmit(e){
  var body = "```\n"; 
  var itemResponse = e.response.getItemResponses();
  for (var j = 0; j < itemResponse.length; j++){    
    var formData = itemResponse[j];
    body += formData.getItem().getTitle() + ": ";
    body += formData.getResponse() + "\n";
  }
  body += "```"
  sendToSlack(body);
}

function test(){
  sendToSlack("test notification");
}

3. test

• do test method

4. deploy

• choose onFormSubmit method
• click timer icon
• set trigger on submit