Is there any way to use python function in Google App Script?

Question

If I have a python script, for example:

def hello():
    return 'Hello World'

How can I call this python script in Google App Script? Or how can I create a custom function for spreadsheet which return this python function? Something like:

function callPythonFunction() {
  const result = //hello function from python script
  return result; // 'Hello World' from hello()
}

And if I use this in spreadsheet:

=callPythonFunction()

I get 'Hello World' in the cell.

You might be able to do this using an alternate runtime. This feature is probably still in beta but you can check it out at the following link: developers.google.com/workspace/add-ons/guides/… — TheAddonDepot
– TheAddonDepot, Commented Mar 16, 2021 at 17:49

NightEye · Accepted Answer · 2021-03-16 14:30:30Z

1

I think there is no another way other than running the python app in a 3rd party service and then call it from GAS using UrlFetch() (I've seen someone do this but not tried it entirely), or using Google's API in python or gspread if you want to have access onto spreadsheets.

answered Mar 16, 2021 at 14:30

NightEye

11.3k2 gold badges8 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

Is there any way to use python function in Google App Script?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related