Push email notification for Google form submissions

emailNotification.gs

/**
* @OnlyCurrentDoc
*/

function Initialize() {
 
    var triggers = ScriptApp.getProjectTriggers();
 
    for (var i in triggers)
        ScriptApp.deleteTrigger(triggers[i]);
 
    ScriptApp.newTrigger("SendGoogleForm")
        .forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet())
        .onFormSubmit().create();
}

function copynotemptycardorders(){
var sheet = SpreadsheetApp.getActiveSheet();
var data = sheet.getDataRange().getValues(); 
for ( var i = 0; i < data.length ; i++){
  if (data[i][1] != ''){  // Column B is at index 1
    // Do whatever you want
  }
}
}
 
function SendGoogleForm(e) {
 
    if (MailApp.getRemainingDailyQuota() < 1) return;
    var s = SpreadsheetApp.getActiveSheet();


// Ensure you have the correct column for the timestamp
  var timestamp = e.values[0];
  
  // Get the range of values
  var cardsToOrder = s.getRange(2, 1, 12,2).getValues()[0];
  
 // Change these variables to match your spreadsheet. Keeping the vars I used for example purposes. (Purpose of this form was to log product orders and notify admin of qty)
 var christmasA = e.values[1];
 var christmasB = e.values[2];
 var christmasC = e.values[3];
 var birthday = e.values[4];  
 var allOccasionA = e.values[5];
 var allOccasionB = e.values[6];
 var mothersDay = e.values[7];
 var easter = e.values[8];  
 var inLovingMemoryA = e.values[9]; 
 var inLovingMemoryB = e.values[10];
 var Recovery = e.values[11]; 
    var thankYou = e.values[12];
    var name = e.values[13];
    var address = e.values[14];
    var city = e.values[15];
    var province = e.values[16];
    var postal = e.values[17];
    var phone = e.values[18];
    var emailAddress = e.values[19];
    var memberNumber = e.values[20];
      
  
  MailApp.sendEmail({
    //add email address between quotations
    to: "",
    //Modify email template below
    subject:"ENROLLMENT CARD ORDER: " + emailAddress, 
    htmlBody: "A new enrollment card order has been submitted." +
    "<style>table,tr{border: 1px solid black; border-collapse: collapse;}td{padding: 5px 15px;}</style><hr />Name: " + name +
    "<br />Email: " + emailAddress +
    "<hr /><strong>Cards ordered:</strong><br /><br />" + 
    "<table style='width=50%;'>" +
    "<tr style='background-color:#f1f1f1;'><td>Christmas A</td><td>" + christmasA + "</td></tr>" +
    "<tr><td>Christmas B</td><td>" + christmasB + "</td></tr>" +
    "<tr style='background-color:#f1f1f1;'><td>Christmas C</td><td>" + christmasC + "</td></tr>" +
    "<tr><td>Birthday</td><td>" + birthday + "</td></tr>" +
    "<tr style='background-color:#f1f1f1;'><td>All Occasion A</td><td>" + allOccasionA + "</td></tr>" +
    "<tr><td>All Occassion B</td><td>" + allOccasionB + "</td></tr>" +
    "<tr style='background-color:#f1f1f1;'><td>Mothers Day</td><td>" + mothersDay + "</td></tr>" +
    "<tr><td>Easter</td><td>" + easter + "</td></tr>" +
    "<tr style='background-color:#f1f1f1;'><td>In Loving Memory A</td><td>" + inLovingMemoryA + "</td></tr>" +
    "<tr><td>In Loving Memory B</td><td>" + inLovingMemoryB + "</td></tr>" +
    "<tr style='background-color:#f1f1f1;'><td>Recovery</td><td>" + Recovery + "</td></tr>" +
    "<tr><td>Thank You</td><td>" + thankYou + "</td></tr>" +
    "</table><br />" +    
    "<hr /><strong>Send cards to:</strong><br /><br />" +
    name + "<br />" + address + "<br />" + city + "<br />" + province + "<br />" + postal + "<br />" + "<br />" + phone + "<br />" + emailAddress + "<br />" + "Member Number: " + memberNumber +
    "<hr />Date and Time of Order: " + timestamp,
                    
  });

}