Google Form WEBHOOK extension ERROR

Thank you so much. Great idea, little harder but works. There were some SyntaxError in the code but this one works:

var POST_URL = "YOUR_WEBHOOK_URL";

function onSubmit(e) {
  var form = FormApp.getActiveForm();
  var allResponses = form.getResponses();
  var latestResponse = allResponses[allResponses.length - 1];
  var response = latestResponse.getItemResponses();
  var payload = {};

  for (var i = 0; i < response.length; i++) {
    var question = response[i].getItem().getTitle();
    var answer = response[i].getResponse();
    payload[question] = answer;
  }

  var options = {
    "method": "post",
    "contentType": "application/json",
    "payload": JSON.stringify(payload)
  };

  UrlFetchApp.fetch(POST_URL, options);
}

Also for people who want to do it you need to:

  1. Click Save, click Run and give permissions
  2. Go to AppScript Triggers and add new trigger
3 Likes