How to get sheet id from a spreadsheet

Help Activities
, ,
1

Hello,

I need to retrieve the unique sheet ids of each sheet present in a spread sheet.
For example this : 1SiwX3hApM_SB-jUIXE6_-pfykNVvA_9UT3ONwR04Vo4/edit#gid=430182552

The spreadsheet is dynamically created in the code and it has multiple sheets.
The aim is to retrieve the ids of each sheet of the spreadsheet in a variable.

Any help would be appreciated on this topic.

Thanks,
Yogendra

2

Hi @yogendra.kulkarni

Hope this link is helpful

3

Hi Aditya,

Thanks for your quick response.

Actually I do not need sheet names I am using google sheets so I need the sheet id to be retrieved.
I was able to get the sheet names before.

4

Hi @yogendra.kulkarni

Did u tried this

Regards

Nived N :robot:

6

Hi Yogendra , I am also facing the same problem .To retrieve dynamic GSheet ids . Did you get the solution to retrieve dynamic GSheet ids

7

Hi Dutta,

For a sheet that you create in studio I could not find so I used the sheet Name as indicator for the user.

But for the sheet is already created before you can use the link https://docs.google.com/spreadsheets/d/ID/edit#gid=GID
in which you can replace ID by spreadsheetid and GID by already created sheetid

Thanks