GAS:リストをもとに、テンプレートシートを複製し、シート名をリネームする - Qiita

const ThisSpread = SpreadsheetApp.getActiveSpreadsheet(); function createSheet(){ const name_list = createNameList(); Logger.log(name_list); const TemplateSheet = ThisSpread.getSheetByName('template'); for (let name of name_list){ const create_sheet = TemplateSheet.copyTo(ThisSpread); create_sheet.setName(name); } } function createNameList() { const name_list = []; const NamesSheet = ThisSpread.ge