Bulk update domain groups

The Update domain groups feature allows for users to be added and removed from Google Groups that are managed via your G Suite domain.  

 Screen_Shot_2017-03-21_at_4.37.01_PM.png

A read-only column for Current group membership can be used as a guide, and with filters, to help identify users that need to be added or removed to/from domain groups.  This column is populated when you check the Include Group Membership box on the load users tab in the sidebar. This will increase the time it takes to load the users.

Screen_Shot_2017-03-21_at_4.40.41_PM.png

Changes are made within the Add to domain groups and Remove from domain groups columns in the Domain group changes column group.

Screen_Shot_2017-03-21_at_4.42.18_PM.png

A full preview of domain group changes will be shown in a dialog prior to executing any changes. 

Screen_Shot_2017-03-21_at_4.44.06_PM.png

Toggle the slider in the upper right corner of the preview modal to switch between list view and per-user view of changes to be made.

Screen_Shot_2017-03-21_at_4.44.38_PM.png

 

Things to keep in mind

Adding or removing a user to/from domain groups requires that the data you input into these columns be valid with respect to the possible changes that can be performed on each user.  The following are invalid values, and will be ignored during the update if discovered during the preview process.

  • Can't both Add & Remove:  This means you have entered the same group in both the Add and Remove columns in the sheet.
  • User is already a member: The user is already in the group to which you are trying to add them.
  • User is not a member:  You are trying to remove a user from a group that they are not a member of.
  • Can't operate on nonexistent group: You've misspelled or left off part of the domain group's email address, or used an illegal separator between multiple groups (must be comma separated).

You can filter for each error type by clicking on the left hand region bearing the relevant label.

Screen_Shot_2017-03-21_at_4.58.01_PM.png