Sync Group From CSV

[Roger Frutiger]

I am setting up an automated sync of a Google group using GAM on Windows under powershell. I have mostly worked around my issue for this first automation, but I did have a couple of questions, and hope someone here can shed some light. 

1. In the documentation the example for using a multi-column CSV file <pathtofile>:<column_name>
   The problem I am having with this is that GAM is not splitting on the : and is evaluating the entire string as the file path, which results in file not found.
    
2. As a workaround I have created a single column no header csv file. This works but the default output for us is to have values in a CSV  wrapped in double quotes. GAM is reporting that "em...@domain.com" is not found in our Google tenant. Is this expected behavior? we are on GAM version 7.47.06. When I strip the quotes the file is processed as expected.

[Ross Scroggs]

Roger,

Send me a private Meet/Zoom invitation and I'll help. I'm available for the next 30 minutes.

Ross

----

Ross Scroggs

Ross.S...@gmail.com

--
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 visit https://groups.google.com/d/msgid/google-apps-manager/4072d260-5b8f-4cc6-905e-6d289c4b3005n%40googlegroups.com.

[Roger Frutiger]

sent a link to your gmail.

On Wednesday, August 26, 2026 at 2:21:38 PM UTC-7 Ross Scroggs wrote:

Roger,

Send me a private Meet/Zoom invitation and I'll help. I'm available for the next 30 minutes.

Ross

----

Ross Scroggs

Ross.S...@gmail.com

On Aug 26, 2026, at 2:18 PM, 'Roger Frutiger' via GAM for Google Workspace <google-apps-manager@googlegroups.com> wrote:

I am setting up an automated sync of a Google group using GAM on Windows under powershell. I have mostly worked around my issue for this first automation, but I did have a couple of questions, and hope someone here can shed some light. 

1. In the documentation the example for using a multi-column CSV file <pathtofile>:<column_name>
   The problem I am having with this is that GAM is not splitting on the : and is evaluating the entire string as the file path, which results in file not found.
    
2. As a workaround I have created a single column no header csv file. This works but the default output for us is to have values in a CSV  wrapped in double quotes. GAM is reporting that "em...@domain.com" is not found in our Google tenant. Is this expected behavior? we are on GAM version 7.47.06. When I strip the quotes the file is processed as expected.

--
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-manager+unsub...@googlegroups.com.

[Roger Frutiger]

Anyone coming behind me having these issues, it came down to me not reading the documentation correctly. I didn't realize there were both file and csvfile arguments which behave differently. If you use file, GAM is going to read the entire line including any quotes as the username, if you have a csv with header row csvfile will properly split on the : and handle the quoting. Thanks again Ross, the help was much appreciated.