We are approaching our 500,000 item capacity in our Corporate Google Drive.
We are all familiar with managing drive capacity (we are only at 11%). But Google Drive has not given us tools to find what folders or sub-folders are consuming our Item Capacity (we are at 94%) Neither using the web interface or our macos finder windows counts the items of a folder and all of the sub-folders. Therefore there is no resolution to finding the folders with the most items; and thus we have difficulty managing the item capacity.
Anyone have a tool for counting items in a folder and all of its sub-folder? Should Google not provide such a tool when imposing the Item Capacity at 500,000 items?
Google Drive doesn’t surface item counts per folder in the UI, but you can get this data using the Google Drive API or Google Workspace Admin SDK Reports. A practical approach is to run a script that recursively lists all files within a folder using files.list with the q parameter to filter by parent ID, and tally counts including subfolders. You can use gcloud alpha storage or Apps Script with DriveApp to automate this and export results to a spreadsheet for sorting by item count. If you’re in a Workspace domain, the Admin can also use the Reports API to pull aggregate usage and identify heavy folders. This is currently the only way to pinpoint which areas are consuming your item capacity.