问Google脚本和工作表--我需要和完整的读/写共享吗？

EN

function doGet(e) {
  if (!e.parameter.page) {
    var userCrewSheetName = getUserSheetName();
    var userCrewSheet = activeSpreadsheet.getSheetByName(userCrewSheetName);
    initializeSheet(userCrewSheet,userCrewSheetName);
    var userBonusSheetName = getUserSheetName("bonus");
    var userBonusSheet = activeSpreadsheet.getSheetByName(userBonusSheetName);
    initializeSheet(userBonusSheet,userBonusSheetName);
    return HtmlService.createTemplateFromFile('test').evaluate();
  }
  return HtmlService.createTemplateFromFile(e.parameter['page']).evaluate();
}

function initializeSheet(sheet,sheetName) {
  if(sheet == null) { 
    sheet = activeSpreadsheet.insertSheet();
    sheet.setName(sheetName);
    setHeaders(sheet,sheetName);
  }
}

function getUserSheetName(sheetType) {
  var userName = Session.getActiveUser().getEmail();
  if (!userName) { return };
  if(sheetType == "bonus") {
    return userName + '_my_bonus';
  } else {
    return userName + '_my_crew';
  }
  return "error";
}