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