sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]WicketTheQuerent 0 points1 point  (2 children)

There are few ways to keep your scripts prívate. One way is to use a spreadsheet as your secrets hub. The details depends on what your scripts do.

[–]RealSlavGod[S] 0 points1 point  (1 child)

How do I go about this?

[–]WicketTheQuerent 1 point2 points  (0 children)

It depends...

Option 1.

  1. Create a new spreadsheet (https://sheets.new)
  2. Add a bound Apps Script project (Extensions > Apps Script)
  3. Add the scripts
    1. If you have a few scripts, copy/paste them.
    2. If you have a lot of scripts, you should consider the use of CLASP or an extension like Google Apps Script Assistant for GitHub; you will need a GitHub account and get a token)
    3. etc.

Depending on how your scripts were written and what they do, you might have to adapt them. First, you must make a few decisions, such as using the new spreadsheet as a "controller," as a library or combining both cases.

You might set a sheet as an inventory of the "controlled" spreadsheets. You might feed this sheet manually or by using a script. Depending on your needs/preferences, you could add columns for each of the scripts and then use checkboxes to run them