It generates a spreadsheet in the google drive with folders listed in decreasing order of their size.
This is google script that generates a spreadsheet with size of all the folders in one's drive. The folders are sorted in decreasing order of their size. It also provides a hyperlink to access the contents of the folder.
To add this script follow the below steps
- Click on New in google drive
- Click More -> Google Apps Script
- Paste the code in the editor and run the script to see sizes of all the folders