Select the "job_set_sheet_headers" item in the Run menu at the top of the editor, and click "Run".Update the variables at the top of the code to point to the google sheet you created in Step 1, and the tab names (if you changed them from Sheet 1 & 2).and the email address you want a notification to be sent to when it's finished.Copy the code from the shared repo into the Code.gs file.Add the "Drive" service to the project (using the + symbol on the left side of your Apps Script editor).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.
0 kommentar(er)
