var foldername = '_images'; // папка с картинками
var sheet = SpreadsheetApp.getActive().getSheetByName("GD-images"); // вкладка гугл таблицы для записи картинок
// entry function
function ListNamedFilesandFolders(){
ListNamedFilesandFolders1F(foldername,'')
}
function ListNamedFilesandFolders1F(fn,rfn) {
var data = [];
if (foldername==fn){
sheet.clear();
sheet.appendRow(["folder","id", "url"]);
}
var folders = DriveApp.getFoldersByName(fn);
var foldersnext = folders.next();
var myfiles = foldersnext.getFiles();
while (myfiles.hasNext()) {
var myfile = myfiles.next();
var fname = myfile.getName();
var fid = myfile.getId();
data = [
rfn+'/'+ foldersnext+'/'+fname,
fname,
fid,
];
sheet.appendRow(data);
}
var subfolders = foldersnext.getFolders();
while (subfolders.hasNext()) {
var subfolderdata = [];
var mysubfolders = subfolders.next();
var mysubfolder = mysubfolders.getName();
ListNamedFilesandFolders1F(mysubfolder,rfn +'/'+ fn)
}}