0

Is it true that it is not possible to directly connect a Google Apps Script (which uses JavaScript) to a Google Sheets spreadsheet using Python?

I am asking this more as a design question: would it not be possible to keep a Google Apps Script in a file and simply use Python to connect it to a gsheets spreadsheet using the spreadsheet id? I have not found a way to do this, but it would be interesting to hear if anyone has found a way to do it and if so how.

user4933
  • 1,485
  • 3
  • 24
  • 42
  • I thought that in your situation, these threads might be useful. https://stackoverflow.com/q/67754300 and https://stackoverflow.com/q/61484573 and https://stackoverflow.com/a/60941309 – Tanaike Jan 07 '23 at 00:36

2 Answers2

1

I am not sure if this answer is on topic, but I think it might be what you trying to do... That is, push an apps script file up to Google...

I believe you can accomplish this task via the Apps Script Python API:

https://developers.google.com/apps-script/api/quickstart/python

My company does not give the the creds to use the API, so, I can't give you the step by step on this one...

hth,

David

user3220745
  • 63
  • 6
1

To be fair, I really don't think this is the right approach. Might depend on what you're doing... If you have a Python script that is writing Google Apps Script and needs to push it to Google, you might look in these docs

https://developers.google.com/apps-script/api/reference/rest

If that's not what you're doing and you're trying to manipulate a Spreadsheet by using Python to run some Google Apps Script, refer to the same link. There is "REST Resource: v1.scripts" which has a "run" method.

Last, if your end goal is to manipulate some Google Sheet--you can probably get away with using a Python library like described in this link

https://developers.google.com/sheets/api/quickstart/python

Because just about anything you can use Google Apps Script for, you can technically also do in Python. Except, with Python you have Python and the entire compendium of Python libraries at your disposal. The Google Sheet is ultimately just a data store and reading and writing to it are the things you're trying to do with it--be it Google Apps Script or Python as the driver.

Otherwise, you might be able to use Python to manipulate CLASP

https://github.com/google/clasp

Sero
  • 161
  • 8