Send Email on Google Form Submission
// The purpose of this script is to send 1+ email addresses the contents of the last response
// to your Google Form. The email is written in both plain text and HTML. The email is formatted
// so that the header and value are output. For example:
//
// Name: Andrew Curley
// Website: http://www.github.com
// etc...
function sendFormByEmail(e)
{
// Remember to replace this email address with your own email address
var emails = ["joe@example.com", "jane@example.com"];
var messageTxt = "";
var messageHTML = ""
var subject = "";
var form = FormApp.openById('<insert your form ID');
var formResponses = form.getResponses();
var lastResponse = formResponses[formResponses.length -1];
var itemResponses = lastResponse.getItemResponses();
for (var i = 0; i < itemResponses.length; i++) {
var itemResponse = itemResponses[i];
messageTxt += itemResponse.getItem().getTitle() + ': ' + itemResponse.getResponse() + "\n\n"
messageHTML += "<b>" + itemResponse.getItem().getTitle() + "</b>: " + itemResponse.getResponse() + "<br/><br/>"
}
for (var i = 0; i < emails.length; i++) {
// Get the value of the email addresss
var email = emails[i];
// Send the email
MailApp.sendEmail(email, subject, messageTxt, {'htmlBody': messageHTML});
}
}