Why the error pops up: You are not allowed to call the user SpreadsheetApp.openById. Required permissions..?

Question

Google Sheets

Good afternoon. I write scripts for tables. Everything works well if the functions are run from the newly created menu at the top:

function onOpen(){
  var spreadsheet = SpreadsheetApp.getActive();
  var menuItems = [
    { name: 'Обновить', functionName: 'Refresh' },
    { name: 'Обновить (интервал 5 сек.)', functionName: 'Refresh5sec' },
    { name: 'Тест (не нажимать)', functionName: 'getSecondary' },
  ];
  spreadsheet.addMenu( 'СКРИПТЫ', menuItems );
}

But if you use a cell editing trigger and run a function from it, then an error pops up in the console:

function onEdit( e ){
  var range = e.range;
  if( range.getA1Notation() == 'F3' ){
    getSecondary();
  }
}

Mistake:

Скрипт Google Apps: Exception: Вам не разрешено вызывать пользователя SpreadsheetApp.openById. Необходимые разрешения: https://www.googleapis.com/auth/spreadsheets.

Moreover, when I first called the function through the menu, I got a window where Google asked me to grant permissions, which I did. And after that, the functions, through the menu, began to work perfectly. But why doesn't it work when editing a cell? Despite the fact that I already gave the same rights.

Answer 1

The option of creating an installable (full-fledged, uneasy) trigger for editing helped and slightly changed the name of the function so that it does not conflict with the trigger attached to this function (onEdit)

function onEditInstall( e ){
  var range = e.range;
  if( range.getA1Notation() == 'F3' ){
    getSecondary();
  }
}

Thanks to Oleg and Alexander Ivanov for the hint