谷歌应用脚本"TypeError: Cannot call method append row..)"上的错误

Question

我是一名初中生，我是使用"Google App Script"的初学者。请在这行代码中帮助我，因为我不断收到错误"类型错误：无法调用 null 的方法"appendRow"。（第 29 行，文件"代码"，项目"AS_Score"）"。这是我的代码行：

function doGet(e){
  var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1gk1O4SkS09f96si3trbS0HcVRhXlQH5wc7LVCJ-xMus/edit#gid=0");
  var sheet = ss.getSheetByName("Sheet1");
  addUser(e,sheet);

}

function doPost(e){
  var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1gk1O4SkS09f96si3trbS0HcVRhXlQH5wc7LVCJ-xMus/edit#gid=0");
  var sheet = ss.getSheetByName("Sheet1");
  addUser(e,sheet);
}

function addUser(e,sheet) {
  var id = e.parameter.id;
  var name = e.parameter.name;
  var grade = e.parameter.grade;
  var subject = e.parameter.subject;
  var score = e.parameter.score;
  sheet.appendRow([id,name,grade,subject,score]);
}

如果我有任何错误，请帮助我，谢谢！

Answer 1

尝试将工作表的名称更改为：（"Sheet1"）;