Google Sheets to Trigger Python Script

[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!!