我有 2 張紙。Sheet1 來自 Google Form 并將它們查詢到 Sheet2 然后制作公式。我想從他們那里獲取單元格值到 Google Doc 模板并發送電子郵件。我可以從 Sheet1 中獲取值，但不能從 Sheet2 中獲取值。請幫我解決這個問題。謝謝你。 在此處輸入圖像描述 在此處 輸入圖像描述function onFormSubmit(e){  var docs_email = e.values[1];  var Name = e.values[2];  var Date1 = e.values[3];  var Date2 = e.values[4];  var Money1 = e.values[5];  var Money2 = e.values[6];  //Values from Sheet2  var TotalDate = e.values[7];  var Money3 = e.values[8];  var TotalMoney = e.values[9];  var copyId = DriveApp.getFileById('Doc ID')  //Temp document ID  .makeCopy('Report-'+Name)  .getId();  var copyDoc = DocumentApp.openById(copyId);  copyDoc.getBody()  var copyBody = copyDoc.getActiveSection();  copyBody.replaceText('keyName', Name);  copyBody.replaceText('keyDate1', Date1);  copyBody.replaceText('keyDate2', Date2);  copyBody.replaceText('keyMoney1', Money1);  copyBody.replaceText('keyMoney2', Money2);  copyBody.replaceText('keyTotalDate', TotalDate);  copyBody.replaceText('keyMoney3', Money3);  copyBody.replaceText('keyTotalMoney', TotalMoney);  copyDoc.saveAndClose();  //convert to pdf  var pdf = DriveApp.getFileById(copyId).getAs("application/pdf");  //Send the email  var subject = "Your Report";  var body = "Dear " +Name+" \n\n"+"<br> This is your report";  GmailApp.sendEmail(docs_email, subject, body,{htmlBody: body, attachments: pdf});}