On Change trigger

[fl]

Why does installable onChange trigger require access to ALL spreadsheets? I have a project set up and running that needs access only to the current spreadsheet via appscript.json and /** @OnlyCurrentDoc*/ - but adding an onChange trigger requires access to all spreadsheets in the account. How to add for current if possible?

[George Ghanem]

That is the way Google approves scripts to run. Once the script is approved, someone can change the spreadsheet ID and access some other spreadsheet that you own and no other approvals would be needed.

The text of the approvals is alarming, I know.. but if you know who wrote the code and who has edit access to it and trust them, then it should not worry you.

On Thu, Apr 10, 2025, 1:59 p.m. fl <fl.ste...@gmail.com> wrote:

Why does installable onChange trigger require access to ALL spreadsheets? I have a project set up and running that needs access only to the current spreadsheet via appscript.json and /** @OnlyCurrentDoc*/ - but adding an onChange trigger requires access to all spreadsheets in the account. How to add for current if possible?

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/0dc16480-818a-4334-a5b4-c5edf2f2030fn%40googlegroups.com.