Call a Google Sheets add-on by Google App Script

In my spreadsheet, I have an add-on that I would like to activate it once a day, in the add-on there is the option to activate every 3600 seconds (1 hour), the problem is that only 500 calls per month are allowed.

So I would like to know if there is any way to create a trigger every 1 day through Google App Script

https://docs.google.com/spreadsheets/d/1DrxDJEogFzX6vvMezawTClwE8v9CK36RdoB2X5VZRco/edit?usp=sharing

1 answer

  • answered 2019-09-15 20:46 Cooper

    You can create a time based trigger from the Script Apps Editor or via script using scriptApp.newTrigger()