使用脚本将google sheet中的文件重命名为上个月的名称

function renameSheetToLastMonth() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var currentMonth = new Date().getMonth();
  var lastMonth = currentMonth === 0 ? 11 : currentMonth - 1;
  var sheetName = Utilities.formatDate(new Date(), spreadsheet.getSpreadsheetTimeZone(), "yyyy") + "-" + Utilities.formatDate(new Date(), spreadsheet.getSpreadsheetTimeZone(), "MM");
  var lastMonthSheetName = Utilities.formatDate(new Date(), spreadsheet.getSpreadsheetTimeZone(), "yyyy") + "-" + Utilities.formatDate(new Date(), spreadsheet.getSpreadsheetTimeZone(), "MM", {month: lastMonth});

  var sheet = spreadsheet.getSheetByName(sheetName);
  if (sheet) {
    sheet.setName(lastMonthSheetName);
  }
}