Google Calendar details on Google Sheet

[ajojose33333344]

is it possible to export calendar events data of 20 + users to spreadsheet automatically on daily basis

[KAM · Accepted solution]

@ajojose33333344 When in doubt, the answer is likely GAM.  Invented at Gito, GAM's proper pronunciation is like OMMM so as an administrator you can meditate saying GAMMMMMM.

Here's a blog about GAM and this link is where I would start about the calendar question:

https://www.ditoweb.com/2021/03/using-open-source-google-apps-manager-to-administer-google-workspace...

 https://sites.google.com/jis.edu.bn/gam-commands/services/calendar?pli=1#h.p1xo34pwy0v

Good luck! -KAM

[KAM · Accepted solution]

@ajojose33333344 When in doubt, the answer is likely GAM.  Invented at Gito, GAM's proper pronunciation is like OMMM so as an administrator you can meditate saying GAMMMMMM.

Here's a blog about GAM and this link is where I would start about the calendar question:

https://www.ditoweb.com/2021/03/using-open-source-google-apps-manager-to-administer-google-workspace...

 https://sites.google.com/jis.edu.bn/gam-commands/services/calendar?pli=1#h.p1xo34pwy0v

Good luck! -KAM

[ajojose33333344 · Accepted solution]

@KAM Thanks, it can be used for individual users.

we can use this : gam redirect csv ./UserEvent.csv multiprocess csv users.csv gam user "~PrimaryEmail" print events after 2023-01-01 

for bulk

[KAM]

@ajojose33333344 GAM is a must for all Workspace Admins.  -KAM