function convertToPDF() {
var documentId = "1IeY_KXhhdUbPcLIi1WL_nd8AUky5eLDk48Ql1sW6sII";
var document = DocumentApp.openById(documentId);
//document
var dynamicId = "12XPDcrng6nZ7ibGziAwNT8eaZ7DYHDoXy3OnknWzyAI"
let cell = "B13";
//var sheetName = "sheet1";
var sheet = SpreadsheetApp.openById(dynamicId);
var offerName = sheet.getRange(cell).getValue();
var blob = document.getAs('application/pdf');
// Set the name of the PDF file
var pdfFile = DriveApp.createFile(blob).setName(offerName + "_offer" + ".pdf");
var folderName = offerName + "_offer";
var newFolder = DriveApp.createFolder(folderName);
pdfFile.moveTo(newFolder);
Logger.log(offerName);
}
在我保存之前,请帮我更新文档中的所有共享表,我在这张表上迷路了。非常感谢