如何批量向Google Apps脚本添加数据

function addDataToSheet() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var data = [
    ['Name', 'Age', 'Email'],
    ['Alice', 30, 'alice@example.com'],
    ['Bob', 25, 'bob@example.com'],
    ['Charlie', 35, 'charlie@example.com']
  ];
  sheet.getRange(1, 1, data.length, data[0].length).setValues(data);
}

function addDataToSheet() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var data = [
    ['Alice', 30, 'alice@example.com'],
    ['Bob', 25, 'bob@example.com'],
    ['Charlie', 35, 'charlie@example.com']
  ];
  for (var i = 0; i < data.length; i++) {
    sheet.appendRow(data[i]);
  }
}

sheet.getRange(1, 1, data.length, data[0].length).setValues(data);
sheet.getRange(1, 1, data.length, data[0].length).setNumberFormat("0.00");

var requests = [];
for (var i = 0; i < data.length; i++) {
  requests.push({ "updateCells": { "range": { "sheetId": sheet.getSheetId(), "startRowIndex": i + 1, "endRowIndex": i + 2, "startColumnIndex": 1, "endColumnIndex": data[0].length }, "rows": [{ "values": [data[i]] }], "fields": "userEnteredValue" } });
}
sheet.getParent().batchUpdate({ "requests": requests });