var conjunto = 1; var limite = 400; // no tocar var contador = 0 + (limite*(conjunto-1)); var skip = limite*(conjunto-1); var skip_c = 0; function listFilesAndFolders(){ var folderId = Browser.inputBox('Enter folder ID', Browser.Buttons.OK_CANCEL); if (folderId === "") { Browser.msgBox('Folder ID is invalid'); return; } getFolderTree(folderId, true); }; function getFolderTree(folderId, listAll) { try { var parentFolder = DriveApp.getFolderById(folderId); var file, data, sheet = SpreadsheetApp.getActiveSheet(); if(conjunto == 1) { sheet.clear(); sheet.appendRow(["Name", "URL"]); } getChildFolders(parentFolder.getName(), parentFolder, data, sheet, listAll); } catch (e) { Logger.log(e.toString()); } }; function getChildFolders(parentName, parent, data, sheet, listAll) { var childFolders = parent.getFolders(); while (childFolders.hasNext()) { var childFolder = childFolders.next(); var files = childFolder.getFiles(); while (listAll & files.hasNext()) { var childFile = files.next(); if(skip_c <= skip) { skip_c+=1; } else { contador+=1; if(contador<=conjunto*limite) { data = [ childFile.getName().replace(".pdf",""), childFile.getUrl(), ]; var conjunto = 1; var limite = 400; // no tocar var contador = 0 + (limite*(conjunto-1)); var skip = limite*(conjunto-1); var skip_c = 0; function listFilesAndFolders(){ var folderId = Browser.inputBox('Enter folder ID', Browser.Buttons.OK_CANCEL); if (folderId === "") { Browser.msgBox('Folder ID is invalid'); return; } getFolderTree(folderId, true); }; function getFolderTree(folderId, listAll) { try { var parentFolder = DriveApp.getFolderById(folderId); var file, data, sheet = SpreadsheetApp.getActiveSheet(); if(conjunto == 1) { sheet.clear(); sheet.appendRow(["Name", "URL"]); } getChildFolders(parentFolder.getName(), parentFolder, data, sheet, listAll); } catch (e) { Logger.log(e.toString()); } }; function getChildFolders(parentName, parent, data, sheet, listAll) { var childFolders = parent.getFolders(); while (childFolders.hasNext()) { var childFolder = childFolders.next(); var files = childFolder.getFiles(); while (listAll & files.hasNext()) { var childFile = files.next(); if(skip_c <= skip) { skip_c+=1; } else { contador+=1; if(contador<=conjunto*limite) { data = [ childFile.getName().replace(".pdf",""), childFile.getUrl(), ]; sheet.appendRow(data); } else { return; } } } getChildFolders(parentName + "/" + childFolder.getName(), childFolder, data, sheet, listAll); } }; sheet.appendRow(data); } else { return; } } } getChildFolders(parentName + "/" + childFolder.getName(), childFolder, data, sheet, listAll); } };