How to test a private Google sheets add on

user_4974732 0
Viewed 132

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

google-apps-script
1 Answers

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

user_56402000
Related