How to use Google Apps Script to display the number of files in a Google drive

was insufficient.
As shown in the image above, I would like to use GAS to reflect the number of files in Google Drive corresponding to each item in the spreadsheet in the Number of Cases column. How can I do this?As shown in the image below, the folders in the Google drive are divided into items, and I would like to reflect the number of files in this folder for each item.
Please help me.

google-apps-script

2022-09-30 21:25

1 Answers

Loop all files in your Google drive with DriveApp.getFiles() and count each time to get the number of files.
"Also, it seems that ""shared items"" and ""recently used items"" are counted."
Also, if you have a large number of files, it may not be finished within the Google AppsScript time limit, so you may need to think about it separately.

function myFunction(){
  var count = 0;
  var files = DriveApp.getFiles();
  while(files.hasNext()){
    count++;
    var file=files.next();
  }
  SpreadsheetApp.getActiveSheet().getRange("A1").setValue(count);
}

2022-09-30 21:25

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656