Alex400

function myFunction() {
  const s = SpreadsheetApp.getActiveSpreadsheet()
  const range = s.getSheetByName('Лист1').getDataRange();
  const next= range.createTextFinder('dog').findNext();
  const rez = next.getA1Notation()
  Logger.log(rez)
   }