teste google script
function sendEmails() { var ss=SpreadsheetApp.openById("ssid"); var sheet=ss.getSheetByName('**********Your sheet name***********'); var startRow=2; var numRows=2; var dataRange=sheet.getRange(startRow, 1, numRows, 2); //changed to getDisplayValues var data=dataRange.getDisplayValues(); //changed to for loop for (var i=0;i<data.length;i++) { var row=data[i]; var emailAddress=row[0]; var message=row[1]; var subject='Sending emails from a Spreadsheet'; MailApp.sendEmail(emailAddress, subject, message); } }
Source: stackoverflow.com