App script get sheet row number by specific value

get_row_by_valye.gs

function getRowNumberByValue() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');
  const searchValue = 'value to search for';
  const dataRange = sheet.getRange('A:A');
  const values = dataRange.getValues();
  
  for (let i = 0; i < values.length; i++) {
    if (values[i][0] === searchValue) {
      const rowNumber = i + 1;
      Logger.log(`Found "${searchValue}" at row ${rowNumber}`);
      return rowNumber;
    }
  }
  
  Logger.log(`"${searchValue}" not found`);
  return null;
}