Use the Google Spreadsheet™ add-on to get a list of all Google Shared Drives and their members (user/groups) in a Google Spreadsheet™.
Listing updated:December 25, 2022
Works with:
No reviews
602
Overview
Important: You need to be a Google Workspace administrator with access to the Google Drives.

The Google Spreadsheet™ add-on gets a list of all the Shared Drives in the Google domain and list the members per Shared Drive. 

Some example use case; the  spreadsheet with the list can be used to:
 * View all Google Shared Drives in the Google Workspace domain
 * View all members of the Shared Drives
 * See which Shared Drives have no members
 * See which Shared Drives have no manager
Additional information
PricingFree of charge
Developer
Privacy policy
Terms of service
123 Toolkit for Shared Drives will ask for the permissions shown below. Learn more
123 Toolkit for Shared Drives will need access to your Google account
This will allow 123 Toolkit for Shared Drives to :
See and download all your Google Drive files
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Loading
Search
Clear search
Close search
Google apps
Main menu