Google script: how can i download and execute this code?

dedec0 · 04-10-2021, 07:21 AM

I want to list all files (

Code:

$ find . -type f

) in a Google Drive folder (not necessarily mine). I found this page:

1) https://floffi.media/en/web/create-l...-drive-folder/

Which gives the solution:

2) https://script.google.com/macros/s/A...qlO6o6YHM/exec

But when i try to open (2), i am asked to login, and after that, it complains about permission, which i would choose to give, but then [] says that the script is blocked. How do i download this script for myself, and execute it? The execution may be in a browser (preferably), or in a phone. If the code shown in (1) is all that is needed, how do i execute it?

I have read that other solutions exist, but they might be slow. So, i want to see if this one can work, somehow.

shruggy · 04-10-2021, 08:31 AM

The script code is given at the first link (just scroll down to the end of the page):

Code:

function listAllFilesInFolder() {
    var foldername = "XYZ";
    var filename = "files_" + foldername;
    var folder = DriveApp.getFoldersByName(foldername).next();
    var sheet = SpreadsheetApp.create(filename).getActiveSheet();
    var file;
    var data = [];
    var re = /(?:\.([^.]+))?$/;
    var files = folder.getFiles();
    data.push([ "Name", "Extension", "Owner", "Date created",
                "Date modified", "Size", "Link" ]);
    while (files.hasNext()) {
        file = files.next();
        data.push([ file.getName(), "." + re.exec(file.getName())[1],
                    file.getOwner().getName(), file.getDateCreated(),
                    file.getLastUpdated(), file.getSize(), file.getUrl() ]);
    }
    sheet.getRange(1, 1, data.length, data[0].length
                  ).setValues(data).setNumberFormat("@STRING@");
    sheet.getRange(1, 1, 1, data[0].length).setFontWeight("bold");
    sheet.autoResizeColumns(1, data[0].length);
}

dedec0 · 04-10-2021, 08:36 AM

Quote:

Originally Posted by shruggy

The script code is given at the first link (just scroll down to the end of the page):

Code:

function listAllFilesInFolder() {
    var foldername = "XYZ";
    var filename = "files_" + foldername;
    var folder = DriveApp.getFoldersByName(foldername).next();
    var sheet = SpreadsheetApp.create(filename).getActiveSheet();
    var file;
    var data = [];
    var re = /(?:\.([^.]+))?$/;
    var files = folder.getFiles();
    data.push([ "Name", "Extension", "Owner", "Date created",
                "Date modified", "Size", "Link" ]);
    while (files.hasNext()) {
        file = files.next();
        data.push([ file.getName(), "." + re.exec(file.getName())[1],
                    file.getOwner().getName(), file.getDateCreated(),
                    file.getLastUpdated(), file.getSize(), file.getUrl() ]);
    }
    sheet.getRange(1, 1, data.length, data[0].length
                  ).setValues(data).setNumberFormat("@STRING@");
    sheet.getRange(1, 1, 1, data[0].length).setFontWeight("bold");
    sheet.autoResizeColumns(1, data[0].length);
}

Thank you for confirming. But i am totally lost on where to put this code. I am a perfect newbie for this kind of code, i think.

Turbocapitalist · 04-10-2021, 09:18 AM

Anything you can type in the terminal can be turned into a shell script and vice versa. The gist is to put it into a file and then set the permissions on that file so that it is executable. However, at the beginning stage, you might benefit from an overview of shell scripting.

If that tutorial does not meet your needs, level, or interest, then there are many, many others to choose from. The parts your script appear to use are functions and the find utility. Both are good to know, the latter is a very powerful utility which you will find very useful. The

shruggy · 04-10-2021, 09:56 AM

This is not a shell script, it's a Google Apps script (a sort of JavaScript I guess). The page I linked describes how to run it on a Google Drive folder.

Turbocapitalist · 04-10-2021, 09:57 AM

Thanks. I was looking more at the example posted in the question. I'll have to read up on Google Apps Scripts, assuming that it is not a proprietary technology.