help guide

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

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

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

  1. Start a new Google Spreadsheet in Google Drive. (

  2. In the top menu bar of the Google Spreadsheet select Extensions.

  3. Click in the menu “Add-ons” and “ Get add-ons”.

  4. A new pop-up window will show the Google Workspace marketplace.

  5. Search for “123 Toolkit for Shared Drives”.

  6. Click the button “Individual Install”.

Option 2: Installation from the Google Workspace marketplace

Go to the Google Workspace marketplace:

  1. Search for “123 Toolkit for Shared Drives

  2. Click the button “Individual Install

  3. Go to Google Drive and start a new Google spreadsheet (

  4. You find the add-on In the top menu bar of the Google Spreadsheet 'Extension'.

FAQ - Frequently Asked Questions

Do I need to be a Google Admin

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?