Skip to content

Instantly share code, notes, and snippets.

@mcdemidov
Last active August 29, 2015 14:26
Show Gist options
  • Save mcdemidov/551dde74531f7d45edd5 to your computer and use it in GitHub Desktop.
Save mcdemidov/551dde74531f7d45edd5 to your computer and use it in GitHub Desktop.
email confirm google forms
function emailConfirm(){
var sheet = SpreadsheetApp.getActiveSheet();
var numRows = sheet.getLastRow();
var dataRange = sheet.getRange(1, 1, numRows, 6)
var data = dataRange.getValues();
for (var i = 0; i < data.length; ++i)
{
var row = data[i];
var name = row[1];
var phone = row[2];
var emailAddress = row[3];
var cat = row[4];
var subject = "Сайт | Подтверждение";
var msg = "Ваша заявка: " + name + " ," + phone + "!";
var message = "Спасибо, " + name + " ,что воспользовались нашими услугами ! " + msg + " ";
}
MailApp.sendEmail(emailAddress, subject, message);
};
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment