Skip to main content

Getting Started

Welcome to DriveAuditr! This guide will help you get started with auditing your Google Drive permissions.

What is DriveAuditr?​

DriveAuditr is a Google Sheets Add-on that lists all your Google Drive files and their permissions. It helps you:

  • See all files you have access to (My Drive, Shared Drives, shared with you)
  • Identify who has access to each file and their role
  • Find files shared publicly or with external domains
  • Review and audit access control across your entire Drive

Installation​

Coming soon to the Google Workspace Marketplace!

For now, you can use the development version:

  1. Contact us at driveauditr@terrydjony.com
  2. We'll send you setup instructions
  3. Or download DriveAuditr for free at our pricing page

First Audit​

Once installed:

  1. Open Google Sheets
  2. Go to Add-ons → DriveAuditr → Run Audit Now
  3. Click OK to start the audit
  4. Check the Audit Status sheet for progress

What to Expect​

  • Small Drive (under 500 files): ~5 minutes
  • Medium Drive (1,000-5,000 files): ~5-15 hours (free version)
  • Large Drive (10,000+ files): ~20+ hours (free version)

Large Drives process automatically in batches - just let it run in the background.

Understanding Results​

After the audit completes, you'll have three sheets:

1. Drive Audit Sheet​

  • One row per permission (files with multiple permissions have multiple rows)
  • Columns show file info and permission details
  • Use filters to find specific patterns

2. Audit Status Sheet​

  • Shows current status (RUNNING, COMPLETED, ERROR, or CANCELLED)
  • Progress percentage and last update time
  • Real-time tracking during audit

3. Audit Summary Sheet​

  • Overview of total files and permissions
  • Audit date and time
  • Next steps and tips

Common Use Cases​

Find Publicly Shared Files​

Filter Permission Type column for "anyone"

Find External Shares​

Filter Permission Email for domains outside your organization

Find Files You Own​

Filter Owner column for your email

Find Editors​

Filter Permission Role for "writer" or "editor"

Scheduled Audits​

Set up automatic weekly audits:

  1. Go to Add-ons → DriveAuditr → Setup Weekly Schedule
  2. Confirm to run audits every Monday at 6 AM
  3. Results update automatically in your sheet

To remove:

  • Add-ons → DriveAuditr → Remove Schedule

Need Help?​

Next Steps​

Learn more about: