get last row google scripts
//To get last row of the sheet.
var LastRowOfSheet = SpreadsheetApp.getActive().getActiveSheet().getRange('a:a').getLastRow();
//To get last row with value in it.
var LastRow_WithValue = SpreadsheetApp.getActive().getActiveSheet().getLastRow();