I needed a way to list who can access every shared file on my Google Drive. However, most scripts I found online were not working for me.
So I opened Cursor and started building it myself. At first, I intended to publish the Apps Script as an add-on, but it turns out the script needs a restricted scope thus requiring a long review process.
Finally I decided to publish the script for free, along with a Google Sheets Template.
How to Audit Files on Google Drive
This is how you can list who has access to every shared file on your Google Drive:
Copy the template (includes the script): Drive Audit Files Template.
Open your copy and use the Drive Audit menu (as shown):
- Click Run Audit Now to start your first scan.
- If Authorization Required appears, click OK and proceed.
- Click Advanced (bottom-left), then Go to Clasp Drive Audit Add-on
- Click Select all to grant the requested permissions, then Continue.
You’ll see the audit begin:
The script will add Drive Audit and Audit Status sheets to your file.
Review details in Drive Audit (sensitive info in the screenshot is redacted):
Check progress/completion in Audit Status (e.g., running vs. done).
You can check the full source code on my github.
I also posted this on my blog