Retrieving Spreadsheet ID from Range using Google Apps Script · GitHub

PHOTO EMBED

Thu Jan 20 2022 08:37:58 GMT+0000 (Coordinated Universal Time)

Saved by @phat

var id = "123456789abcdefg";
var sheet = "Sheet";
var cells = "a1:b10";
var range = SpreadsheetApp.openById(id).getSheetByName(sheet).getRange(cells);

var id = range.getSheet().getParent().getId();

>>> id ---> 123456789abcdefg
content_copyCOPY

https://gist.github.com/tanaikech/d71eaa978d26f649bb1a25c67d279e43