Export to PDF from Google Sheets

code.gs

function exportToPdf() {
  var blob,exportUrl,name,options,pdfFile,response,sheetTabId,ss,ssID,url_base;

  ss = SpreadsheetApp.getActiveSpreadsheet();
  ssID = ss.getId();
  sh = ss.getSheetByName(ss.getActiveSheet().getName());
  range = "A1:F" + sh.getMaxRows();
  sheetTabId = sh.getSheetId();
  url_base = ss.getUrl().replace(/edit$/,'');
  name = sh.getRange("J4").getValue() + "_" + sh.getRange("K4").getValue();
  name += " Cohort Schedule";

  exportUrl = url_base + 'export?exportFormat=pdf&format=pdf' +

    '&gid=' + sheetTabId + '&id=' + ssID +
    '&range=' + range + 
    '&size=A4' +
    '&portrait=true' +
    '&fitw=true' +
    '&sheetnames=false&printtitle=false&pagenumbers=false' + 
    '&gridlines=false' + 
    '&fzr=false';       // do not repeat row headers (frozen rows) on each page

  options = {
    headers: {
      'Authorization': 'Bearer ' +  ScriptApp.getOAuthToken(),
    }
  }

  options.muteHttpExceptions = true;

  response = UrlFetchApp.fetch(exportUrl, options);

  if (response.getResponseCode() !== 200) {
    console.log("Error exporting Sheet to PDF!  Response Code: " + response.getResponseCode());
    return;

  }
  
  blob = response.getBlob();
  blob.setName(name + ".pdf")

  pdfFile = DriveApp.createFile(blob);
}