{"id":357,"date":"2017-12-29T04:50:54","date_gmt":"2017-12-29T04:50:54","guid":{"rendered":"http:\/\/govinddas.com\/?p=357"},"modified":"2017-12-29T04:50:54","modified_gmt":"2017-12-29T04:50:54","slug":"list-google-drive-folders-files-google-script","status":"publish","type":"post","link":"https:\/\/govinddas.com\/index.php\/list-google-drive-folders-files-google-script\/","title":{"rendered":"List of google drive folders\/files- google script"},"content":{"rendered":"

List of my successful experiments in digital world :<\/strong><\/span><\/p>\n

Enlist names of google drive folder in spreadsheet<\/p>\n

Link code for google script : https:\/\/goo.gl\/qjMtj2<\/a><\/p>\n

Code is given below. (replace my drive<\/span> with name of your folder)<\/p>\n

 <\/p>\n

\/\/ replace your-folder below with the folder for which you want a listing
\nfunction listFolderContents() {
\nvar foldername = ‘my drive<\/span>‘;
\nvar folderlisting = ‘listing of folder ‘ + foldername;<\/p>\n

var folders = DriveApp.getFoldersByName(foldername)
\nvar folder = folders.next();
\nvar contents = folder.getFiles();<\/p>\n

var ss = SpreadsheetApp.create(folderlisting);
\nvar sheet = ss.getActiveSheet();
\nsheet.appendRow( [‘name’, ‘link’] );<\/p>\n

var file;
\nvar name;
\nvar link;
\nvar row;
\nwhile(contents.hasNext()) {
\nfile = contents.next();
\nname = file.getName();
\nlink = file.getUrl();
\nsheet.appendRow( [name, link] );
\n}
\n};<\/p>\n

 <\/p>\n

Place this script and allow google drive for permission. You will be able to save them in automatic spreadsheet in google drive parent folder. Example of my drive test (for files list) given below. You can replace circled areas according to your need- i.e. name of folder, and whether you need to enlist files names only or folder names only. (This script doesn’t work on hybrid, i.e. both file and folder names, so arrange them in drive accordingly. And ya, ignore cursor pipe sign preceding parenthesis.;-)<\/p>\n

\"\"<\/p>\n

 <\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

List of my successful experiments in digital world : Enlist names of google drive folder in spreadsheet Link code for google script : https:\/\/goo.gl\/qjMtj2 Code is given below. (replace my drive with name of your folder)   \/\/ replace your-folder below with the folder for which you want a listing function listFolderContents() { var foldername = ‘my drive‘; var folderlisting = ‘listing of folder ‘ + foldername; var folders = DriveApp.getFoldersByName(foldername) var folder = folders.next(); var contents = folder.getFiles(); var ss…<\/p>\n

Read More Read More<\/span><\/a><\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[1],"tags":[],"class_list":["post-357","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/govinddas.com\/index.php\/wp-json\/wp\/v2\/posts\/357","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/govinddas.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/govinddas.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/govinddas.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/govinddas.com\/index.php\/wp-json\/wp\/v2\/comments?post=357"}],"version-history":[{"count":0,"href":"https:\/\/govinddas.com\/index.php\/wp-json\/wp\/v2\/posts\/357\/revisions"}],"wp:attachment":[{"href":"https:\/\/govinddas.com\/index.php\/wp-json\/wp\/v2\/media?parent=357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/govinddas.com\/index.php\/wp-json\/wp\/v2\/categories?post=357"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/govinddas.com\/index.php\/wp-json\/wp\/v2\/tags?post=357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}