Use the Google Spreadsheet™ add-on '123 Toolkit for Shared Drives' to get a list of your Google Shared Drives in a Google Spreadsheet™. The add-on ensures that you have a list in the spreadsheet that you can sort / compare or filter when you need so.
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 manager
See which Shared Drives have no members at all
You need to be a Google Workspace administrator with access to the Google Shared Drives. The Google Spreadsheet™ add-on gets a list of all the Shared Drives in the Google domain and lists the members per Shared Drive. For more info, see the help guide for 123 Sync for Google Shared Drives.
Learn how we handle your data via our privacy statement of 123 Toolkit for Shared Drives.