Google Docs Survey Emailer

gistfile1.js

function onFormSubmit(e) {
  var to_email = "[email protected]";
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var spreadsheet_name = ss.getName();
  var sheet = ss.getSheets()[0];
  var columns = sheet.getRange("A1:U1").getValues()[0];

  var email_subject = "New response for [" + spreadsheet_name + "]";
  var email_body = "Spreadsheet: " + spreadsheet_name + "\r\n\r\n";
  var email_body_html = "<p><b>Spreadsheet: " + spreadsheet_name + "</b></p>";
  
  for (var i = 0; i < columns.length; i++) {
    var question = columns[i];
    if (question != "") {
      var answer = e.values[i];
      email_body = email_body + question + "\r\n" + answer + "\r\n\r\n";
      email_body_html = email_body_html + "<p><b>" + question + "</b><br/>" + answer + "</p>";
    }
  }

  var optAdvancedArgs = {replyTo: to_email, htmlBody: email_body_html};  
  MailApp.sendEmail(to_email, email_subject, email_body, optAdvancedArgs);
}