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:
- Click Save, click Run and give permissions
- Go to AppScript Triggers and add new trigger