How to create a table with gs script API enabled?

Question

I would like to manage spreadsheets (downloaded by the client via the API) through the Google engine. I created a test spreadsheet expanded with functions in a .gs script (which works fine if I add them through an online editor), but I don’t know how to apply such a .gs script to each downloaded spreadsheet automatically (possibly via the API).

In addition, I do not want to share this .gs file by publishing it as an extension (due to security policies).

Updated: I also tried to copy the existing table with working gs script and overwrite the data of my spreadsheets via the API (instead of loading a new one) - it overwrite the data successfully, but, unfortunately, lost the gs script. Details are described in a separate question (bounty): Google script user application does not work after copying a spreadsheet with google java client

Answer 1

So, I even tried to copy using simple HTTP methods, since I thought it might be a problem with the Java SDK, but it still does not work, which means that there is some kind of problem on google side (or something really obscure) service accounts.

.

script, , ( Google script google java ). script.

google oauth ( , https://developers.google.com/identity/protocols/OAuth2WebServer#overview) .

, , , script , .

, ;)

Answer 2

google script, Marketplace. Google, , google. google , . .

, Google , .

Answer 3

You can create a stand-alone script that is independent of any spreadsheet. This script will contain any methods / functions needed to create and manage spreadsheets according to your use case. Alternatively, you can deploy the script as a web application and implement the doGet () or doPost () method. Whenever a user downloads data from spreadsheets via the API, you can call up a web application with information and create spreadsheets if necessary.