Embedded Files
Description of 123 Toolkit for Shared Drives
Description of 123 Toolkit for Shared Drives
When to use it
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
How it works
Add-on menu
Add-on menu
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
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
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
3-Insights
3-Insights
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.
Requirements
Requirements
You should be a Google Workspace super administrator in the Google domain
Installation
Installation
How to add the Google Workspace extension '123 Toolkit for Shared Drives' to your spreadsheet?
Option 1: Installation from the 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
Option 2: Installation from the Google Workspace marketplace
Go to the Google Workspace marketplace: https://workspace.google.com/marketplace
Search for “123 Toolkit for Shared Drives”
Click the button “Individual Install”
Go to Google Drive and start a new Google spreadsheet (https://sheets.new)
You find the add-on In the top menu bar of the Google Spreadsheet 'Extension'.
FAQ - Frequently Asked Questions
FAQ - Frequently Asked Questions
Do I need to be a Google Admin
Do I need to be a Google Admin
The toolkit requires you to be a Google Workspace super admin. See Google help about this role: https://support.google.com/a/answer/33325.
Is there a product roadmap available?
Is there a product roadmap available?
Toolkit seems fully loaded. Nothing on our roadmap. Do you miss a feature? Please send an email or fill in the contact form.
Is there a version history overview?
Is there a version history overview?
< Back to product description page
Report abuse