gscript get data from named sheet code example
Example: google sheets get sheet by name
var sheet = SpreadsheetApp.getActive().getSheetByName('YourSheetNameHere')
var sheet = SpreadsheetApp.getActive().getSheetByName('YourSheetNameHere')