Gscript TOC

function onOpen(){
  SpreadsheetApp.getUi()
  .createMenu("Scripts")
  .addItem("Add TOC to Current Cell", "TOC")
  .addToUi();
}

function TOC() {
  let ss = SpreadsheetApp.getActive()
  let activeSheet = ss.getActiveSheet()
  let sheets = ss.getSheets()
  let activeRange = activeSheet.getActiveRange()

  let values = []

  for (i = 0; i < sheets.length; i++) {
    console.log(sheets[i].getName())
    let value = SpreadsheetApp.newRichTextValue()
      .setText(sheets[i].getName())
      .setLinkUrl("#gid=" + sheets[i].getSheetId())
      .build();

    values.push([value])
    console.log(value)
  }
  let range = activeSheet.getRange(activeRange.getRow(), activeRange.getColumn(), values.length, 1)
  range.setRichTextValues(values)
}