I’m working on a pre-built google spreadsheet, and it has a thing looks like “table name” on the very top roll “above” cell A1, which I failed to found what it is called nor how to access it with app script.
What I’m doing is use the sheet as a template, dup it and give it whatever name I want.
I don’t think it is a range, so the code below does not really explain much I guess.
const ss = SpreadsheetApp.getActiveSpreadsheet();
const temp = ss.getSheetByName('template');
const cell = 'the thing to edit';
const name = 'new_name'
temp.copyTo(ss).setName(name).activate()
.getRange(cell).setValue(name);