Export calendar events from mulitple users to a single sheet

[Bryan Warren]

Short back story, we had our teachers create booking pages to schedule parent-teacher conferences. We are looking for a way to get a list of all the meetings that have been scheduled.   So I need to export this information from all the users. 

I have it mostly figured out with using the following command which uses a csv file with the users and the time frame of the events to export.  

gam csv calendar_ptc.csv gam calendar ~Email print events after ~StartTime before ~EndTime query "student name" singleevents todrive  

The issue is that this is creating a different sheet for every line in the CSV.  

 I want to get all the exports into a single sheet. 

Thanks

[Ross Scroggs]

gam redirect csv - multiprocess todrive  csv calendar_ptc.csv gam calendar ~Email print events after ~StartTime before ~EndTime query "student name" singleevents

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/2c1e4121-fb25-4426-95ea-23086740d36fn%40googlegroups.com.

[Bryan Warren]

That works. 

Thanks!