Replace sheet name with gid number in Google Sheets

Question

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?

Answer 1

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

• Extend Google Docs, Sheets, and Forms with Apps Script
• Install, use & uninstall add-ons