How can I share my app script, between google spreadsheets?

Question

I have a corporate google account (with a domain) and I've created a script to access a database, to share data between some spreadsheets to make simulations.

I created some custom functions like =listAllCustomers() and now I want to use with any spreadsheets.

How can I do that?

In a sheet, I can add custom code via "Add On", but how can I share scripts in my domain?

Solution

OK, I found the answer. With the new google approach, all scripts are managed as scripts, so to share a script, even in a private domain, you need to publish on the "add-on store".

I just follow these steps and in a few days I solved my need. https://developers.google.com/apps-script/add-ons/publish

Comments

[Scott Solmer]

Sharing your research helps everyone. Tell us what you've tried and why it didn’t meet your needs. This demonstrates that you’ve taken the time to try to help yourself, it saves us from reiterating obvious answers, and most of all it helps you get a more specific and relevant answer! Also see how to ask

[Henrique G. Abreu]

I'll not post this as an answer since I'm not sure. But I think you'll have to deploy this as an Add-on visible only to your domain (if this my-domain-only feature is not available it'll probably be in the future). Then, as the domain admin, force install/enable this add-on for your domain sheets. But the crude solution we had before add-ons was to simply copy this script inside every Sheet you needed it. Or have a template sheet that people copy from to generate new sheets.

[Mogsdad]

possible duplicate of Google Spreadsheet Scripts shared across spreadsheets (not libraries)

[Rodrigo Pereira Fraga]

@HenriqueAbreu "Add-on visible only to your domain (if this my-domain-only feature is not available it'll probably be in the future)" I've tried that, but after publishing, I can not see in the "Add on Store", even filtering by my domain. Actually, I don't know where is this published. Via admin panel, I can only publish "App Engine Apps".

[Rodrigo Pereira Fraga]

@Mogsdad The solution there (one year ago) doesn't work for me, because of my limitation of creating templates...

[espinchi]

Emphasis on "in a few days". I've done that too, and it was a surprisingly painful process

[tofutim]

this seems insane, are you able to keep the script private and then make updates?