Sheets Data?

Jason Komendat

unread,

Jan 26, 2022, 2:12:53 PM1/26/22

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 PM1/26/22

to google-ap...@googlegroups.com

Jason,

See: https://github.com/taers232c/GAMADV-XTD3/wiki/Users-Drive-Files-Manage#download-files

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

--

ross.s...@gmail.com

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 PM1/26/22

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 PM1/26/22

to google-ap...@googlegroups.com

Jason,

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

Ross

--

ross.s...@gmail.com

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/a16280a9-bf0a-476d-8e0a-def3186742cfn%40googlegroups.com.

James SEYMOUR

unread,

Jun 7, 2022, 3:41:04 AM6/7/22

to google-ap...@googlegroups.com

Hi Jason,

You may also want to look at using format pdf to download the Doc and preserve the formatting. Other formats are listed on this Wiki page https://github.com/taers232c/GAMADV-XTD3/wiki/Users-Drive-Files-Manage#download-files

Regards

James Seymour

Head of Systems and Communication

[t] +673.24.11.000 Ext 1203

[m] +673.717.2465

[Meet] meet.google.com/etp-wxiw-agb

[Time Zone] GMT +8 Hours

I'm using Inbox When Ready to protect my focus.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-manager/EA166A62-684C-42B8-9695-CE803123E34F%40gmail.com.