Downloading a particular tab of a Google Sheets spreadsheet

[Immanuel Burton]

The following GAM command:

gam user xxxx...@somewhere.com get drivefile id 1234567890abcdefghijklmnopqrstuvwxyz format csv

downloads the first tab of the spreadsheet in question as a CSV file.

If I know either the name or GID of a particular tab in the spreadsheet, is there a way of downloading just that tab?  I have no way of guaranteeing that the tab that I want to download will always be the first tab, as other users may (for reasons known best to themselves) with whom the spreadsheet is shared may move tabs around.

Thank you.

Immanuel Burton.

[+KimNilsson]

Just use the full URL of the tab instead of just the id, with the GID part.

gam user userATdomain get drivefile https://docs.google.com/spreadsheets/d/1234567890abcdefghijklmnopqrstuvwxyz/edit#gid=123456789 format csv

[Immanuel Burton]

Thank you for your reply.

I'd tried that, but the version of GAM that I'm using doesn't accept a URL as a file identifier.

I have, however, devised a workaround.  What I did was to create a new Google Sheets file, and use an importrange formula to import the data from the tab in the original spreadsheet.  I can then use GAM to download the data from this new spreadsheet, and as this new spreadsheet has only one tab, there's no issue with making sure that I'm getting the right tab in my download.

[Kim Nilsson]

Yup, that'd work too. :-)

/Kim

--

There is No Substitute!

google.com/+KimNilsson