How to test a private Google sheets add on

Question

I'm working on a Google Sheets add on. I have implemented some basic logic in https://script.google.com/ with Code.gs, index.html, appsscript.json. I deployed the project by clicking Deploy -> New Deployment. I have the deployment id. Then I open a SpreadSheet and click on Add-ons -> Get Add-ons. Basically, I don't see a way to test my private add-on by the deployment id. Are there any docs I'm missing?

question from:https://stackoverflow.com/questions/65867345/how-to-test-a-private-google-sheets-add-on

Answer 1

With the new editor, you can install an un-published add-on following these steps:

• Open the script project in the Apps Script editor.
• Click Deploy > Test deployments.
• Click Install.
• At the bottom, click Done.

Once installed, the add-on is immediately available in host applications it extends. You may need to refresh the host application tab before the add-on appears. You must also authorize the add-on before using it.

Documentation for new editor: https://developers.google.com/gsuite/add-ons/how-tos/testing-gsuite-addons#new-editor

Documentation for legacy editor: https://developers.google.com/gsuite/add-ons/how-tos/testing-gsuite-addons#legacy-editor