How to pull comments from another Google Sheets?

Question

Google Apps Script

The task is to pull notes from another table. I don't know how to do it. Could you explain?
Inside one table code:

function getNotes(sheetName, rangeName){
  return SpreadsheetApp.getActiveSpreadsheet()
    .getSheetByName(sheetName).getRange(rangeName).getNotes()
}

(in the table itself) =getNotes("***";"***")works with a bang. But what about notes from another table? ((
I tried SpreadsheetApp.getActiveSpreadsheetto replace it with SpreadsheetApp.openById, but it doesn’t work like that.

Answer 1

Judging by the comments, an error is returned

Exception: You do not have permission to call SpreadsheetApp.openById. Required permissions: https://www.googleapis.com/auth/spreadsheets

This means that the function is run as a user-defined function. These functions cannot read adjacent Tables. For this, other approaches must be used.