CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
user1464409
user1464409

Reputation: 1042

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

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?

Upvotes: 4

Views: 3132

Answers (2)

Serge insas
Serge insas

Reputation: 46802

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.

Upvotes: 4

Pete
Pete

Reputation: 1

See this page for how to create and share functions in your sheets using Google Apps Scripts. The scripts are written in javascript and there are some limitations on how they can be used.

https://developers.google.com/apps-script/guide_writing_scripts#CustomFunctions

Upvotes: 0

Related Questions