domainwidedelegation.comStart free

Use cases → Reporting and data

Report on Drive storage usage across the entire organisation

Audit and track Google Drive storage usage for every user, producing a reliable, up-to-date organisational report.

Who it is forIT and compliance teams monitoring storage consumption and policy adherence.
APIsDrive API, Admin SDK
Typical scopesdrive.readonly, admin.directory.user.readonly

The problem

Drive storage can be consumed rapidly and invisibly, especially with shared drives and large file uploads. Admins are often surprised by sudden quota limits or bill increases, and per-user breakdowns are not available in the standard admin UI.

How it works

  1. Enumerate all active users using the Admin SDK.
  2. Impersonate each user with domain-wide delegation to list files and sum their sizes via the Drive API.
  3. Collect and aggregate per-user and shared drive totals.
  4. Write the results to a central sheet or database for further analysis.

What changes

A full, up-to-date view of storage usage by user and shared drive, enabling proactive management and cleanup.

The trap in this one. Drive API file listings are eventually consistent: recently deleted or moved files may still appear in results for several minutes to hours, inflating reported usage. Relying on real-time accuracy for quota enforcement or billing can lead to incorrect actions — always document and communicate this lag.

Watch it explained

“Setting up BigQuery Log Export from Google Workspace” — Google Workspace Admins on YouTube. Third-party video, included because it covers this ground well. We are not affiliated with the channel.

Questions people ask

Can this include shared drives?

Yes, but you must enumerate shared drives separately and process their contents. Shared drive membership does not map directly to users.

Does this catch orphaned files?

Only if you explicitly query for files with no parents. They are not included in normal folder listings and can be missed.

Want this built?

This is a pattern we run in production. We will set up the delegation and build this on top of it — $500 per hour, most of it working the same day.

Talk to us Or read the setup guide

Related use cases

Monitor total Drive storage usage across the organisation

Track and report aggregate Drive usage per user and group, so you see quota risks before they hit.

Generate usage reports for Shared Drives via API

Automate reporting on file counts, storage, and activity within Shared Drives to satisfy audit, billing, or capacity planning requirements.

Report Google Drive usage across the whole organisation

Pull storage and activity data for every user’s Drive to audit quotas, flag outliers, or feed billing models.