📖 2 mins read

Manage Google Group members via Spreadsheets

To manage Google Group members via spreadsheets, we need an export to any group.

This allows managing group members in bulk for multiple groups and multiple members

Navigate to Groups audit.

Then click on Group members 

To do so click on the export button and export it into a spreadsheet.

Manage Google Group Members via Google Spreadsheets 1

 

There are three options to manage groups via spreadsheet:

Edit an existing group

Add a member to a existing group

Delete a member of a group

Edit an existing group

Edit members of the existing group.

Find the group you want to edit and export into a spreadsheet.

Edit the green fields, Owner or Manager – change the values to Yes or No

Manage Google Group Members via Google Spreadsheets 2

Close the spreadsheet ( this will auto-save the changes)

Click on Import button and add the changes back

Manage Google Group Members via Google Spreadsheets 3

Click on the checkmark and view the changes

Manage Google Group Members via Google Spreadsheets 4

 

Note: Type equals to Update and the values for Manager and Owner

Click on Accept and the changes will be applied.

Manage Google Group Members via Google Spreadsheets 5

The members will be updated accordingly

They will be edited and updated as stated, either as Manager or Owner 

 

Add a member to an existing group

Export Group members (any search)

At the bottom of the sheet,

In Group field add the group name

In the Member field add the members.

Enter the new members (email addresses) to be added to the group

Followed by the owner/manager with yes or no values.

Manage Google Group Members via Google Spreadsheets 6

Close the spreadsheet ( this will auto-save the changes)

Click on the import button again

Manage Google Group Members via Google Spreadsheets 7

View the changes that will occur.

Note: Type will be equal to Create as we are adding a new member to the group.

Click on Accept to import the changes

When we search for the group we added additional members to, we can see the new members added accordingly.

Manage Google Group Members via Google Spreadsheets 8

 

Delete and remove a member of a group

Find the group from where you want to remove the members.

Or search for the member and choose from which group to remove from.

Once you find the result click and export it into a spreadsheet.

Find the user you want to remove from a group.

Replace the group id

Add DELETE to the ID field

Manage Google Group Members via Google Spreadsheets 9

Close the spreadsheet ( this will auto-save the changes)

Manage Google Group Members via Google Spreadsheets 10

Click on the import button again

View the changes that will occur.

Note: Type will be equal to DELETE as we are removing the members from the groups.

Click on Accept to import the changes

The members will be removed from the selected groups.

The changes can be seen in Google Admin Console – Groups

The progress of those actions can also be checked in GAT+ Admin log 

 

Thanks for sharing and spreading the word!