{"id":1328,"date":"2019-05-17T15:20:44","date_gmt":"2019-05-17T08:50:44","guid":{"rendered":"http:\/\/khub.phandeeyar.org\/docs\/google-toolkit\/how-to-copy-folders-and-list-file-names-in-google-drive\/"},"modified":"2019-06-25T12:32:57","modified_gmt":"2019-06-25T06:02:57","slug":"how-to-copy-folders-and-list-file-names-in-google-drive","status":"publish","type":"docs","link":"https:\/\/drnyeinchan.com\/khub\/docs\/google-toolkit\/pro-tips\/how-to-copy-folders-and-list-file-names-in-google-drive\/","title":{"rendered":"How to Copy Folders and List file names in Google Drive"},"content":{"rendered":"\n

Getting File Names From a Google Drive Folder.
There are a lot of tools which can list the file name in a folder. However, in Google Drive, there is not a plugin so far. But, a script is available to extract file names from the folder . I would like to share this tip to my team.I found that tip from the following website. So, feel free to check that link.<\/p>\n\n\n\n

http:\/\/www.acrosswalls.org\/ortext-datalinks\/list-google-drive-folder-file-names-urls\/<\/a><\/p>\n\n\n\n

  1. Create a blanksheet<\/li>
  2. Go to Tools\/Script editor<\/li>
  3. In the scripteditor, past the following code<\/li><\/ol>\n\n\n\n
    \/\/ replace your-folder below with the folder for which you want a listing\nfunction listFolderContents() {\n  var foldername = 'your-folder';\n  var folderlisting = 'listing of folder ' + foldername;\n  \n  var folders = DriveApp.getFoldersByName(foldername)\n  var folder = folders.next();\n  var contents = folder.getFiles();\n  \n  var ss = SpreadsheetApp.create(folderlisting);\n  var sheet = ss.getActiveSheet();\n  sheet.appendRow( ['name', 'link'] );\n  \n  var file;\n  var name;\n  var link;\n  var row;\n  while(contents.hasNext()) {\n\tfile = contents.next();\n\tname = file.getName();\n\tlink = file.getUrl();\n\tsheet.appendRow( [name, link] );\t \n  }  \n};<\/code><\/pre>\n\n\n\n
    1. You might need to change the \u2018your-folder\u2019 name with the name of your folder.<\/li>
    2. Note that the folder should be in your own drive. <\/li>
    3. If you click save and run , it will ask permission, just allow it.<\/li>
    4. After that , you will see a new spreadsheet with \u2018 list of files in your folder name\u2019 in My Drive .<\/li>
    5. Enjoy.<\/li><\/ol>\n\n\n\n
      Copying a share folder into your \u2018My Drive\u2019
      <\/p>\n\n\n\n
      1. You can copy a file which is shared with you.<\/li>
      2. You can not copy the whole folder.<\/li>
      3. There is an addon which can solve this problem.<\/li>
      4. The name is Copy Folder.check out the link<\/li><\/ol>\n\n\n\n
        https:\/\/chrome.google.com\/webstore\/detail\/copy-folder\/kfbicpdhiofpicipfggljdhjokjblnhl?hl=en<\/a><\/p>\n\n\n\n
        1. When you run it, it will ask you to choose a folder you \u2018d like to copy.<\/li>
        2. My suggestion is to open that folder before you run the addon.<\/li>
        3. That is because you will face trouble to find the exact folder from a lot of folders in your drive.<\/li>
        4. So if you click sort button and (Sort last opened by me ), it will make alot easier to navigate. <\/li>
        5. Then, you will see a newly copied folder in MyDrive.<\/li>
        6. ENJOY!!!<\/li><\/ol>\n\n\n\n
          Nyein Chan Ko Ko<\/p>\n
          \n\t\t\t  
          \n\t\t\t  <\/div><\/div>\n\t\t