CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
Srik
Srik

Reputation: 7957

'Install' a private Apps Script

In a Google Spreadsheet, you can go to Tools --> Script Gallery and then 'install' any of the public scripts from the gallery.

Is it possible to similarly 'install' a script that is not part of the Script Gallery. Or should I be filing an enhancement request for the same ?

The problem at hand is a similar script is required across multiple spreadsheets. One option is to make use of libraries, but that will again require writing or atleast copy-pasting the skeleton code that uses the library in each of the spreadsheet.

Upvotes: 1

Views: 2349

Answers (2)

Romain Vialard
Romain Vialard

Reputation: 396

Yes you should fill an enhancement request on the issue tracker (and I'll be happy to stare it).

For now on, if you don't want to share your script publicly but you need an easy install for your users (they should see no code), you can:

  • create a spreadsheet template in the Google Docs template gallery
  • create a Chrome Web App and share it with a specific group
  • put your script in a Google Sites and add a UI to let the user choose on which spreadsheet the script should be triggered.

Upvotes: 3

Guy
Guy

Reputation: 12891

You can easily install your private library by using its ID

You can find the ID of your library under Tools-Script Editor->File->Project Properties->Info->Project Key

Upvotes: 0

Related Questions