Skip to content

Instantly share code, notes, and snippets.

@eyalway2cu

eyalway2cu/gforms_webhook.js

Created April 27, 2020 08:47
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save eyalway2cu/c614aaf78d05b4738fd96043020c6d13 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save eyalway2cu/c614aaf78d05b4738fd96043020c6d13 to your computer and use it in GitHub Desktop.
Download ZIP
Google Forms Webhook Script
Raw
gforms_webhook.js
var POST_URL = "enter 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);
};
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment