google-apps-scripttestinggoogle-workspaceadd-on

How to test a private Google sheets add on


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?

enter image description here


Solution

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

    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