Updating multiple groups with a CSV

192 views
Skip to first unread message

Lauren Thompson

unread,
Jan 4, 2023, 5:35:12 PM1/4/23
to GAM for Google Workspace
I have to add  a user as a manager to several groups. Is it possible to do this with a CSV?

Ross Scroggs

unread,
Jan 4, 2023, 5:42:42 PM1/4/23
to google-ap...@googlegroups.com
Lauren

Make  CSV file Groups.csv
group
...

gam csv Groups.csv gam update group "~group" add manager new...@domain.com

Ross
----
Ross Scroggs



On Jan 4, 2023, at 2:35 PM, 'Lauren Thompson' via GAM for Google Workspace <google-ap...@googlegroups.com> wrote:

I have to add  a user as a manager to several groups. Is it possible to do this with a CSV?

--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/5127c70f-4d64-4ded-9e0c-a625c2f7ff56n%40googlegroups.com.

Maj Marshall Giguere

unread,
Jan 4, 2023, 5:48:17 PM1/4/23
to google-ap...@googlegroups.com
Lauren;

If it's a fairly short list of groups and only one user you might try:

$> gam update groups group1@xxx.x,gro...@xxx.xx,gro...@xxx.xx... add manager us...@xxx.xx

Maj Marshall E Giguere
NH Wing Director of IT
Civil Air Patrol, U.S. Air Force Auxiliary
GoCivilAirPatrol.com
nhwg.cap.gov
Volunteers serving America's communities, saving lives, and shaping futures.


On Wed, Jan 4, 2023 at 3:35 PM 'Lauren Thompson' via GAM for Google Workspace <google-ap...@googlegroups.com> wrote:
I have to add  a user as a manager to several groups. Is it possible to do this with a CSV?

--

Lã Hải Nam

unread,
Jan 4, 2023, 10:48:14 PM1/4/23
to GAM for Google Workspace
I need to create multiple groups using a csv file but am giving me an error, can you guide me how to do it?Screenshot_33.png

Sergio Alvarez

unread,
Jan 5, 2023, 8:34:23 AM1/5/23
to GAM for Google Workspace
You should change the headers on the CSV file to values that do not have spaces, that will save you a lot of headaches 

Maj Marshall Giguere

unread,
Jan 5, 2023, 6:10:30 PM1/5/23
to google-ap...@googlegroups.com
Without seeing the actual csv file, but looking at the error message it appears your CSV file does not have a column header named "email", therefore gam can't substitute "~email".  Looks like you have a column header named "Group Email [Required]".  Is that the group email address you are trying to create?  If so I suggest you try:
   gam csv test.csv gam create group "~Group Email [Required]"

Or you could just change the name of the column header to "email"


Maj Marshall E Giguere
NH Wing Director of IT
Civil Air Patrol, U.S. Air Force Auxiliary
GoCivilAirPatrol.com
nhwg.cap.gov
Volunteers serving America's communities, saving lives, and shaping futures.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/ffa32fe4-1711-4603-880c-16bd298b9722n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages