GDrive Access Monitor

This is a basic tool to enable the easy evaluation of access settings for folders on Google Drive. The code is bundled with webpack and pushed to the GDriveAccessMonitorScript Google Apps Script (GAS) project by making use of google/clasp. This GAS project is connected to the GDrive Access Monitor Google Sheet, from where the script is run and where the resulting access settings are reported.

Usage

• In the Folders tab, enter the Name and ID of the folder for which you want to evaluate access. The Name can be anything you choose, but the logical choice is usually to make it the same as the actual name of the folder. The ID has to be the id of the GDrive folder as contained in its url:

  https://drive.google.com/drive/folders/<ID>
  

• Then, while this row in the sheet is selected, go to the Custom scripts menu, and click on Query access for selected folder. The script will retrieve the information, and write the results to a sheet called Name within this spreadsheet. The query is performed recursively, so that the access settings for all (nested) subfolders and files within the given folder is reported.

Note: The person running the script already needs to have access to the folder that they want to evaluate.

Contributing

Please check out the recommended workflow here.

If necessary, this project could be expanded to perform periodic checks of the access settings (potentially comparing with some expected access specification), and/or to perform batch updates of access levels for specific folders.

Licence

This code is licenced under the Apache License, Version 2.0.

Built with

• Google Cloud Platform
• Node.js
• google/clasp
• dreamsheets-scripts (see its README for things like customizing the oauth scopes for the project)