Update multiple group settings using CVS

41 views
Skip to first unread message

Zachary DiFonzo

unread,
Oct 19, 2023, 12:21:50 PM10/19/23
to GAM for Google Workspace
Hey All,

I pulled down a list of all our domain's groups and permissions using the following command: 
gam print groups domain <mydomain> allfields todrive

This works great,

Now, using the same sheet, I would like to update settings and permissions for multiple groups. Normally, I would use the following command if I was deploying the same settting for all groups: 

gam csv <listofgroups.csv> gam update group "~email" setting_title setting_state

(For example: gam csv <listofgroups.csv> gam update group "~email" who_can_join can_request_to_join

What I would like to do instead, is tell gam to use the sheet, and for each group, use the settings unique to the row. This is because I want different settings for different groups 

Hopefully that makes sense. 
Thanks as always!

Zachary DiFonzo

unread,
Oct 19, 2023, 2:29:44 PM10/19/23
to GAM for Google Workspace
This issue can be closed, I figured it out :)
I had a hunch, but I couldn't test since my GAM was tied up all morning removing 15K users from a groups, lol

The answer that worked for me was simple:
Let say I wanted to update who can post to a group, it would be 

gam csv <listofgroups.csv> gam update group "~email>" whoCanPostMessage " ~whoCanPostMessage

This worked great
Reply all
Reply to author
Forward
0 new messages