#GOOGLE DRIVE EXPORT LIST OF FILE NAMES CODE#

Logger.log('Subfolder is '+foldersnext+'/'+mysubfolder) now start a loop on the files in the subfolder Logger.log('FILES IN THIS FOLDER') //DEBUG HEADING Var mysubfiles = mysubfolders.getFiles()

Logger.log('Subfolder name:'+mysubfolder) //DEBUG Var mysubfolder = mysubfolders.getName() now start a loop on the SubFolder list Logger.log('THE SUBFOLDER(S) ARE') DEBUG HEADING Var subfolders = foldersnext.getFolders() You have been warned ) function ListNamedFilesandFolders() // Completes listing of the files in the named folder The same command getFolders is used the difference is whether the command is called from a named folder, as in this example, or from the DriveApp ( var files=DriveApp.getFiles() ).

#GOOGLE DRIVE EXPORT LIST OF FILE NAMES CODE#

The difference between the code to do this, and the code shown below is very subtle. Note: it is possible to create a list of all the files, sub-folders and their files held on Google Drive. It will list all the files, sub-folders and their files in/under the named folder.Īs you can see, the code is not strictly original, and I have given credit to those who originally developed the code that I further developed. The following code accepts a Google Drive folder name as a variable (' foldername' on line 9 just edit the folder name to suit). But it occurs to me that some people looking at this question and answer may be trying to create a list of folders and files using just the Google Sheets script. It's true - ' Files Cabinet', the add-on for ' Awesome Tables' does help list a Google Drive folder.

Google drive export list of file names