Google Drive Permission report (google sheet export)

[Coly]

Hi, what I would like to achieve is to process a report of all shared folders and the users with permissions on each folder and the access levels and populate it on a google sheet? 

could google try to give this a look as I am sure it would be helpful in the future instead of doing it manually by screenshots or copy and paste.

I have managed to pull a google sheet report export of all users and the amount of data storage that they utilize. and now I need to process a report for all shared drives within our google drive and the permissions list for all the drives in our entire organization.

[icrew]

You can do most of this with the free, open source, command-line, indispensable GAM tool. Check out https://github.com/jay0lee/GAM/wiki, https://github.com/taers232c/GAMADV-XTD3/wiki, and https://groups.google.com/forum/#!forum/google-apps-manager for more details.

Specifically, check out https://github.com/GAM-team/GAM/wiki/GoogleDriveManagement

Hope that helps,

Ian

[christiannewman]

@Coly which Google Workspace edition are you subscribed to?

If you have Enterprise Standard or Enterprise Plus, you can access the Security Investigation Tool, to generate Drive Audit reports by document type (folder, Shared Drive, etc) and or Visibility (shared internally, externally, public with link, etc) and export the report to Google Sheets.