Google Sheets App Script permissions limiting

Question

Limited permission to SpreadsheetApp without requiring "Untitled project needs your permission to access your data on Google." I know with the new Macros there is a special permission only for the spreadsheets the Macro is installed on, and with onEdit no permissions are needed due to limiting the scope to only the spreadsheet. Is there any object or method I can use to avoid needing this overreaching permission to simply edit the spreadsheet with say a script connected to an image, or am I stuck with shoving everything in onEdit.

Answer 1

You can define explicit scopes in your manifest file. Google explains how to set explicit scopes here.

You can view the full list of available scopes here and some specifics around add-on scopes here.

Specifically, it's worth calling out the spreadsheets.currentonly scope as it's not clearly listed as an available scope.

{
  ...
  "oauthScopes": [
    "https://www.googleapis.com/auth/spreadsheets.currentonly"
  ],
  ...
}