如何激活Google Sheets API中的聚合选项

function enableSheetsAPI() {
  var projectId = 'YOUR_PROJECT_ID';
  var serviceAccountEmail = 'YOUR_SERVICE_ACCOUNT_EMAIL';

  var project = {
    "timeZone": "America/New_York",
    "sheets": [{
      "properties": {
        "title": "Sheet1"
      },
      "data": [{
        "startRow": 0,
        "startColumn": 0,
        "rowData": [{
          "values": [{
            "userEnteredValue": {
              "formulaValue": "=SUM(A1:A10)"
            }
          }]
        }]
      }]
    }]
  };

  var request = {
    "parents": [{
      "id": projectId
    }],
    "resource": project
  };

  var serviceAccount = {
    "client_email": serviceAccountEmail,
    "private_key": "YOUR_PRIVATE_KEY"
  };

  var jwt = new google.auth.JWT(serviceAccount.client_email, null, serviceAccount.private_key, ['https://www.googleapis.com/auth/spreadsheets']);
  jwt.authorize(function(err, response) {
    if (err) {
      console.log(err);
      return;
    }

    var sheets = google.sheets('v4');
    sheets.spreadsheets.create(request, function(err, response) {
      if (err) {
        console.log(err);
        return;
      }

      console.log(response);
    });
  });
}