Как получить список имен листов в Google Sheets?

PHOTO EMBED

Thu Feb 17 2022 09:00:36 GMT+0000 (Coordinated Universal Time)

Saved by @massa 

function sheetnames() { 
  var out = new Array()
  var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
  for (var i=0 ; i<sheets.length ; i++) out.push( [ sheets[i].getName() ] )
  return out  
}
content_copyCOPY

Google Sheets

https://ru.extendoffice.com/documents/excel/5222-google-sheets-get-list-of-sheets.html