Sheets Data?

16 views
Skip to first unread message

Jason Komendat

unread,
Jan 26, 2022, 2:12:53 PMJan 26
to GAM for Google Workspace
Is there any way of exporting data from a Google sheet to a CSV?

Looking to automate a task and need the data to end up in a CSV

Ross Scroggs

unread,
Jan 26, 2022, 2:44:28 PMJan 26
to google-ap...@googlegroups.com
Jason,


This will download the first tab in a sheet.
gam user us...@domain.com get drivefile <FileID> format csv

This will download s specific tab in a set.
gam user us...@domain.com get drivefile <FileID> gsheet <SheetName>
gam user us...@domain.com get drivefile <FileID> gsheet id:<Number>

Ross

On Jan 26, 2022, at 11:12 AM, Jason Komendat <jkom...@crschools.us> wrote:

Is there any way of exporting data from a Google sheet to a CSV?

Looking to automate a task and need the data to end up in a CSV

--
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/286f58a5-5966-482d-a68a-00cb049537can%40googlegroups.com.

Jason Komendat

unread,
Jan 26, 2022, 3:11:13 PMJan 26
to GAM for Google Workspace
Yea this worked but I guess the soruce what I thought was a sheet was a doc so it exports as an unreadable .ods file.

Ross Scroggs

unread,
Jan 26, 2022, 3:41:38 PMJan 26
to google-ap...@googlegroups.com
Jason,

gam user us...@domain.com get drivefile <FileID> format txt

Reply all
Reply to author
Forward
0 new messages