Google Sheet Plugin error > (Test failed: cannot import name SignedJwtAssertionCredentials)

UserBird · July 2016

Hi,

I am trying to use the Google sheet plugin.

I have installed all the dependencies required in the DataScienceStudio/dss_home/bin folder

but I still have the same error:

Test failed: cannot import name SignedJwtAssertionCredentials

I googled the error and I install few more package:

$ pip install pycrypto

$ pip install pyopenssl

$ pip install httplib2

$ pip install oauth2client

$ pip install ssl

But it is still not working.

I would really much appreciate you help .

Thanks

----conf info---

Mac os El Capitan 10.11.5

jereze · July 2016

Hi,

Thanks for reporting this.

In the list you provided, we can see that oauth2client appears twice.

./bin/pip install --upgrade oauth2client==1.5.2

./bin/pip install --upgrade oauth2client

The second one is probably with the newest version, and there is known issue when oauth2client >= 2.0.0.

What I suggest:

Delete both (./bin/pip uninstall oauth2client oauth2client==1.5.2) and install again the 1.5.2 version (./bin/pip install oauth2client==1.5.2)
Or, there is a beta of a new version of the plugin available that works with oauth2client >= 2.0.0. You can download the zip here. Make sure you install again the dependencies in DSS administration after installation.

Let us know if that helps.

Jeremy

UserBird · July 2016

Thank you so much, Jermy!
It's working well now.
And also thank you for the new version, I was looking for how to write in a google sheet.

jereze · July 2016

You're welcome! Let me know if you have any issue with this beta.
Jeremy

Best Answer