I’m developing a Google Sheets add-on using the new Workspace add-on framework. The add-on integrates with a third-party task management system, allowing users to sync their tasks directly into a spreadsheet. I have a few questions about the development process:
-
Should this be developed as a container-bound add-on or as a standalone add-on?
-
If I make it container-bound, does that mean the users will have to have access to the original file and all operations will happen in the same Sheets file?
-
What’s the best method for having test users from external domains test an earlier version of the add-on before the official release?
Additional context:
-
The add-on uses OAuth integration for secure connection to the third-party service
-
The add-on will create new sheets named after the synced items and populate them with selected data.
I’m looking for best practices in terms of development, testing, architecture, and distribution. Any insights or recommendations would be greatly appreciated!
I have tried sharing the app script project, but they get the error when attempting to Deploy the addon: “Something went wrong. Please reload the page to try again.”