The Google Spreadsheet™ add-on captures the Google Groups™ in your domain and list the group settings and the group members. You need to be Google Group™ administrator to use the add-on.
Listing updated:January 7, 2023
Works with:
The Google Spreadsheet™add-on captures the Google Groups™ in your domain and list the group settings and the group members. The add-on is only intended for Google admins who are allowed to manage the Google Groups™ in the domain, while the spreadsheet can be shared to anyone (e.g. servicedesk). 

The spreadsheet can be used to easily:
 - identify inconsistent naming convention
 - identify Google Groups without any members, without an owner/manager. 
 - identify Group settings that make no sense. E.g. 
    - collaborative inbox without archive
    - mail distribution list without the ability to receive mail
- agree to a best practice setting per Google Group type

How it works
The Google Spreadsheet™ add on '123 Toolkit for Google Groups' facilitates the listing in 3 steps:
 1. Get a list of all your Google Groups™ in the domain (or just a few groups)
 2. Get the settings and / or members of the Google Groups™ in the list (that you created in step 1)
 3. Optionally you can schedule this task on a daily or weekly basis.

On installation of the add-on you will get the relevant sheets (Groups, Group settings, Group members) automatically. In a new sheet you can create those mandatory sheets via the tools menu button. 

A simple manual can be accessed on:

The product website can be found on: 
Additional information
PricingFree of charge
Privacy policy
Terms of service
123 Toolkit for Google Groups™ will ask for the permissions shown below. Learn more
123 Toolkit for Google Groups™ will need access to your Google account
This will allow 123 Toolkit for Google Groups™ to :
View and manage spreadsheets that this application has been installed in
View groups on your domain
View and manage the settings of a G Suite group
Display and run third-party web content in prompts and sidebars inside Google applications
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
No comments
Clear search
Close search
Google apps
Main menu