Personalize and Automate your emails via Google sheets.
https://developers.google.com/apps-s...sending_emails
Try it out for yourself its pretty cool.
Also here is a modified version for you guys that might make it easier to read.
Just paste this into google sheets > Tools > Script Editor and create your own columns.
function myFunction() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var range = sheet.getDataRange()
var values = range.getValues();
for (i=1; i<values.length; i++) {
email = values[i][0];
subject = values[i][2];
name = values[i][1];
body = values[i][3];
sender = values[i][4];
MailApp.sendEmail(email, subject,'Hi ' +name+", " +'\r\n\r\n'+ body+'\r\n\r\nSincerely, \r\n'+sender);
}
}
Cheers
-
winnermarketing -
Thanks - 1 reply
SignatureFree Guide to Make Money Online [Now!]{{ DiscussionBoard.errors[10191853].message }}-
chi124 -
Thanks
{{ DiscussionBoard.errors[10194908].message }} -
-