Skip to main content

Troubleshooting

Common issues and how to solve them.

Authorization Errors​

"Authorization Required"​

Solution:

  1. The add-on needs permission to access your Drive
  2. Run the audit manually first: Add-ons → DriveAuditr → Run Audit Now
  3. Click "Continue" when prompted
  4. Select your Google account
  5. Click "Allow" to grant permissions
  6. Try running the audit again

"Permission Denied"​

Solution:

  1. You may have declined permissions previously
  2. Remove the add-on completely
  3. Reinstall and grant permissions when prompted
  4. Try again

API Errors​

"Drive API has not been enabled"​

Solution:

  1. The Google Drive API needs to be enabled
  2. This should happen automatically, but if not:
  3. Go to Extensions → Apps Script
  4. Click the "+" next to Services
  5. Find and add "Google Drive API v3"
  6. Save and try again

"Rate Limit Exceeded"​

Solution:

  • Google limits API calls per minute
  • Wait 5-10 minutes
  • Run the audit again
  • This rarely happens with DriveAuditr's batch processing

Performance Issues​

Audit Taking Too Long​

Large accounts (10,000+ files) can take several hours as the audit runs in batches. This is normal behavior due to Google Apps Script execution time limits.

Expected Times:

  • Under 500 files: ~5 minutes
  • 1,000 files: ~30 minutes to a few hours
  • 10,000+ files: Several hours (runs in background)

The audit runs automatically in the background - you don't need to keep the sheet open.

Audit Stuck at "RUNNING"​

Solution:

  1. Check Audit Status sheet for progress percentage
  2. Wait - large audits take time
  3. If truly stuck (no progress for 2+ hours), cancel and restart:
    • Add-ons → DriveAuditr → Cancel Running Audit
    • Then Run Audit Now to start fresh

Result Issues​

Missing Files​

If some files don't appear in the audit:

Possible Causes:

  • You don't have access to those files
  • Files are in trash
  • Files are permanently deleted
  • Permissions prevent viewing

Solution:

  • DriveAuditr can only show files you can access
  • Check if you can see the files in Google Drive directly
  • Ask the owner to grant you access

Duplicate Rows​

This is normal! Files with multiple permissions appear multiple times:

File A - john@example.com (viewer)
File A - anyone (reader)

Each row represents one permission. This is intentional for easy filtering.

Empty Permission Columns​

Some files may show empty permission info:

Possible Causes:

  • File has no explicit permissions (only owner)
  • Permission information unavailable
  • API limitations

Solution:

  • Usually safe to ignore
  • Check the file directly in Drive if concerned

Sheet Issues​

Sheets Not Created​

If audit sheets don't appear:

Solution:

  1. Check if sheets are hidden (right-click on sheet tabs)
  2. Look for sheets named exactly: "Drive Audit", "Audit Status", "Audit Summary"
  3. Try running the audit again
  4. Check Apps Script logs for errors

Cannot Edit Sheet​

If the sheet is protected:

Solution:

  • DriveAuditr should not protect sheets
  • Right-click sheet tab → Remove protection
  • If can't remove, you may not be the owner

Cancelling Audits​

How to Cancel​

If you need to stop a running audit:

  1. Add-ons → DriveAuditr → Cancel Running Audit
  2. Click "Yes" to confirm
  3. The audit stops immediately
  4. Results already written remain in the sheet

Can't Cancel​

If cancel option is grayed out:

  • There's no audit currently running
  • The audit may have already completed
  • Check Audit Status sheet

Error Messages​

"Execution Error"​

Solution:

  1. Check the error message in Audit Status sheet
  2. Look for specific details
  3. Common causes:
    • Timeout (normal for large Drives)
    • Network issues
    • Google service disruption
  4. Try running again

"Service Unavailable"​

Solution:

Getting More Help​

Check Logs​

For technical details:

  1. Go to Extensions → Apps Script
  2. Click on Executions (clock icon)
  3. Review recent execution logs
  4. Look for error messages

Contact Support​

If you can't resolve the issue:

  1. Email: driveauditr@terrydjony.com
  2. Include:
    • Description of the problem
    • Error message (if any)
    • Screenshots
    • Number of files in your Drive (approximate)
    • Any relevant error messages
  3. Response time: 1-2 business days

Known Limitations​

DriveAuditr cannot: ❌ Modify or delete files ❌ Change permissions ❌ Access files you can't see ❌ Process faster than Google's limits ❌ Recover deleted files

Best Practices​

To avoid issues:

✅ Start with a small folder to test ✅ Ensure you have authorization before scheduling ✅ Monitor first audit to completion ✅ Keep Apps Script execution logs enabled ✅ Be patient with large Drives - they run in batches

Still Having Issues?​

We're here to help! Contact us at driveauditr@terrydjony.com with:

  • Clear description of the problem
  • What you've already tried
  • Screenshots if applicable
  • Your Drive size (approximate file count)

We typically respond within 1-2 business days.