Skip to content

Instantly share code, notes, and snippets.

@fastmover
Created May 31, 2017 22:08
Show Gist options
  • Select an option

  • Save fastmover/50d4dbbf46a9e0bba5efcf74bf693394 to your computer and use it in GitHub Desktop.

Select an option

Save fastmover/50d4dbbf46a9e0bba5efcf74bf693394 to your computer and use it in GitHub Desktop.
This will email a response to a form submission from Google Forms. Be sure to set the current project triggers to Run emailResponse from form submission.
function emailResponse(e) {
var form = FormApp.getActiveForm();
var formResponses = form.getResponses();
for (var i = 0; i < formResponses.length; i++) {
var formResponse = formResponses[i];
var itemResponses = formResponse.getItemResponses();
var output = "";
var htmlOutput = "<h1>Form Response</h1><hr>";
for (var j = 0; j < itemResponses.length; j++) {
var itemResponse = itemResponses[j];
output += itemResponse.getItem().getTitle() + ": " + itemResponse.getResponse() + "\n\n\n";
htmlOutput += "<b>" + itemResponse.getItem().getTitle() + "</b>: " + itemResponse.getResponse() + "<br><br>";
}
}
MailApp.sendEmail('[email protected]', 'E-Mail Subject', output, {
htmlBody: htmlOutput,
name: 'Web Form',
noReply: true
});
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment