Trying to send email from Google Sheet to Gmail. Tab name is Analysis

Viewed 9

Need your help and expert guidance as I need my google sheet to send emails every time a condition becomes true in "K" column which is named "Subject" as a header in the tab name "Analysis". Whenever I run the below code. Similarly last 3 lines I get while running the code as errors. Please explain in a simple possible way and not too much technical

function sendEmail(){
  var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Analysis");
  var range = ss.getRange("J2:J35");
  range.clear();
  var n = ss.getLastRow();
  for (var i = 2;i<n+1; i++){
    var emailRequired = ss.getRange(i,9).getValue();
    var subject = ss.getRange(i,11).getvalue();
    var message = ss.getRange(i,12).getvalue();
    if (emailRequired=="YES"){
      MailApp.sendEmail("ksm272364@gmail.com",subject,message);
      ss.getRange(i,10).setvalue("YES");
  }
  }
}


         1:21:51 PM Error   
TypeError: ss.getRange(...).getvalue is not a function
sendEmail   @ Code.gs:8
0 Answers
Related