I have a script running on a spreadsheet and was hoping to be able to push updates to that script with my continuous integration server. Is there currently an API for updating scripts programmatically?
Add a comment
|
3 Answers
No you cant update scripts inside spreadsheets. However if you make it a standalone script, you can update it with drive api (google it). If the script must for some reason be contained in the spreadsheet, then make that script a simple wrapper to the real script in a standalone library. Include the lib in 'development mode' and the spreadsheet will always use the latest library code.
2 Comments
Gunar Gessner
""Only the owner of the script can access this" AND any editor who has edit rights on the script too. This was not the case some time ago (I don't remember when it changed) but is the case now for sure." stackoverflow.com/questions/18543000/…
Fares Droubi
Here is a full startup project to fully automate Apps Script building and publishing using Travis CI: github.com/faresd/google-apps-script_travis-ci
The new Google add-ons for Google Sheets & Docs allow you to automatically update your scripts (add-ons, as they are now called).
2 Comments
JawsTheGame
Is it possible to distribute these add-ons without using the add-on store? This script isn't meant for public use necessarily.
Zig Mandel
not sure how this would help if what you want is to change its code programatically. With add-ons you stil need to manually modify the code and manually re-publish the add-on. Yes, the user gets the new code automatically but I believe thats not what he wants to accomplish.
From the question
Is there currently an API for updating scripts programmatically?
Yes, there is -> Google Apps Script API.
It worth to mention there is an open-source project managed by Google based on the API to use a terminal -> CLASP.