Bulk Create Groups from CSV file

6,208 views
Skip to first unread message

Anthony Murillo

unread,
May 8, 2018, 4:59:01 PM5/8/18
to GAM for G Suite
Is there a way to bulk create groups using info from a CSV file? 

Ross Scroggs

unread,
May 8, 2018, 5:24:14 PM5/8/18
to google-ap...@googlegroups.com
Anthony

Yes, make a CSV NewGroups.csv file with columns containing the data you want:
email,name,description,...

gam csv NewGroups.csv gam create group ~email name ~name description ~description ...

Ross

On Tue, May 8, 2018 at 1:55 PM, 'Anthony Murillo' via GAM for G Suite <google-ap...@googlegroups.com> wrote:
Is there a way to bulk create groups using info from a CSV file? 

--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsub...@googlegroups.com.
To post to this group, send email to google-apps-manager@googlegroups.com.
Visit this group at https://groups.google.com/group/google-apps-manager.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/9fea895c-1e62-4768-8f62-0a8ee4323d7c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--

Владислав Рыбальченко

unread,
Jan 28, 2020, 11:07:43 AM1/28/20
to GAM for G Suite
ok now i try apply some options via  creation script.
example^ gam csv test.csv gam create group ~email name ~name description who_can_join INVITED_CAN_JOIN who_can_view_membership ALL_MANAGERS_CAN_VIEW who_can_view_group ALL_MANAGERS_CAN_VIEW who_can_invite ALL_OWNERS_CAN_INVITE allow_external_members false who_can_post_message NONE_CAN_POST allow_web_posting false
But i got error thats parameters is not valid for argumet "gam create group". What i do wrong?

вторник, 8 мая 2018 г., 23:59:01 UTC+3 пользователь Anthony Murillo написал:

Ross Scroggs

unread,
Jan 28, 2020, 11:13:28 AM1/28/20
to google-ap...@googlegroups.com
You're missing the description value:
gam csv test.csv gam create group ~email name ~name description ~description who_can_join INVITED_CAN_JOIN who_can_view_membership ALL_MANAGERS_CAN_VIEW who_can_view_group ALL_MANAGERS_CAN_VIEW who_can_invite ALL_OWNERS_CAN_INVITE allow_external_members false who_can_post_message NONE_CAN_POST allow_web_posting false

Ross

--
You received this message because you are subscribed to the Google Groups "GAM for G Suite" 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/afb5ea75-de3d-4e8b-b456-0c8e3c4d1997%40googlegroups.com.


--

Владислав Рыбальченко

unread,
Jan 28, 2020, 12:08:53 PM1/28/20
to GAM for G Suite
thx a lot!!!! it works


вторник, 8 мая 2018 г., 23:59:01 UTC+3 пользователь Anthony Murillo написал:
Is there a way to bulk create groups using info from a CSV file? 

Bryan Clarke

unread,
May 1, 2024, 12:11:51 PM5/1/24
to GAM for Google Workspace
This is quite old but I am in need of assistance with this same thing. When creating a batch of groups with csv what are the headers I need to use? I want to assign owners and make sure that the groups are hidden from the global directory but can be posted to from external email sources. Any assistance is much appreciated

Tony Nelson

unread,
May 1, 2024, 12:15:27 PM5/1/24
to google-ap...@googlegroups.com
gam csv [path to csv] gam create group '~header for the group in csv' 


Thank you

Anthony "Tony" Nelson
Director of Information Security, Systems, and Infrastructure
The Howard School
1192 Foster St. NW
Atlanta, Georgia 30318




This message is intended only for the designated recipient(s).  This e-mail message and any documents attached to it are confidential and may contain information that is protected from disclosure by various federal and state laws, including the HIPAA privacy rule (45 C.F.R., Part 164).  If you are not the intended recipient, be advised that any use, dissemination, forwarding, printing, or copying of this message without the sender's written permission is strictly prohibited and may be unlawful.  Accordingly, if you have received this message in error, please notify the sender immediately by return e-mail or call (512) 628-0465, and then delete this message.

--
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/46971a87-9a4f-49c3-808f-242b10647c55n%40googlegroups.com.

Bryan Clarke

unread,
May 1, 2024, 12:25:13 PM5/1/24
to GAM for Google Workspace
Thank you for the reply! I am looking to understand what I need to use for the headers for the groups to assign owners and allow posting to group from external domains etc. are these headers? gam create group <Group Email Address> name <Group Name> description <Group Description> gal false showingroupdirectory false whocanadd none_can_add whocanjoin invited_can_join whocanleavegroup none_can_leave whocanviewgroup all_managers_can_view whocanviewmembership all_managers_can_view whocanpostmessage none_can_post archiveonly true

Ross Scroggs

unread,
May 1, 2024, 12:27:15 PM5/1/24
to google-ap...@googlegroups.com
Bryan,

You will need two commands;
create the group with whatever settings you want
add the owners

Under <GroupSettigsAttributes> see gal and whocanpostmessage


Ross

This message is intended only for the designated recipient(s).  This e-mail message and any documents attached to it are confidential and may contain information that is protected from disclosure by various federal and state laws, including the HIPAA privacy rule (45 C.F.R., Part 164).  If you are not the intended recipient, be advised that any use, dissemination, forwarding, printing, or copying of this message without the sender's written permission is strictly prohibited and may be unlawful.  Accordingly, if you have received this message in error, please notify the sender immediately by return e-mail or call (512) 628-0465, and then delete this message.

--
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/46971a87-9a4f-49c3-808f-242b10647c55n%40googlegroups.com.


--

Bryan Clarke

unread,
May 1, 2024, 12:29:05 PM5/1/24
to GAM for Google Workspace
This is perfect. I will bookmark the GITHUB! Thank you Ross!

Ross Scroggs

unread,
May 1, 2024, 12:30:05 PM5/1/24
to google-ap...@googlegroups.com
Bryan,

Send me a Meet/Zoom invitation.

Ross

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/05fe2487-7d54-4945-ab8d-14a7d873895en%40googlegroups.com.


--

Tony Nelson

unread,
May 1, 2024, 12:32:22 PM5/1/24
to google-ap...@googlegroups.com
Here is the link to what you need.

https://github.com/GAM-team/GAM/wiki/GAM3DirectoryCommands#add-members-managers-owners-to-a-group. just add another column to your csv with the manager you want to be for the groups give it any header you want, then substitute it in the correct command from the link.
https://github.com/GAM-team/GAM/wiki/GAM3DirectoryCommands#add-members-managers-owners-to-a-group

I hope this helps.

Thank you

Anthony "Tony" Nelson
Director of Information Security, Systems, and Infrastructure
The Howard School
1192 Foster St. NW
Atlanta, Georgia 30318



To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/05fe2487-7d54-4945-ab8d-14a7d873895en%40googlegroups.com.

Bryan Clarke

unread,
May 1, 2024, 12:38:04 PM5/1/24
to GAM for Google Workspace
I sent one Ross.

Thank you.

Reply all
Reply to author
Forward
0 new messages