Feel free to keep them named 'Sheet1' and 'Sheet2' but you might want to change them to make more sense (maybe Drives and Permissions) Sign into Google as a super admin / domain admin and create a new Google Sheet with 2 tabs.Google Workspace Domain Super Admin (or delegated access for 'all' drive content in the domain).Can I perform an inventory on a schedule, so I can see how things change over time?.Who owns and has access to the Shared Drives in my domain?.This solution is meant to solve two fairly basic questions: While this is entirely possible to script, the exponential size and scope of the data collected is too large to be effectively stored in a single Google Sheet (in my opinion). Note, this does not traverse down into subfolders' permissions inside every shared drive. Then, it uses the Drive API again to loop through all the drives and get the top-level permissions. This solution uses Google Apps Script and the Drive API to pull information about all the Shared Drives in a domain into a Google Sheet. They are a really great addition to the Workspace offering, but there are still some gaps in reporting & oversight that some people have wanted. If you're a Google Workspace Super Admin, you've probably been thinking of ways to inventory and keep a handle on Google Shared Drives. These scopes should all be enabled for your credentials on the consent screen part of the developer console. The only thing this assumes is that you have a valid credentials file generated from the developer console. I had to do all of this recently, so I hope this helps someone else avoid the pain I went through =). Also, virtually none show you how to do things with shared drives. A ton are for old versions though, and most are basic cases (not good with restricted sharing options/etc). There are plenty of examples of how to use the Google Drive API online.

Google drive api share file