Multiprocess for several commands in one sheet

274 views
Skip to first unread message

Renato Osorio

unread,
Sep 28, 2023, 6:09:15 AM9/28/23
to GAM for Google Workspace
Hey all, 

I've been exploring alot in the several months of gamadv-xtd3. I'm currently trying to do something that is a bit strange, I need to extract several pieces of information for each user my company has, I've got all the gam scripts to go with it and I even got it to be batched. 

Now I'm trying to merge 3 commands in one spreadsheet, because if I am extracting 3 commands for 500 users, thats 1500 individual sheet i'd have to manually put all together. 

I've been told about this command
gam config auto_batch_min 1 redirect csv ./filelist.csv multiprocess csvfile users.csv:email print filelist fields id,title,etc.

 But I tried to replicate it with my 3 commands but I can't get it work. Below is the commands I'm trying to get to work. This is my latest trying and I'm so fully lost now.

Any advice would be fully appreciate or even examples please

gam config auto_batch_min 1 redirect csv ./renatokts.csv multiprocess user ren...@domain.com print filelist fields webviewlink,title,permissions,owners.emailaddress todrive
gam config auto_batch_min 1 redirect csv ./renatokts.csv multiprocess user ren...@domain.com print teamdriveacls todrive tdsheettitle "Team"
gam config auto_batch_min 1 redirect csv ./renatokts.csv multiprocess user ren...@domain.com print calendars showhidden todrive tdsheettitle "calendars"
commit-batch
gam group fung...@domain.com print userlist todrive

Ross Scroggs

unread,
Sep 28, 2023, 10:24:29 AM9/28/23
to google-ap...@googlegroups.com
By this "for each user my company has" I'm assumimg that you want data for all users.

As ren...@domain.com  build a  Google Sheet with three tabs for the data: Files, Team, Calendars
Look at the URL for each tab

You can update the three tabs of this sheet.

gam config auto_batch_min 1 redirect csv - multiprocess todrive tduser ren...@domain.com tdfileid 12345v6XzymHM2drJnstRr4FmEnM6atrbig5EPmwxyz tdsheet id:123 tdupdatesheet tdsheettitle "Files" all users print filelist fields webviewlink,title,permissions,owners.emailaddress
gam config auto_batch_min 1 redirect csv - multiprocess todrive tduser ren...@domain.com tdfileid 12345v6XzymHM2drJnstRr4FmEnM6atrbig5EPmwxyz tdsheet id:456 tdupdatesheet tdsheettitle "Team"  all users print teamdriveacls
gam config auto_batch_min 1 redirect csv - multiprocess todrive tduser ren...@domain.com tdfileid 12345v6XzymHM2drJnstRr4FmEnM6atrbig5EPmwxyz tdsheet id:789 tdupdatesheet tdsheettitle "Calendars"  all users print calendars showhidden

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 on the web visit https://groups.google.com/d/msgid/google-apps-manager/f84a15a1-6d3f-40b8-96b6-5db1928d29e9n%40googlegroups.com.

Reply all
Reply to author
Forward
0 new messages