I have several Google Sheets with relatively complex GAS scripts attached – so far I’ve been developing new functionality using copies and github for VC, but I’m wondering if there’s a better way to do this using the in-built deployments/versioning with container-bound scripts?
I’d like to be able to work on HEAD developing new features while users are still on the last ‘stable’ version of the script
Should I move the bound scripts to standalone libraries that can be imported in particular sheets?
Would this have any performance issues?
The docs say that bound scripts have ‘special privileges’ over the parent document – does anyone know what these are?
Thanks for any help!
I’ve tried the following solutions but non work perfectly
-
deploying as an add-on which I thought would be the solution
- first you had to change GCP project/authentication
- it’s not clear to me if this would be then made public automatically – which I can’t have as the scripts are internal only
-
deploying the bound script as a library
- this gives access to versioned deployments but no ability to develop on HEAD while users have access to the last deployment
-
deploying as a standalone library
- not sure what ‘special privileges’ I’d be missing out on in the parent file