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?
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
- How can I use Google Sheets Apps Script to Auto Generate today's date when an edit is made to a given column?
- An explicit urlFetchWhitelist is required for all Google Workspace add-ons using UrlFetchApp error while deploying sheet add on
- how to show instruction with image after install google workspace extension
- Regular expression to extract valid cell references from a spreadsheet formula
- My Google Apps script regex requires a match for either one expression or another.
- If checkbox checked set values
- Clarification on using the forEach() function
- Rank based on which column is being sorted by in a Table
- Auto border to a Dynamic Data
- How can I determine if a respondent's email address is unique in a list?
- Sum a number of range values; process and add to array
- Fill Google Form from Other Google Form Responses
- Downloading a PDF version of the open spreadsheet in Google Drive via scripts
- exporting spreadsheet to pdf then saving the file in google drive
- Convert a Markdown text file into a Google Document
- A Script to Simplify Creating a SO Table
- Archive a row after a dropdown status is selected on multiple sheets
- Get Google Sheet by ID?
- Google Sheets macro to copy a line of data to next empty row on another sheet
- Error 'Action Not Allowed' When Copying Content with a Vertical Line in Google Docs
- Remove an attachment of a Gmail email with Google Apps Script
- Google Apps Script switching html files
- How to make a simple authentication in Google Forms using Google apps script?
- Can a google-apps-script be written to download a csv file from spreadsheet directly to a local hard drive with an onEdit trigger?
- API call to directory.members.insert failed with error: Resource Not Found: groupKey
- Clone Folder/Files From Another Account With Apps Script
- Apps Script Delete Image
- DO NOT send notifications when share a file
- App Script to download specific cells in Google Sheet to PDF
- Export Google Docs comments into Google Sheets, along with highlighted text?