Group Gator - Google Sheets Extension to Manage Groups

Video Demo: link

Prerequisite: You need to be a Delegated Manager of the group before you can manage its members. If you are missing access to an email group, please submit a Mojo ticket and we can update your access.

Before you begin to make edits in your spreadsheet, it is essential to pull the current list of users in the group before making any changes. This is just to ensure you have the most up-to-date list in your spreadsheet.

Select Extensions > Group Gator > Manage Groups
Change the drop down to Download from Google
Checkmark the groups you will work on
Select Preview and Apply Changes
In the pop-up window, it will preview the differences between the group in your spreadsheet and the users actually in the group
Select Apply

Mass Add / Remove Users

Once you have the most up-to-date data, you may begin adding and deleting emails from Column A. The information in Columns B and C will auto-populate later.
Once finished, in the same side-panel, change the drop down to Update group from Sheet
Checkmark the groups you have made changes to
Select Preview and Apply Changes
In the pop-up window, it will preview the changes you are making
Select Apply if the amounts are correct.

Common Issues

If after you make changes, Column B and Column C do not auto-populate the user's name, either that email does not exist in our Google workspace or it was typed incorrectly. Please confirm that the email in Column A is correct.
If you are missing Group Gator from your extension list, select Extensions > Add Ons > Get Add Ons > search for Group Gator in the Search Bar > Install

Article Updated 8/2/22 by YC