Running python script from Google Apps script

Question

I have a python script (on my local machine) that queries Postgres database and updates a Google sheet via sheets API. I want the python script to run on opening the sheet. I am aware of Google Apps Script, but not quite sure how can I use it, to achieve what I want.

Thanks

Wicket · Accepted Answer · 2017-02-14 17:27:21Z

3

Google Apps Script runs on the server side, so it can't be used to run a local script.

answered Feb 14, 2017 at 17:27

Wicket

39.4k9 gold badges81 silver badges201 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Zig Mandel · Accepted Answer · 2017-02-19 12:48:30Z

2

you will need several changes. first you need to move the script to the cloud (see google compute engine) and be able to access your databases from there.

then, from apps script look at the onOpen trigger. from there you can urlFetchApp to your python server to start the work.

you could also add a custom "refresh" menu to the sheet to call your server which is nicer than having to reload the sheet.

note that onOpen runs server side on google thus its impossible for it to access your local machine files.

answered Feb 19, 2017 at 12:48

Zig Mandel

19.9k5 gold badges32 silver badges39 bronze badges

Collectives™ on Stack Overflow

Running python script from Google Apps script

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related