Skip to content

Instantly share code, notes, and snippets.

@aniav

aniav/send_email.gs

Created Feb 10, 2015
Embed
What would you like to do?
Send Confirmation Email with Google Forms
/* Send Confirmation Email with Google Forms */
function Initialize() {
var triggers = ScriptApp.getProjectTriggers();
for (var i in triggers) {
ScriptApp.deleteTrigger(triggers[i]);
}
ScriptApp.newTrigger("SendConfirmationMail")
.forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet())
.onFormSubmit()
.create();
}
function SendConfirmationMail(e) {
try {
var ss, sendername, subject, columns, from;
var message, value, textbody, sender;
// This is one of your identities in gmail
// you have to set the identity in gmail beforehand
from = 'your_city@djangogirls.org';
// This will show up as the sender's name
sendername = "Django Girls Your City";
// Optional but change the following variable
// to have a custom subject for Google Docs emails
subject = "Thank you for filling out our form";
// This is the body of the auto-reply
message = "We have received your details.<br>Thank you!<br> Below is a simple summary of your responses<br><br>";
ss = SpreadsheetApp.getActiveSheet();
columns = ss.getRange(1, 2, 1, ss.getLastColumn()).getValues()[0];
// This is the submitter's email address
sender = e.namedValues["Your e-mail address:"].toString();
// Only include form values that are not blank
for ( var keys in columns ) {
var key = columns[keys];
if ( e.namedValues[key] ) {
message += key + ' : '+ e.namedValues[key] + "<br />";
}
}
textbody = message.replace("<br>", "\n");
GmailApp.sendEmail(sender, subject, textbody,
{from: from, name: sendername, htmlBody: message});
} catch (e) {
Logger.log(e.toString());
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.