using GAM To download and update a google sheet

701 views
Skip to first unread message

Brian Pugh

unread,
May 12, 2021, 6:48:24 AM5/12/21
to GAM for Google Workspace
I am new to GAM, but I've learned how to use it to download a google sheet to my C drive as a csv.

I am wondering if I can use GAM to update the same sheet by downloading it again, replacing the previously downloaded copy with the newer one, using the same name.
Thank you for any direction you can provide me.

Ross Scroggs

unread,
May 12, 2021, 11:31:21 AM5/12/21
to google-ap...@googlegroups.com
Brian,

Replace drivefilename "<DriveFileName>" with id <DriveFileID> if <DriveFielName> is not unique.

gam user us...@domain.com get drivefile drivefilename "Test Sheet" format csv

Edit local sheet

gam user us...@domain.com update drivefile drivefilename "Test Sheet" localfile "Test Sheet.csv"


Ross


--
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/7cd77cca-2ee6-4c1f-ace2-c7874f91cc5cn%40googlegroups.com.


--

Brian Pugh

unread,
May 12, 2021, 1:54:43 PM5/12/21
to google-ap...@googlegroups.com
Ross, I really appreciate your help. Thank you!

Brian

You received this message because you are subscribed to a topic in the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-manager/qCxsOn-FK8I/unsubscribe.
To unsubscribe from this group and all its topics, 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/CAJkvRS9X0eZC6kbugJc-Vp8SF-0KYm2YwiXBSV9Yb2Wy9%3DrAvA%40mail.gmail.com.
Reply all
Reply to author
Forward
Message has been deleted
0 new messages