Creates Contacts from Google Spreadsheet

45 views
Skip to first unread message

Don Beck

unread,
Jun 11, 2025, 4:13:49 PM6/11/25
to GAM for Google Workspace
I would like to have two commands that create contacts for a specific user in our domain.  I've attached an Excel spread with the info I'd like to populate but I'd make it a Google Sheet for the actual import commands.  Thinking each tab would be it's own command

Thanks
Don
Sample Contact Import File.xlsx

Don Beck

unread,
Jun 12, 2025, 4:07:08 PM6/12/25
to GAM for Google Workspace
thanks for the help Ross!!  It works great

gam redirect stdout ./createcontacts.log multiprocess redirect stderr stdout csv gsheet us...@domain.com <file id> id:<tab id> gam userdestination us...@domain.com create contact contactgroup "~Label" firstname "~First Name" lastname "~Last Name" organization work "~Organization Name" title "~Organization Title" primary email "~E-mail 1 - Label" "~E-mail 1 - Value" primary phone "~Phone 1 - Label" "~Phone 1 - Value" primary phone "~Phone 2 - Label" "~Phone 2 - Value" notprimary address "~Address 1 - Label" streetaddress "~Address 1 - Street" locality "~Address 1 - City" region "~Address 1 - Region" postalcode "~Address 1 - Postal Code" primary
Reply all
Reply to author
Forward
0 new messages