How should I reuse functions on a number of different Google Spreadsheets?

Question

I have now written a number of different functions in Google Apps Script that I am using on a growing number of Google Spreadsheets.

Every time I make a small edit to one of these functions I then have to go into each spreadsheet and make the same correction.

Is there a way to "import" the functions to each spreadsheet so that I only have to edit the one "master" function and it is then updated on every spreadsheet?

Serge insas Serge insas · Accepted Answer · 2012-06-24T12:03:55

Google has just release a new feature called Libraries, it is an elegant way to do what you're asking for. Here is the documentation, read it attentively because it's a multi-step process.

How should I reuse functions on a number of different Google Spreadsheets?

2 Answers