Use cases → Reporting and data
Report Drive storage usage per organisational unit
Aggregate and report Google Drive storage usage for each organisational unit using a delegated service account with Admin SDK access.
| Who it is for | IT administrators responsible for monitoring and managing storage usage across departments or teams. |
|---|---|
| APIs | Admin SDK, Drive API |
| Typical scopes | admin.reports.usage.readonly, drive.readonly |
The problem
Storage quotas are enforced at the tenant or pooled level, but overages are often driven by a handful of users clustered in specific organisational units. Without granular reporting, it’s impossible to target clean-up efforts or chargebacks.
How it works
- List all users in each organisational unit using the Admin SDK.
- Query storage usage for each user from the Reports API.
- Sum usage data by organisational unit and generate a report.
- Optionally, correlate heavy usage to shared drives if needed.
What changes
You get a per-OU breakdown of storage consumption, allowing targeted follow-up and policy enforcement instead of blanket quotas.
Watch it explained
“Safeguard Email & Drive Data with Google Workspace Data Loss Prevention DLP” — Suitebriar on YouTube. Third-party video, included because it covers this ground well. We are not affiliated with the channel.
Questions people ask
Does this include shared drives?
User usage includes files owned by the user, not files solely in shared drives. To report on shared drives, you must use the Drive API to enumerate drives and their organisers.
How often should I run the report?
Once daily is typical, as the underlying usage data does not update in real-time. More frequent runs will hit the same data and burn quota.
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 guideRelated use cases
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.
Score calls or meetings against a rubric, nightly
Turn recordings and transcripts into a consistent, ranked scorecard your team can act on.
Report on user activity patterns across Workspace
Aggregate and analyse user activity events using a delegated service account to spot trends, anomalies, and compliance issues across multiple users.