Skip to content

Instantly share code, notes, and snippets.

@PovilasID

PovilasID/list-files-in-folders.gs

Forked from sparkalow/list-files-in-folders.gs
Last active September 26, 2022 19:58
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save PovilasID/ec4f5115a407b9ae3671d365b012b3a5 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save PovilasID/ec4f5115a407b9ae3671d365b012b3a5 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. PovilasID revised this gist Feb 2, 2021. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion list-files-in-folders.gs
    View file
    Original file line number Diff line number Diff line change
    @@ -47,7 +47,7 @@ function start() {
    Logger.log(file.getName());

    sheet.appendRow([
    file.getName(),
    '=HYPERLINK("'+file.getUrl()+'", "' +file.getName()+'")',
    file.getDateCreated(),
    file.getSize(),
    file.getUrl(),
  2. PovilasID revised this gist Feb 2, 2021. 1 changed file with 4 additions and 2 deletions.
    6 changes: 4 additions & 2 deletions list-files-in-folders.gs
    View file
    Original file line number Diff line number Diff line change
    @@ -15,7 +15,7 @@ function onOpen() {
    function start() {
    var sheet = SpreadsheetApp.getActiveSheet();
    sheet.clear();
    sheet.appendRow(["Name", "Date", "Size", "URL", "Download", "Description", "Type", "Folder", "Folder Slug"]);
    sheet.appendRow(["Name", "Date", "Size", "URL", "Download", "Description", "Type", "Folder", "Thumbnail"]);

    var folderName = Browser.inputBox("Enter Folder Name (this will destroy the current spreadsheet):");
    //var folderName = "Safety Subdomain Assets";
    @@ -54,7 +54,9 @@ function start() {
    "https://docs.google.com/uc?export=download&confirm=no_antivirus&id=" + file.getId(),
    file.getDescription(),
    file.getMimeType(),
    folderName
    folderName,
    //yourImageURL&sz=w{{width}}-h{{height}} setting size
    '=IMAGE("https://drive.google.com/thumbnail?id='+file.getId()+'")'
    ]);
    }
    }
  3. @sparkalow sparkalow renamed this gist Sep 21, 2016. 1 changed file with 0 additions and 0 deletions.
    0 gistfile1.txt → list-files-in-folders.gs
    View file
    File renamed without changes.
  4. @sparkalow sparkalow created this gist Sep 21, 2016.
    63 changes: 63 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,63 @@
    /*
    Recusrsively add a list of files from a named foler to a sheet
    */

    function onOpen() {
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var searchMenuEntries = [{
    name: "Create List from Folder",
    functionName: "start"
    }];
    ss.addMenu("Document List", searchMenuEntries);
    }


    function start() {
    var sheet = SpreadsheetApp.getActiveSheet();
    sheet.clear();
    sheet.appendRow(["Name", "Date", "Size", "URL", "Download", "Description", "Type", "Folder", "Folder Slug"]);

    var folderName = Browser.inputBox("Enter Folder Name (this will destroy the current spreadsheet):");
    //var folderName = "Safety Subdomain Assets";

    var folder = DriveApp.getFoldersByName(folderName);

    if (folder.hasNext()) {
    processFolder(folder);
    } else {
    Browser.msgBox('Folder not found!');
    }


    function processFolder(folder) {
    while (folder.hasNext()) {
    var f = folder.next();
    var contents = f.getFiles();
    addFilesToSheet(contents, f);
    var subFolder = f.getFolders();
    processFolder(subFolder);
    }
    }

    function addFilesToSheet(files, folder) {
    var data;
    var folderName = folder.getName();
    while (files.hasNext()) {
    var file = files.next();
    Logger.log(file.getName());

    sheet.appendRow([
    file.getName(),
    file.getDateCreated(),
    file.getSize(),
    file.getUrl(),
    "https://docs.google.com/uc?export=download&confirm=no_antivirus&id=" + file.getId(),
    file.getDescription(),
    file.getMimeType(),
    folderName
    ]);
    }
    }


    }