Personalize and Automate your emails via Google sheets.

by chi124
2 replies
Hey all thought I share an interesting tool we can all use for personalizing and automating our emails via Google sheets.

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);


#automate #emails #google #personalize #sheets
  • Profile picture of the author winnermarketing
    Google alway develope new interesting tool.
    So thanks for sharing.

    What about spam: how many mail (in %) will be directed in spam to subscribers?
    the same number both with gmail users and others?

    thank you!

    Free Guide to Make Money Online [Now!]
    {{ DiscussionBoard.errors[10191853].message }}
    • Profile picture of the author chi124
      thats a good question. i havent tested it out fully as I just used in house for fun. anyone else want to chime in?
      {{ DiscussionBoard.errors[10194908].message }}

Trending Topics