123 Toolkit for Google Groups
Description of 123 Toolkit for Google Groups
When to use it
The Google SpreadsheetTM add-on will get the Google Groups of the domain and list all settings and members of those Groups. You need to be a Google admin to utilize the add-on.
Use the Google Spreadsheet™ add-on '123 Toolkit for Google Groups' to get a list of all your Google Groups, Group settings and Group members from the Google Directory into your Google Spreadsheet™. The add-on ensures that you have a list in the spreadsheet that you can sort / compare or filter device data when you need so. You can also perform (bulk) actions on the domain contact profiles.
The Spreadsheet extension is created with the following use cases in mind.
Reporting; Report the Google Groups in the domain, the members and the settings.
Analyze; Analyze Group settings to ensure proper configuration for intended use.
Clean up; Remove Google Groups which don't have members anymore.
To support the use cases a sheet called ‘Analysis’ is created.
How it works
The Google Spreadsheet™ add on '123 Toolkit for Google Groups facilitates the (one way) sync of Google Groups and Google Groups settings to a spreadsheet in 3 steps:
List all groups in your domain
List all group settings and/or members
View the result in your Google Spreadsheet, optional share the spreadsheet to others.
For the Google Group you have several options:
Filter Google Groups by naming convention.
Update Google Group settings.
Open Google Group to change members.
1 - List Google Groups
Click the button 'List Groups' to get a list of all Google Groups from the Google Directory into your spreadsheet. You need to be a Google Super administrator in your Google domain.
Note, the add-on will by default only get the Google Groups of the Google domain of your Google account. Via the Set domains button you can specify other secondary domains.
2-List Members and Settings
You can get a list of all Google Group members
You can get a list of all Google Group settings
3-Scheduling & Insights
Schedule the app, to keep your lists up to date by scheduling the add-on.
Add the sheet 'Insights' to get a dashboard on your Google Groups.
Groups without owner/manager
Groups without members
Settings combination that make no sense
You should be a Google Workspace super administrator in the Google domain.
How to add the Google Workspace extension '123 Toolkit for Google Groups' 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 Google Groups”.
Click the button “Individual Install”.
Option 2: Installation from the Google Workspace marketplace
Go to the Google Workspace marketplace: https://workspace.google.com/marketplace