Sending email from a Google Sheet using AppScript

M.Bilal Nawaz answered on December 14, 2022 Popularity 7/10 Helpfulness 3/10

answer Sending email from a Google Sheet using AppScript

Sending email from a Google Sheet using AppScript

Comment

function sendEmail() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var startRow = 2;  // First row of data to process
  var numRows = 2;   // Number of rows to process
  var dataRange = sheet.getRange(startRow, 1, numRows, 3) // Fetch the data
  var data = dataRange.getValues();

  for (var i = 0; i < data.length; ++i) {
    var row = data[i];
    var emailAddress = row[0];  // First column
    var message = row[1];       // Second column
    var subject = row[2];       // Third column

    MailApp.sendEmail(emailAddress, subject, message);
  }
}

Popularity 7/10 Helpfulness 3/10 Language javascript

Source: Grepper

Tags: email javascript

Link to this answer
Share Copy Link

Contributed on Dec 14 2022

M.Bilal Nawaz

0 Answers Avg Quality 2/10

Sending email from a Google Sheet using AppScript

Contents

More Related Answers

Sending email from a Google Sheet using AppScript

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.