如何在合并工作表的同时将工作表名称放在google sheets中的新列中？

function mergeAndAddSheetNames() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheets = spreadsheet.getSheets();
  var mergedSheet = spreadsheet.insertSheet("Merged Sheet");
  
  for (var i = 0; i < sheets.length; i++) {
    var sheet = sheets[i];
    var sheetName = sheet.getName();
    var dataRange = sheet.getDataRange();
    var values = dataRange.getValues();
    
    if (i > 0) {
      values.shift(); // 移除其他工作表的标题行
    }
    
    mergedSheet.getRange(mergedSheet.getLastRow() + 1, 1, values.length, values[0].length).setValues(values);
    
    for (var j = 0; j < values.length; j++) {
      mergedSheet.getRange(mergedSheet.getLastRow() - values.length + j + 1, values[0].length + 1).setValue(sheetName);
    }
  }
}