I want to replace the sheet name with gid number in Google Sheets.
=importrange("1anqeokmYsrtsdssdsx9QHOXqoVkgio254O8","Sheet1!K5:M5")
How can I replace the Sheet1! with its gid number?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI want to replace the sheet name with gid number in Google Sheets.
=importrange("1anqeokmYsrtsdssdsx9QHOXqoVkgio254O8","Sheet1!K5:M5")
How can I replace the Sheet1! with its gid number?
At this time, IMPORTRANGE doesn't use GID, only the sheet name.
If you want to use GID instead of using a built-in function, you should use a custom function, a script or an add-on.
For further details see