Get first row contain value in the active Sheet (1-Index). Return 1 for empty sheet.
function getFirstRow() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
var lastColumn = sheet.getLastColumn();
var lastRow = sheet.getLastRow();