var sheetId = "YourSheetID";
//連接試算表
var spreadsheet = SpreadsheetApp.openById(sheetId);
var sheet = spreadsheet.getSheetByName('工作表1');
sheet.appendRow(['王大同','國文成績',100]);
※注意資料要以中括號夾住※
https://developers.google.com/apps-script/reference/spreadsheet/sheet?hl=zh-tw