1

Using Google Script user receiving email with Image, Once user click the image i want automatically go to another URL like(www.google.com) I used the below coding in google Script

function sendEmails()
{

var message    = GmailApp.getDraftMessages()[0];
var bodyText   = message.getBody();
var rawContent = message.getRawContent();
var sheet = SpreadsheetApp.getActiveSheet();
var startRow = 2;
var  numRows = (sheet.getLastRow())-1; 
Logger.log(numRows);
var dataRange = sheet.getRange(startRow, 1, numRows, 5)
var data = dataRange.getValues();
Logger.log(data)
for (i in data)
{
var row = data[i];
var emailAddress =row[0];
var Name=row[1];
var googleLogoUrl = row[3];
var url = sheet.getRange("c"+i).getValue();
var googleLogoBlob = UrlFetchApp
                  .fetch(googleLogoUrl)
                   .getBlob()
                   .setName("Test");
   MailApp.sendEmail({
     to:test@example.com,
     subject: "test",
     htmlBody: "<img src='cid:googleLogo'> images! <br>",
     inlineImages:
       {
        googleLogo: googleLogoBlob,   
       }
       });
  }
}
Saravanan
  • 23
  • 4

0 Answers0