How do I use installable event-driven triggers on a standalone Google Workspace add-on?-CodePudding

I'm making a Google Workspace add-on with Apps Script which creates a button that runs a function on any Google Sheet. This button should appear every time a Google Sheet is open.

I initially wrote the script as a bound-script, and it works fine using the simple trigger onOpen - but I need it to be available on EVERY Sheet for every user. So I created a new stand-alone script. According to the

CodePudding user response：

There is no way through the web user interface to create event-driven installable triggers in Google Apps Script. The way to do that is by using the Script Service

ScriptApp.newTrigger(functionName)
.forSpreadsheet(spreadsheet) // or .forDocument(document) etc.
.onOpen()
.create()

CodePudding user response：

Why don't you create it programatically instead? I think that way you may avoid any problem with the web UI.