Create User Emails + Automatic Welcome Email

56 views
Skip to first unread message

Kristina Aiello

unread,
Jul 22, 2025, 12:42:45 PMJul 22
to GAM for Google Workspace
Hi!

I am trying to use a csv to bulk create users and send a welcome email to their personal. I have gotten this to work with the unformatted/default welcome email, but now I am trying to use a custom message, and I keep getting a syntax error. I've tried doing it as a gdcoc with the ID, as an html file within my GAM folder on my desktop, and also as an html link, and none are working. 

Example: gam csv /Users/KristinaAiello/GamWork/newusers.csv gam create user "~Email" firstname "~FirstName" lastname "~LastName" org "~OrgUnit" password "~password" changepasswordatnextlogin notify "~PersonalEmail" message gdoc 1OGygvpr-RbmUbf06luUX2EtDrevCOkDU7KIA0TRK8JQ

Any guidance would be appreciated! Thanks in advance.

Ross Scroggs

unread,
Jul 22, 2025, 12:49:16 PMJul 22
to google-ap...@googlegroups.com
Show a sample command and the error message; replace sensitve data with xxx

Ross
----
Ross Scroggs



--
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/212cedf3-5e9f-4c0b-a400-12c19507073dn%40googlegroups.com.

Kristina Aiello

unread,
Jul 22, 2025, 12:51:52 PMJul 22
to GAM for Google Workspace

MacBook-Pro:~ KristinaAiello$ gam csv /Users/KristinaAiello/GamWork/newusers.csv gam create user "~Email" firstname "~FirstName" lastname "~LastName" org "~OrgUnit" password "~password" changepasswordatnextlogin notify "~PersonalEmail" message gdoc 1OGygvpr-RbmUbf06luUX2EtDrevCOkDU7KIA0TRK8JQ

2025-07-22T16:50:17.375+00:00,0/1,Using 1 process...

2025-07-22T16:50:17.375+00:00,0,Processing item 1/1

Command: gam create user testaiello2@xxxxx firstname Test lastname Aiello2 org staff/Employees/EHS password Everett1 changepasswordatnextlogin notify xx...@gmail.com message gdoc >>>1OGygvpr-RbmUbf06luUX2EtDrevCOkDU7KIA0TRK8JQ<<< 


ERROR: Invalid argument

Help: Syntax in file /Users/KristinaAiello/bin/gamadv-xtd3/GamCommands.txt

Help: Documentation is at https://github.com/GAM-team/GAM/wiki

2025-07-22T16:50:18.445+00:00,0/1,Processing complete

MacBook-Pro:~ KristinaAiello$ 

Ross Scroggs

unread,
Jul 22, 2025, 12:54:41 PMJul 22
to google-ap...@googlegroups.com
You have to specify a user that can read the Google Doc; replace us...@domain.com with actual value.

gam csv /Users/KristinaAiello/GamWork/newusers.csv gam create user "~Email" firstname "~FirstName" lastname "~LastName" org "~OrgUnit" password "~password" changepasswordatnextlogin notify "~PersonalEmail" message gdoc us...@domain.com 1OGygvpr-RbmUbf06luUX2EtDrevCOkDU7KIA0TRK8JQ

Ross
----
Ross Scroggs


Kristina Aiello

unread,
Jul 22, 2025, 12:58:57 PMJul 22
to GAM for Google Workspace
Ah okay! That seemed to work better, but now I am getting this:

gam csv /Users/KristinaAiello/GamWork/newusers.csv gam create user "~Email" firstname "~FirstName" lastname "~LastName" org "~OrgUnit" password "~password" changepasswordatnextlogin notify "~PersonalEmail" message gdoc xx@xx 1OGygvpr-RbmUbf06luUX2EtDrevCOkDU7KIA0TRK8JQ

2025-07-22T16:57:46.438+00:00,0/1,Using 1 process...

2025-07-22T16:57:46.438+00:00,0,Processing item 1/1


ERROR: User: testaiello2@xx, Create Failed: Invalid Input: [xx@xx]


Ross Scroggs

unread,
Jul 22, 2025, 1:03:37 PMJul 22
to google-ap...@googlegroups.com
xx@xx is not a valid email address in yiu domain.

Send me a private Meet/Zoom invitation and I'll help.

Ross
----
Ross Scroggs


Kristina Aiello

unread,
Jul 22, 2025, 1:20:31 PMJul 22
to GAM for Google Workspace
Just emailed you the link!
Reply all
Reply to author
Forward
0 new messages