Reputation:
We have a google sheets script that will check a list against a company blacklist. It works great in testing, and we've decided to deploy it for our organization. I followed this guide, which got me 90% of the way through.
However, after deploying the add-on, it is installed but not enabled for users. They must manually navigate to the store page and check "enable in this document" for every single sheet they want it to work in.
Has anyone ever experienced this? I talked to Google support but they didn't know why it would behave that way.
Upvotes: 1
Views: 44
Reputation:
Turns out it was a permissions error. Add-ons start installed but not enabled until you click on a menu item. I needed to use a different method of adding menu items so that the add-on could request authorization. This help article proved invaluable.
Upvotes: 1