google sheets get sheet by name
snippet in javascript

google sheets get sheet by name

user9490

var sheet = SpreadsheetApp.getActive().getSheetByName('YourSheetNameHere')