Multiple Commands using a Google Sheet

[Don Beck]

I have a Google sheet that was 3 columns.  

The headers are:  Terminated    Transfer   Alias

I am looking to run mulitple commands using this sheet as reference.  I know the commands to do this for an individual user but looking to make changes in bulk.

I would like to:

1. Reset password for all users listed in Terminated Column to a set password (Expired1234)

2. Delete all groups from users listed in Teminated Column

3. Discover all aliases for each user listed in Terminated column and print them to a google sheet.

4. Datatransfer for each user in Terminated Column to user in Transfer Column

5. Delete all users in Terminated Column

6. Assign alias of user from terminated column to user in Alias Column

7. And if possible - assign any aliases discovered in #3 to user in Alias column

If easier - happy to manipulate the google sheet into multple files

[Rance Hall]

As an avid scripting user, this would be a good time to script the loop through the sheet looking at values and running any commands based on the values in the records.

 

If you don’t want to go to all this work, then you can split the sheet into sheets – plural.  And run a single gam command against each sheet in the

 

-- 

Rance Hall

ESU10 Network Services

rance...@esu10.org

308-698-1919

 

 

 

From: google-ap...@googlegroups.com <google-ap...@googlegroups.com> on behalf of Don Beck <dcb...@merig.com>
Date: Tuesday, April 11, 2023 at 1:47 PM
To: GAM for Google Workspace <google-ap...@googlegroups.com>
Subject: [GAM] Multiple Commands using a Google Sheet

[EXTERNAL EMAIL]

PLEASE NOTE

The information in this E-Mail message is legally privileged and confidential information intended only for the use of the individual(s) named above.  If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message.  If you have received this E-mail in error, please notify the sender. Thank you!

--
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/cb458d3a-2b30-4a0f-a737-ef5046e1be24n%40googlegroups.com.