CODEWITHSUNDEEP
google-apps-script
Blanchard Valley Center
Blanchard Valley Center

Reputation: 13

Google Forms Complex Email Send on Form Submit with Script

I have this right now as a script to send an email to myself as a test showing that there is a new application submitted, but I am looking to have a full-fledged email sent to our HR department giving the name of every field following by a : and a space then what their answer was. I know you can do this and have found a script that I tried to get to work, but it kept failing and the developer was no help in trying to help me fix it. I really would love to get this done for my HR department so that we can move on from creating a new application. Here is my code so far, I removed my email for privacy issues:

function sendFormByEmail(e){
  var email = "emailgoeshere";
  var subject = "A New Employment Application has been Submitted"; 
  var message = "A New Application Has Been Submited. Please go to the spreadsheet for more details.";
  MailApp.sendEmail(email, subject, message);
}

Thanks again!

Upvotes: 1

Views: 10359

Answers (2)

Serge insas
Serge insas

Reputation: 46792

Or you could try this very simple one :(read carefully comments in the script)

function sendFormByEmail(){
var email = "email adress comes here";
var subject = "A New Employment Application has been Submitted";
var message = "A New Application Has Been Submited. Please find the details below :";
var row = SpreadsheetApp.getActiveSpreadsheet().getLastRow();// assuming data is on the last row of the spreadsheet
var messagebody=createmessage(row);
MailApp.sendEmail(email, subject, message+messagebody);
}
//
function createmessage(row){
   var sh = SpreadsheetApp.getActiveSheet();
   var ss = SpreadsheetApp.getActiveSpreadsheet();
   var lastCol = ss.getLastColumn();
   var LF=  "\r\n"
   var body = LF
   var headers = sh.getRange(1,1,1,lastCol).getValues();
   var data = sh.getRange(row,1,1,lastCol).getValues();
   for(nn=0;nn<headers[0].length;++nn){
     body+=headers[0][nn]+" : "+data[0][nn]+LF
     }
Logger.log(body)
return body
}
//
//eof

As mentionned, data coming from the form must be on last row of data in the sheet and there must be some data to check how it works otherwhise answers=questions.

Upvotes: 6

Henrique G. Abreu
Henrique G. Abreu

Reputation: 17752

I've developed a script that might help you, it's called FormEmailer. You can find it in the Script Gallery or grab the code on its site.

Upvotes: 0

Related Questions