Google Workspace - Shared Drive List

[DSapseid]

Hi All,

 

Does anyone know a way to export a list of all google shared drives including how much storage each of them is using?

 

In Google Admin under Apps > Google Workspace > Settings for Drive and Docs > Manage Shared Drives. It shows you the list and the storage used but there is no export button to csv/google sheet.

 

I don't want to do this manually as I believe there are nearly 4000 shared drives!!

 

Anyone know how to do this. I use GAM but the resources ive found with the commands dont give the options to export the size of the shared drive as well.

 

Thanks

 

Dan

[jthompson]

As you say, there doesn't appear to be a straightforward way to do that, but I did spot this python script that makes use of various gam commands to piece it all together. I haven't tried this myself, but afte casting my eye over it it seems promising.

 

https://github.com/taers232c/GAM-Scripts3/blob/master/GetTeamDriveCountsSize.py