Skip to content Skip to sidebar Skip to footer

Can You Use Google Apps Script With Python?

Google Apps Script looks to be pretty perfect for a school project, however I'm not terribly comfortable with JavaScript and the entire rest of the project is going to be done in P

Solution 1:

No, Google Apps Script is its own programming language. There are a number of APIs for individual Google Apps, but they are not as comprehensive as what is provided via Google Apps Script. They're generally focused on providing access to the data, and might be suitable if you don't need to edit it.

Solution 2:

It is now possible to make requests to Google Apps Script from Python via the new Execution API, which uses a REST interface. Related blog post announcement. Learning some JS is still required.

Solution 3:

Python is amazing, and one of its most amazing qualities is being able to serve as a "glue" of sorts between different modules of a system (regardless of language).

My suggestion is to try and make an Adapter/Wrapper around the Javascript commands you will need from Google App Script, exposing pure python functions to the rest of your program so it makes it easier on you. In the end, you will still require to learn some Javascript so... get going.

Solution 4:

Never tried this but maybe you can use JSON (javascript object notation)

In the Utilities class of Google apps script you can find the some methods (classes) that refer to this notation. jsonParse and jsonStringifyhttps://developers.google.com/apps-script/class_utilities

And on the other hand python has a json encoder and decoder to do the same thing on that side. http://docs.python.org/library/json.html

There are also two tutorials which refer to these json methods for Google Apps Script developers.google.com apps-script articles picasa_google_apis (being a newby I am not allowed to put full links)

And this as a background link json.org

Than the last thing to avoid great frustrations... check out if one of these issues might be on your way to heaven.

  • Issue 1397
  • Issue 470
  • Issue 220
  • Issue 445

Solution 5:

Google Apps Scripts uses Javascript only to manipulate classes of Google products and some more general classes for doing things outside Google. Javascript is the only language.

Post a Comment for "Can You Use Google Apps Script With Python?"