2

I have several google spreadsheets in my account. I would like to create a library to be shared by all the spreadsheets in my account. Currently, the library I created can only be shared by the worksheets in a single spreadsheet. I would like to keep my library private and accessible only by the spreadsheet in my account because it is still not good enough to be shared to the public. May I know if this can be done?

John Conde
  • 217,595
  • 99
  • 455
  • 496
guagay_wk
  • 26,337
  • 54
  • 186
  • 295
  • See also: http://stackoverflow.com/questions/14473368/google-spreadsheet-scripts-shared-across-spreadsheets-not-libraries – Brad Feb 08 '13 at 22:11

1 Answers1

4

Yes, you can use the (relatively) new library functionality, and keep it private to just your domain (you are using google apps, right?)

Functionality is pretty good, including auto-complete for your functions, auto-generation of documentation, versioning, etc...

Here are a few links

Google Blog Acticle

Documentation

Hope this is what you were looking for...

mgmonteleone
  • 400
  • 1
  • 9
  • I tried to create a shared library without a domain (i.e., personal Google account, not GSuite/Workspace), but unfortunately it doesn't appear to work as expected. From what I've observed, you can only use a Sheets library in a personal account if this account is _not_ the same account you used to create the library. More info on the issue here: https://stackoverflow.com/q/67898285/452587 – thdoan Jun 13 '21 at 00:16