Gam updating google sheet every night

[Mark Bersee]

Hi all,

I want to export the following fields to a gsheet.
primaryEmail,orgUnitPath,firstname,lastname

But I need the sheet to be updated every night without changing the sharing permissions or link. 

I tried writing to users.gsheet and then using "gam user update drivefile" but that would result in a binary file instead of a gsheet

Kind regards,

Mark Bersee

[Ross Scroggs]

Mark,

This is possible with Advanced GAM, see: https://github.com/taers232c/GAMADV-XTD3/wiki/Todrive#update-an-existing-sheet-within-an-existing-file

gam redirect csv - todrive tdfileid <FileID> tdsheet id:<SheetID> tdupdatesheet print users fields orgunitpath,name

Ross

--

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 on the web visit https://groups.google.com/d/msgid/google-apps-manager/1e7a676c-0f8f-4c72-8b4b-64c0495d634cn%40googlegroups.com.