Request Feature: Bulk Export of Shared Drive Metadata (Creator, Storage Limit, Usage, Permissions)

Google Workspace Developers Q&A
,
1

Hello Google Team,

I am an administrator managing a large Google Workspace domain. We currently have around 4,000 Shared Drives across our organization, and we urgently need the ability to export Shared Drive metadata in bulk for auditing, storage management, and compliance reporting.

At the moment, the Google Workspace Admin Console does not provide any option to export detailed Shared Drive information. We have already contacted Google Support, and they confirmed that this feature is not available.

We need the ability to export the following data for all Shared Drives:

  1. Shared Drive name

  2. Shared Drive ID

  3. Creator / Created-by user

  4. Storage limit (if any)

  5. Current storage usage

  6. Last updated timestamp

  7. Number of members

  8. Member list with roles (optional, but useful)

  9. Manager / Content manager list

  10. File count inside each Shared Drive

Why this feature is important:

  • Large organizations like ours must perform regular audits of Shared Drive usage.

  • We need a complete overview of storage consumption to manage our Google Workspace pooled storage effectively.

  • Helps identify unused or orphaned Shared Drives.

  • Ensures Shared Drives follow organizational data governance and security policies.

Current limitations:

  • No export option inside the Admin console.

  • Manual checking is impossible for 4,000+ Shared Drives.

  • Google Drive APIs provide partial data but require complex scripting for complete information.

Feature Request:

Please add a Bulk Export / CSV Download feature in the Admin Console under:
Apps → Google Workspace → Drive and Docs → Manage Shared Drives

This export should allow administrators to download all metadata for every Shared Drive in the domain.

We believe this feature will greatly benefit enterprise customers and make Shared Drive management more efficient and transparent.

Thank you.

2

Hey,

Hope you’re keeping well.

There’s no built‑in bulk export for Shared Drive metadata in the Admin console today, so the most practical approach is to script against the Google Drive API and Admin SDK Reports API. You can list all Shared Drives with drives.list and then iterate through drives.get plus permissions.list to collect creator info, member roles, and counts. Storage usage per Shared Drive isn’t exposed directly, but you can sum file sizes returned by files.list with the driveId parameter, or use the Reports API for overall Drive storage metrics. For automation at scale, run the script with a service account that has the necessary Drive Service Admin and Reports Reader roles. If you’d like this in‑console, you can submit it via the Google Workspace Feature Ideas page so product teams can review.

Thanks and regards,
Taz