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);
}
please help me update all the shared sheets in the doc before I save, I am lost on this one. Much appreciated
New contributor
Philip Henry is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.