Create Groups from .csv

1,345 views
Skip to first unread message

David Everitt

unread,
Aug 31, 2016, 6:24:25 PM8/31/16
to Google Apps Manager
I'd like to add external email addresses to a group using a csv file. Is this possible with GAM? If so, could you provide an example command for how this can be accomplished.

Thank you!

Ross Scroggs

unread,
Aug 31, 2016, 6:55:06 PM8/31/16
to google-ap...@googlegroups.com
David,

You add members to a group like this:
gam update group test...@domain.com add member f...@bar.com
Let's say you have the CSV file GroupExternals.csv with two columns:
Group,ExternalMember

gam csv GroupExternals.csv gam update group ~Group add member ~ExternalMember


Ross


On Wed, Aug 31, 2016 at 3:14 PM, David Everitt <deve...@gprep.com> wrote:
I'd like to add external email addresses to a group using a csv file. Is this possible with GAM? If so, could you provide an example command for how this can be accomplished.

Thank you!

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" 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/04b8e929-6373-4d30-87a1-5b4a97c4c3ab%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--

Graham Ingleby

unread,
Sep 1, 2016, 6:40:52 AM9/1/16
to GAM group
You do of course need to make sure the group allows external members as well

 

 Graham Ingleby | Cloud Computing Consultant | +44 1344 203395 | ging...@ancoris.com

Google+      

Powered by Ancoris Signatures


On 31 August 2016 at 23:55, Ross Scroggs <ross.s...@gmail.com> wrote:
David,

You add members to a group like this:
gam update group test...@domain.com add member f...@bar.com
Let's say you have the CSV file GroupExternals.csv with two columns:
Group,ExternalMember

gam csv GroupExternals.csv gam update group ~Group add member ~ExternalMember


Ross

On Wed, Aug 31, 2016 at 3:14 PM, David Everitt <deve...@gprep.com> wrote:
I'd like to add external email addresses to a group using a csv file. Is this possible with GAM? If so, could you provide an example command for how this can be accomplished.

Thank you!

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-manager+unsubscribe...@googlegroups.com.



--

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" 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/CAJkvRS-_j2C%3DZQxO3gfft9jYvsDqCo-WwMuArEMRq0pwp12zgg%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.


This message is for the named person's use only.  If you receive this message in error, please delete it and notify the sender.  Ancoris reserves the right to monitor all e-mail communications through its networks. Ancoris Limited, Registered in England Number: 04830784, Registered address: 5a Frascati Way, Maidenhead, Berkshire SL6 4UY. Trading Address: Lily Hill House, Lily Hill Road, Bracknell, Berkshire RG12 2SJ


David Everitt

unread,
Sep 1, 2016, 4:51:24 PM9/1/16
to Google Apps Manager
That helps. Thank you. 

Now. How would I sync email addresses from a csv with 4 columns of email address to a google group?


On Wednesday, August 31, 2016 at 3:55:06 PM UTC-7, Ross Scroggs wrote:
David,

You add members to a group like this:
gam update group test...@domain.com add member f...@bar.com
Let's say you have the CSV file GroupExternals.csv with two columns:
Group,ExternalMember

gam csv GroupExternals.csv gam update group ~Group add member ~ExternalMember


Ross

On Wed, Aug 31, 2016 at 3:14 PM, David Everitt <deve...@gprep.com> wrote:
I'd like to add external email addresses to a group using a csv file. Is this possible with GAM? If so, could you provide an example command for how this can be accomplished.

Thank you!

--
You received this message because you are subscribed to the Google Groups "Google Apps Manager" 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-ap...@googlegroups.com.



--

+KimNilsson

unread,
Sep 2, 2016, 3:00:21 AM9/2/16
to Google Apps Manager
You don't.
Reformat your data, so it is in two columns.

David Everitt

unread,
Sep 14, 2016, 1:48:37 PM9/14/16
to Google Apps Manager
I ended up exporting my data as multiple single column csv files then merging my multiple csv files using a windows command: copy E:\GoogleGroups\*.csv E:\GoogleGroups\all.csv

then running gam update group <group name> sync member file E:\GoogleGroups\all.csv to get all the addresses added to the group.

Thank you!
Reply all
Reply to author
Forward
0 new messages