The auto mail sending google sheet scripts | Arfius
function BulkEmailSender() { varA = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“Sheet1”); varB = A.getLastRow(); for (varC = 2; C <= B; C++) { varEmailList = A.getRange(C, 1).getValue(); varSubjectList = A.getRange(C, 2).getValue(); varMessageList = A.getRange(C, 3).getValue(); MailApp.sendEmail(EmailList, SubjectList, MessageList); } }