Last-value-row


var sss = SpreadsheetApp.openById('xxxxxxxxxxxxxxxxxxxxxxxxxxx');
var sh1 = sss.getSheetByName('Sheet1');

function lastRow(){
var column = "D"
var lastRow = sh1.getLastRow();
var lastRowRange=sh1.getRange(column+lastRow);

for (let g = lastRow; g > 1; g--) {
var lastRowRange=sh1.getRange(column+g);
var va = lastRowRange.getValue()
if(va.length!=0){notif(va);return}
}


}