Deploy and use the Google Sheets Add-on in Google Apps Script

Question

I’m working on a Google Sheets add-in in Google Apps Script and want to know how I can deploy it and install it in a Google Sheets spreadsheet while it’s still in development (i.e. not ready for publication in the store).

At the moment, I am forced to create an add-in that is embedded in an existing table, without the possibility of using it in another.

Has anyone else done this?

Answer 1

Yes, it is possible, but you must first be approved by google for publication. After publication, you will specify publication only for google group and not public (this is a standard chrome storage function)

Answer 2

Go to Publish> Test as Add and Configure New Test. Testing your script will run the code in the document of your choice.

You should be able to take it from there. If you still have problems, read on.

To set up a test, you need to specify which document, form or table you want to run and save the test. Then you can run the test (from the “Test as Add” pop-up window by clicking the “Test” button after saving the test setup) and it will execute your code on this document / spreadsheet / form, opening a new tab with this document and executing your code .

To share the script with others (except that they use the same process for themselves, copying / pasting the script into their own script editor), you need to publish it in the online store; for this you need all this .

Hope this helps!

Answer 3

I tried to do the same, but could not. I just copied and pasted my code into a script manager for testing using different spreadsheets.

Sorry, but I think not.