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.
-
In the Folders tab, enter the
NameandIDof the folder for which you want to evaluate access. TheNamecan be anything you choose, but the logical choice is usually to make it the same as the actual name of the folder. TheIDhas 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 scriptsmenu, and click onQuery access for selected folder. The script will retrieve the information, and write the results to a sheet calledNamewithin 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.
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.
This code is licenced under the Apache License, Version 2.0.
- Google Cloud Platform
- Node.js
- google/clasp
- dreamsheets-scripts (see its README for things like customizing the oauth scopes for the project)