How to get List of Files with Size from Google Drive Folder and Save into Excel Sheet

Published: 15 April 2022
on channel: TechBrothersIT

25,429

262

How to get List of Files with Size from Google Drive Folder and Save into Excel Sheet, in this video we are going to learn How to get List of Files with Size from Google Drive Folder and Save into Excel Sheet.
Script:

function listFolderContents() {
var foldername = 'Final Logos'; // provide the name of Folder from which you want to get the list of files
var ListOfFiles = 'ListOfFiles_' + foldername;

var folders = DriveApp.getFoldersByName(foldername)
var folder = folders.next();
var contents = folder.getFiles();

var ss = SpreadsheetApp.create(ListOfFiles);
var sheet = ss.getActiveSheet();
sheet.appendRow( ['name', 'link','sizeInMB'] );

var var_file;
var var_name;
var var_link;
var var_size;

while(contents.hasNext()) {
var_file = contents.next();
var_name = var_file.getName();
var_link = var_file.getUrl();
var_size=var_file.getSize()/1024.0/1024.0;
sheet.appendRow( [var_name, var_link,var_size] );
}
};

#ExcelSheet #ExcelTricks #GoogleDrive

Watch video How to get List of Files with Size from Google Drive Folder and Save into Excel Sheet online without registration, duration hours minute second in high quality. This video was added by user TechBrothersIT 15 April 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 25,429 once and liked it 262 people.