How to get spreadsheet that contains sheet id (gid)?

[soutot]

Hi,

I have 2 spreadsheets that looks like this: https://docs.google.com/spreadsheets/d/1234abcd/pub?gid=0&single=true&output=xlsx https://docs.google.com/spreadsheets/d/1234abcd/pub?gid=09876&single=true&output=xlsx

How do I specify which spreadsheet from id 1234abcd I want to work with? I couldn't find any property like "worksheet_id", neither I was able to use the gid querystring in "spreadsheedId" property.

Thanks in advance

[bassarisse]

Hey there,

You can use the worksheet option, passing the name or the index of the desired worksheet (-w or --worksheet in command-line).

[damianobarbati]

+1 for this feature: @bassarisse actually the "gid" is not working

const assets = await gsjson({
    spreadsheetId: '1WXQ4mmU0lKSIivxejPdrS7SHgxQCIxnJ8evVLWszuKs',
    worksheet: ['380908001'],
});      

Failure: Error: No worksheet found!

You did a great job with this repo!

[bassarisse]

Sorry if I didn't make myself clear. Matching the worksheet by the "gid" is currently not supported, ony by name or index.