Breaking News: Grepper is joining You.com. Read the official announcement!

Google Script List of Files with Size from Google Drive Folder and Save into Excel Sheet

Jedi answered on December 22, 2022 Popularity 1/10 Helpfulness 1/10

answer Google Script List of Files with Size from Google Drive Folder and Save into Excel Sheet

Google Script List of Files with Size from Google Drive Folder and Save into Excel Sheet

Comment

function listFolderContents() {
  var foldername = 'DB'; // 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] );     
  }  
};

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: drive excel list save script size whatever

Link to this answer
Share Copy Link

Contributed on Dec 22 2022

Jedi

0 Answers Avg Quality 2/10

Google Script List of Files with Size from Google Drive Folder and Save into Excel Sheet

Contents

More Related Answers

Google Script List of Files with Size from Google Drive Folder and Save into Excel Sheet

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.