Batch export to PDF #gas

!dbe99c193e5b6b0c7b61.md

Batch export to PDF (Google Drive)

How To

Links

• https://plus.google.com/u/0/+AndreasKuswara/posts/YJVTKanb6Ah
• Convert Google Documents and Spreadsheets with Apps Script
• Simple Google Apps Script to export a single sheet to PDF and email it to a contact list

Code.gs

function onInstall(e){}

var PREFERENCES = [
  {
    fileId: 'ID_GOOGLE_DRIVE_TYPE_FILE',
    toFolderId: 'ID_FOLDER'
  },
  {
    fileId: 'ID_GOOGLE_DRIVE_TYPE_FILE',
    toFolderId: 'ID_FOLDER'
  }
]

function batch(){
  for(var item in PREFERENCES){
    exportToPDF_(PREFERENCES[item]['fileId'], PREFERENCES[item]['toFolderId'])
  }
}

Tools.gs

function exportToPDF_(fileId, folderId){
  var source = DriveApp.getFileById(fileId)
  var blob = source.getAs('application/pdf');
  var file = DriveApp.createFile(blob);
  file.setName(source.getName() + '.pdf');
  if(folderId) {
    try{
      var d = DriveApp.getFolderById(folderId);
      moveToFolder_(file, d);
    }
    catch(e){
    }
  }
  return file;
}

function moveToFolder_(file, folder){
  folder.addFile(file);
  DriveApp.getRootFolder().removeFile(file);
}

Is ther a possibility to export only one sheet from a file with multiple sheets? This script exports all the sheets from the spreadsheet.