'Email Notification from Alias email address
The Script:
function onFormSubmit() {
var ss = SpreadsheetApp.getActive().getSheetByName("Form responses 4");
var lastresponse = ss.getRange(ss.getLastRow(), 1, 1, 18).getValues();
var customerEmail = lastresponse[0][10];
var Subject = "sample updates # " + lastresponse[0][1];
var alias = GmailApp.getAliases();
var Message = "Hello Team" + ",<br/>"
+ "Please Find Below Details :<br/>"
+ "BN : <b>" + lastresponse[0][1] + "</b><br/>"
+ "PN : <b>" + lastresponse[0][12] + "</b><br/>"
+ "MN : <b>" + lastresponse[0][13] + "</b><br/>"
+ "MN1 : <b>" + lastresponse[0][14] + "</b><br/>"
+ "QP = <b>" + lastresponse[0][3] + "</b><br/>"
+ "QS = <b>" + lastresponse[0][4] + "</b><br/>"
+ "FR = <b>" + lastresponse[0][5] + "</b><br/>"
+ "SLR = <b>" + lastresponse[0][6] + "</b><br/>"
+ "SLRV = <b>" + lastresponse[0][7] + "</b><br/>"
+ "FR = <b>" + lastresponse[0][8] + "</b><br/>"
+ "PR = <b>" + lastresponse[0][9] +"</b><br/>"
+ "Co : <b>" + lastresponse[0][11] + "</b><br/>"
+ "<b>please do not, reply on this email.<b><br/>"
+ "Thank you";
GmailApp.sendEmail(customerEmail, Subject, Message, { from:alias[0],htmlBody: Message,name: 'Updates'});
}
I set up email notification on google form submit using alias email address but when the whole group receive email notification I am the only one who receive email from alias email address but everyone else receives email notification from my primary email address.
I am sending email notification using workspace account. Email notification set up using Appscript.
Is there anything I am missing to set this up for all?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
