This repo contains a script that turns Google Sheets into a file permissions auditor for Google Drive. The script adds a new menu item to the Sheet with an option to run the file auditing process. While the process runs, it will traverse all of your Google Drive files, collect all users with access to each file and output them to the spreadsheet. The output also includes a link to each file so you can manage access with ease.
Check out the YouTube tutorial here: Check out the Tutorial
The easiest way to get started is by copying the following spreadsheet template to your Google Drive: Spreadsheet Template. Once copied, run the script by clicking the 'File Auditor' option in the menu bar and select 'Run File Audit'. Google will then ask that you authorize some permissions, and once they're authorized you're ready to run the audit process.
Alternatively, you can get started by manually inserting the scripts in this repo into your Apps Script editor. Start by creating Apps Script files corresponding to each of the JS files in this repo. Next, copy the contents of each JS file and paste them into appropriate Apps Script file. Once all of the contents are copied over, open the index.gs file in your Apps Script editor, and run the main() function. Google will prompt you with a request to authorize some permissions so the script can access your spreadsheet and google drive account.
Once authorization is granted, you are ready to set up the spreadsheet to start auditing Google Drive folders. Please follow the format of the template spreadsheet provided here: Spreadsheet Template
Happy auditing!
Distributed under the MIT License. See LICENSE.md for more information.