I'm trying to print a sheet from a Sheet in PDF on landscape to the bottom row that has data in it (essentially printing an area that's dynamic). The code I have is below, but it's not cropping the data and it's only doing it in portrait mode.
It's renaming appropriately based on the cell data.
function PDF() {
var folderID = "**FOLDERID**"; // Folder id to save in a Drive folder.
var sheet = SpreadsheetApp.openByUrl(
'https://docs.google.com/spreadsheets/d/**SHEETID**/export?format=pdf&portrait=false');
var pdfName = sheet.getRange("A1").getValue(); //Need to set the values to another sheet
var sourceSpreadsheet = SpreadsheetApp.getActive();
var folder = DriveApp.getFolderById(folderID);
// A sample script was added here.
var url = "https://www.googleapis.com/drive/v3/files/" + sourceSpreadsheet.getId() + "/export?mimeType=application/pdf&portrait=false";
var options = {
method: "GET",
headers: {Authorization: "Bearer " + ScriptApp.getOAuthToken()},
muteHttpExceptions: true
};
var response = UrlFetchApp.fetch(url, options).getBlob();
DriveApp.getFolderById(folderID).createFile(response).setName(pdfName);
}