添加一行并对工作表进行排序(Google Apps脚本)

function addRowAndSortSheet() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var lastRow = sheet.getLastRow();
  var newRowIndex = lastRow + 1;
  
  sheet.insertRowAfter(lastRow);
  sheet.getRange(newRowIndex, 1, 1, sheet.getLastColumn()).activate();
  sheet.getActiveRange().autoFill(sheet.getRange(newRowIndex, 1, 2, sheet.getLastColumn()), SpreadsheetApp.AutoFillSeries.DEFAULT_SERIES);
  
  sheet.getDataRange().sort({column: 1, ascending: true});
}