I have done my app script for test google sheet. Now I want to import this app script in another google sheet. I can copy all code to new app script, but it seems not a good way and a little stupid. Is there any better way?
Asked
Active
Viewed 58 times
1
-
Have you looked at building an add-on? – Amit Agarwal Oct 21 '21 at 05:27
-
Please provide enough code so others can better understand or reproduce the problem. – Community Oct 21 '21 at 08:47
1 Answers
0
You've got two options
- Build a library, this will allow you to easily integrate your code in any spreadsheet
- Build an add-on; this is slightly more complex, but will allow your users to use a UI to run your scripts without ever needing to use an editor. In your case it's probably best to use this option if you have a Workspace account, this way you can build a private add-on
Dmitry Kostyuk
- 1,354
- 1
- 5
- 21
-
I have some time trigger events, can I add these events to add-on? – CHIEN HSUN HUANG Oct 21 '21 at 08:16
-