G
G
Grigory Boev2020-06-14 19:49:28
Google Apps Script
Grigory Boev, 2020-06-14 19:49:28

How to change the script attached to the Google spreadsheet from the outside?

Good afternoon. Recently there was a task - to upload a couple of dozen files of xslx / odt formats to Google Drive, convert them to Google spreadsheets, correct styles, insert several sheets according to the template and add a bunch of scripts to each.
If the first points were easily automated, then the last one could not solve it with a swoop. Made by hand. Although I spent a little time, the idea stuck in my head. mechanical work is not for me at all.

Actually the question is: how to add / change / get the text . gs script for an arbitrary table?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2020-06-15
@ProgrammerForever

This can be done through the Script API

  • Create https://developers.google.com/apps-script/api/ref...
  • Get content https://developers.google.com/apps-script/api/ref...
  • Rewrite https: //developers.google.com/apps-script/api/refe ...

There are a lot of subtleties that go into the development history of the service, so if you have nodejs in your environment, then I would recommend using the cli for Google Apps Script projects @google/clasp .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question