[SOLVED] Modify Google Groups Bulk Settings

Print this post Email this post

When migrating from other platform, I was used to having public facing aliases that forwards to multiple addresses. For example, sales@mydomain.com will be forwarded to salesman.john@mydomain.com and saleswoman.jane@mydomain.com. The default setting for Google Groups for Business to have this setup is by setting a “Public Group” that allow posts from external email address. This is not the only public facing group that we have, in fact we have about 200 of these. Unfortunately, we also have groups such as hr@mydomain.org (that only forward to humanresource.person@mydomain.com) that’s public facing. The default option for public facing group is to have the post viewable from anyone in the organization. It could be worse if the “App Setting” is also set to public.

My initial expectation is that even if a group can receive emails publicly, it should only limit the viewing of the topics only to the members, but it is not. Even when using salesman.john@mydomain.com account, I was able to view posts from hr@mydomain.com. In the beginning, Google support told me that it’s the admin’s job to make sure that each created group to be fully setup manually and checked for every permission. That means, when creating a group I have to:

  1. Create the group
  2. Set the group as public facing
  3. Add the users
  4. Go to the group page
  5. Access the group advanced permission setting
  6. Change the “View Post” to “All Members of the Group only”

There’s no way to set this setting as the default, so it has to be done for every single group.

In order to fix my issue, Google support also advised me to manually change the “View Topic” setting through the GUI for each group. That’s over 200 groups and it’s going to be tedious and error prone.

In the end I found a tool that I can use to make list the group, and make the bulk changes. The command prompt tool is called GAM (Google-Apps-Manager) created by Dito. I also have a scripting method to update all groups at once.

In summary, the steps that you need to take are the following:

  1. Download GAM (Google-Apps-Manager) & make sure that you have PowerShell
  2. Extract the tool
  3. Use the PowerShell and access the extracted directory
  4. initialize it by running the command:gam info domainThe tool will redirect you to Google Security section and get the token needed
  5. Get the list of all groups by running the command: gam print groups > groups.csvThis will create a groups.csv file that we will use to update. You can also manually add/delete other groups.
  6. Run the update command for each group in the CSV file with the following command:$list = Import-Csv groups.csv
    foreach ($entry in $list){ .\gam.exe update group $($entry.Email) settings who_can_view_group all_members_can_view; echo $entry.Email updated }
Be Sociable, Share!

Leave a Reply

You must be logged in to post a comment.