Google Spreadsheets Script - Gera PDF

\\script para gerar e salvar um pdf dentro do drive.

function onOpen() {

   SpreadsheetApp
  .getUi()
  .createMenu('Gerar PDF') 
  .addItem('Gerar PDF', 'printpdf')
  .addToUi();

}

 function printpdf() {
   
  //Gera o PDF e salva no Google drive
  var spreadsheet_id = ('1VQnvUk1Hq4R60aUpJm6pEPe66nBUye5PTDJo4HGUrdA');
  var spreadsheetFile = DriveApp.getFileById(spreadsheet_id);
  var blob = spreadsheetFile.getAs('application/pdf');
  DriveApp.createFile(blob);

}