Export Google sheet As PDF

How to Export Google sheet as a PDF Document?

Click here for Video Explanation

function convertSheetToPDF() {

  var wkbk = SpreadsheetApp.getActiveSpreadsheet()

  var spid = wkbk.getId();

  var file = DriveApp.getFileById(spid)

  var destinationFolder = DriveApp.getFolderById("kggjhgjgkkhfsgdhott"); // Replace with your desired folder ID

  var copyFile = file.makeCopy(wkbk.getName(), destinationFolder);

  var tempWkBk = SpreadsheetApp.openById(copyFile.getId())

  var sheets = tempWkBk.getSheets();

  var totalSheets = tempWkBk.getNumSheets();

  for (var i = 0; i <= totalSheets-1; i++) {

    var sheet = sheets[i]

    var sheetName = sheet.getSheetName();

    if(sheetName != "PaySlip"){

    tempWkBk.deleteSheet(sheet)

    }

  }

  var blob = tempWkBk.getAs('application/pdf')

  destinationFolder.createFile(blob).setName("PaySlip.pdf");

  destinationFolder.removeFile(copyFile)

}