我有一個谷歌表格，有兩個表格，表單響應和報告：見這里當表單提交報告表時，會隨響應表的最后一個表單或最后一行而發生更改。我想向提交表單的人員發送電子郵件，并在發送電子郵件后將報告表附加為PDF，并在e列中寫下已發送的電子郵件：請參閱此處電子郵件收件人：表單響應列 b 主題：一些文本和表單響應列 a 抄送：[email protected] 正文：一些文本和表單響應列 f 附加：報告表作為PDF我用了這個代碼，但它不起作用 function onSubmit(e){  Logger.log('submit ran'); var ss = SpreadsheetApp.getActiveSpreadsheet();  var sheet = ss.getActiveSheet();  var lastRow = sheet.getLastRow();  var sa = sheet.getRange(lastRow, 1).getValue();  var sB = sheet.getRange(lastRow, 2).getValue();var sf = sheet.getRange(lastRow, 6).getValue();  var ssID = SpreadsheetApp.getActiveSpreadsheet().getId();  var sheetgId = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getSheetId();  var email =  Session.getUser().getEmail();  var subject = SB;  var body = Sf;  var url = "https://docs.google.com/spreadsheets/d/e/..............................................................=0&single=true&output=pdf";  var result = UrlFetchApp.fetch(url)  var contents = result.getContent(); if (emailSent !== "EMAIL_SENT") {       MailApp.sendEmail(email,subject ,body, {attachments:[{fileName:SB+".pdf", content:contents, mimeType:"application//pdf"}]});       sheet.getRange().setValue("EMAIL_SENT");          SpreadsheetApp.flush();        }  }我從電子表格>文件>發布到 web>發布報告選項卡獲取 pdf 格式的 url我重寫了代碼，但得到錯誤“TypeError：report.getAs不是一個函數（第36行，文件”Code“）"   function onSubmit(e){ var ss = SpreadsheetApp.getActiveSpreadsheet();  var sheet = ss.getAet();   var calculate = ss.getSheets()[2]; var Responses = ss.getSheets()[0]; var report = ss.getSheets()[1];   var sh = sheet.getRange(lastRow, 8).getValue();    var cell = calculate.getRange("b2");  cell.setFormula(sh); SpreadsheetApp.flush();   var email = sB;  var subject =   var body = se;    var calculate = ss.getSheets()[2]; vafunction onSubmit(e){  Logger.log('submit ran');  var sheet = ss.getActiveSheet();   var calculate = ss.getSheets()[2]; var Responses = ss.getSheets()[0]; var report = ss.getSheets()[1];