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:
Open your copy and use the Drive Audit menu (as shown):
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 i…
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:
Open your copy and use the Drive Audit menu (as shown):
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