acurley
5/21/2015 - 12:17 AM

Send Email on Google Form Submission

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}); 
  }

}