我有一個(gè)谷歌表格，有兩個(gè)表格，表單響應(yīng)和報(bào)告：見這里當(dāng)表單提交報(bào)告表時(shí)，會隨響應(yīng)表的最后一個(gè)表單或最后一行而發(fā)生更改。我想向提交表單的人員發(fā)送電子郵件，并在發(fā)送電子郵件后將報(bào)告表附加為PDF，并在e列中寫下已發(fā)送的電子郵件：請參閱此處電子郵件收件人：表單響應(yīng)列 b 主題：一些文本和表單響應(yīng)列 a 抄送：ABC@yahoo.com 正文：一些文本和表單響應(yīng)列 f 附加：報(bào)告表作為PDF我用了這個(gè)代碼，但它不起作用 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(); } }我從電子表格>文件>發(fā)布到 web>發(fā)布報(bào)告選項(xiàng)卡獲取 pdf 格式的 url我重寫了代碼，但得到錯(cuò)誤“TypeError：report.getAs不是一個(gè)函數(shù)（第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];
如何從谷歌表格發(fā)送電子郵件，并將表格作為PDF附件
jeck貓
2022-08-27 14:42:13
