123 Toolkit for Shared drives
Description of 123 Toolkit for Shared Drives
When to use it
The Google Spreadsheet™ add-on gets a list of all Google Shared Drives into a Google Spreadsheet™. Some example use case; the spreadsheet with the list can be used to:
View all your Google Shared Drives
View all the members of the Shared Drives
Get insights on the Google Shared Drive permissions
How it works
After installation you will have in the Extension menu of your Google Spreadsheet the entry of ‘123 Toolkit for Shared Drive’.
Click on ‘Show configuration’ to open the Spreadsheet add-on sidebar.
1 - List Shared Drives
On the first tab you can click the button to list all your Shared Drives in your spreadsheet.
2 - List members
On the second step you can click the button to get all the members in the Shared Drives listed in your Spreadsheet.
Note, the function only looks up the members of the Shared Drives that are listed on the Shared Drive sheet.
Screenshot with data
On the third step you can optionally create an extra sheet called ‘Insights’. The sheet will provide a few statistics and insights on your Shared Drive data.
You should be a Google Workspace super administrator in the Google domain
How to add the Google Workspace extension '123 Toolkit for Shared Drives' to your spreadsheet?
Option 1: Installation from the spreadsheet
Start a new Google Spreadsheet in Google Drive. (https://sheets.new)
In the top menu bar of the Google Spreadsheet select Extensions.
Click in the menu “Add-ons” and “ Get add-ons”.
A new pop-up window will show the Google Workspace marketplace.
Search for “123 Toolkit for Shared Drives”.
Click the button “Individual Install”.
Option 2: Installation from the Google Workspace marketplace
Go to the Google Workspace marketplace: https://workspace.google.com/marketplace