Import Google Sheets API

Is it possible to import Google Sheets API into ignition and be used on the scripting platform? I would like to connect Ignition applications to Google Sheets.

https://developers.google.com/sheets/api/

You can import 3rd party python libraries into ignition. See “Importing 3rd Party Libraries” here.

However this page also says:

Ignition uses Python version 2.5. This means that any imported libraries must be compatible with Python 2.5

This page says that the Google Sheets API python client library requires python 2.7 or higher, so it wouldn’t be supported.

As an alternative, you could write your own global script package that uses the system.net.http* methods found here. Then you would use the Google Sheets REST API over HTTP. The docs are here.

1 Like