3

I'm working on a Google Sheets add-on in Google Apps Script and want to know how I can deploy it and install it into a Google Sheets spreadsheet whilst it is still in development (i.e. not ready to publish in the Store).

At the moment I'm forced to create my add-on embedded within an existing spreadsheet with no option of using it in another.

Has anyone achieved this yet?

Rubén
  • 34,714
  • 9
  • 70
  • 166
Tony Day
  • 2,170
  • 19
  • 25

3 Answers3

2

Go to Publish>Test as Add On and Configure a New Test. Testing your script will run the code on a doc of your choosing.

You should be able to take it from there. If you're still having trouble, read on.

To setup the test, you'll need to specify which Document, Form, or Spreadsheet you want to it to run on, and save the test. Then you can run the test (from the Test as Add On popup, by clicking the Test button after you've saved your test setup) and it will execute your code on that document/spreadsheet/form by opening a new tab with that doc and executing your code.

To share the script with others (beyond making them use this same process for themselves by copy/pasting your script in their own Script Editor) you'll need to publish it to the Web Store; to do that you need to do all this stuff.

Hope that helps!

jeffmjack
  • 572
  • 4
  • 14
  • At this time (Nov 2017) the "Test as add-on" command is found under the "Run" menu, not the "Publish" menu. – Giuseppe Nov 29 '17 at 15:26
1

I tried to do the same thing but was not able to. I just copied and pasted my code into the script manager to test with different spreadsheets.

Sorry, but I guess not.

Kevin Michael
  • 118
  • 1
  • 7
  • Yeah, I did the same, but this seems rather clunky and silly to me. Will wait and see if anyone comes up with a solution or at least knows when this functionality may be available. – Tony Day Mar 27 '14 at 09:05
  • That's how we did and still do it. 3 weeks on we are still waiting for Google to approve (or acknowledge) our publishing requests. (http://stackoverflow.com/questions/22563982/google-app-script-add-on-approved-for-publishing) – bleeper Apr 07 '14 at 09:48
1

Yes its posible but first you need to be approved by google to publish. Once you can publish you specify to publish only to a google group and not public (this is standard chrome store functionality)

Zig Mandel
  • 19,571
  • 5
  • 26
  • 36
  • Thank you for this. I didn´t realise that publishing to the store gave you the option to keep it private to a group. I knew there had to be a way! – Tony Day Mar 29 '14 at 09:17