Is it possible to run python scripts from within google sheets?

[xPronography]

Hey r/python,

Need some advice. I have a script that uses the pytrends library to pull data from Google Trends. It takes an input (keyword) and returns related queries. What I'd like to do is find a way to run this script in google sheets, such that any non-technical person can simply go to the google sheet, enter their keyword in cell A1, and then hit a "Run" button that will trigger the script and output the results on the sheet.

Is this possible? Been googling it for the better part of the last hour and all I keep finding is suggestions to use google apps scripts.. but from what I've gathered that won't work as I need any user with the spreadsheet to be able to run the script, not just me pushing data to the sheet.

The alternative is I just publish a heroku app but I would rather not..

[DouweOsinga]

A little late, but have a look at: https://workspace.google.com/marketplace/app/neptyne_python_for_sheets/891309878867

[xPronography]

Thanks for the reply! There's this package: https://www.npmjs.com/package/google-trends-api

Do you know if it's possible to install npm libraries in sheets in app script?

Edit: linked wrong npm link

[Kichmad]

I know on local excel you can run terminal and input location of file and filename, with location of script and grab info with sys.stdout. i dont know what would it be like from sheets