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