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

google-apps-script google-sheets google-workspace google-apps-script-addon
Rodrigo Pereira Fraga picture Rodrigo Pereira Fraga · Oct 29, 2014 · Viewed 16.1k times · Source

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?

Answer

Rodrigo Pereira Fraga picture Rodrigo Pereira Fraga · Oct 31, 2014

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

Related questions

How to get the correct range to set the value to a cell?

I want to set text or number in Google Sheet from script. I want to set Hello or number 9 in cell F2. I found this code so far: SpreadsheetApp.getActiveRange().setValue('hello'); but that doesn't specify which cell.

Read More
How do you add UI inside cells in a google spreadsheet using app script?

I'd like to add buttons to specific cells in Google docs spreadsheet. The apps script UI documentation talks about how to add a new panel, but it's not clear how UI in that panel could be attached to specific rows …

Read More
Sheet.getRange(1,1,1,12) what does the numbers in bracket specify?

Sheet.getRange(1,1,1,12) I cannot understand the arguments 1,1,1,12 . What is this - the sheet id or row or what? method getRange(row, column, optNumRows, optNumColumns) here what does optNumRows and optNumColumns mean???

Read More