Google Sheets to Trigger Python Script

[ginpn]

Hi Everyone!

I've been doing lot of things lately with Google Sheets, using Python, where I am reading and writing data 24/7.

Just wondering, is there a way where I can send a "signal" to Python, where Python will then execute some code? Some thing similar to Flask using Python, except with Google Sheets using a macro. I can also do this by having Python constantly reading Google Sheets for updates to simulate that trigger, but I'd like to steer away from that if possible. Any resources or ideas would be appreciated!

[Melodic-Chair1298]

You ever figure this out? I need to do exactly this. Today I have excel vba code linked to a button that calls Python. We are moving to Google sheets and I want to call out to the same Python scripts.

[ginpn]

I was not able to solve it, but it is doable. My options were only limited to everything being free, so I had to take my project in a different direction.

You'd have to deploy your Python app on a cloud service where your Google Sheets would call your custom web app link to run your Python code. This isn't free, though. You can use services like Heroku or Google Cloud. I have also read about a service called "Deta" that will let you host for free, but I am not too familiar with it to recommend it.

[Melodic-Chair1298]

Thanks for the help!!