I’m building a public spreadsheet apps script editor add-on. When I create a new trigger in the spreadsheet-bound apps script I can select the “from spreadsheet” event source:
(from spreadsheet)
But then when I publish my apps script as an internal organization add-on, and try to add the same trigger, then the only options i see are “from calendar” and “time-driven”:
(no from spreadsheet)
Even though i clearly defined my app as a spreadsheet add-on.
Why can’t I set a “from spreadsheet” trigger?