ESP-Google-Sheet-Client library gives errors

Development Libraries
1

I am trying to get the google sheet library to work but without succes. I have made the steps in GoogleCloud to activate Sheet API and Drive API, service account... Everything listed in the library readme.

Now when I try any example from the library on my TTGO ESP32, I get error -107 when OAuth2.0 is trying to connect.

What could be causing this? Is there too much data coming in and ESP cant handle it or something else? How could this be fixed?

....

Connected with IP: 192.168.1.111

Token info: type = OAuth2.0 access token, status = on initializing

Token info: type = OAuth2.0 access token, status = on signing

Token info: type = OAuth2.0 access token, status = error

Token error: code: -107, message:
Guru Meditation Error: Core  1 panic'ed (LoadProhibited). Exception was unhandled.

Core  1 register dump:
PC      : 0x40089947  PS      : 0x00060b30  A0      : 0x800d5f34  A1      : 0x3ffca940  
A2      : 0x00000010  A3      : 0xffff58e1  A4      : 0x0000a71e  A5      : 0x0000ff00  
A6      : 0x00ff0000  A7      : 0xff000000  A8      : 0xffffffff  A9      : 0x0000a71d  
A10     : 0x0000a71e  A11     : 0x0000a730  A12     : 0x3fff58d4  A13     : 0x0000a71e  
A14     : 0x00ff0000  A15     : 0xff000000  SAR     : 0x00000015  EXCCAUSE: 0x0000001c  
EXCVADDR: 0x0000a71d  LBEG    : 0x4008a621  LEND    : 0x4008a631  LCOUNT  : 0xffffd638  


Backtrace: 0x40089944:0x3ffca940 0x400d5f31:0x3ffca960 0x400d895b:0x3ffca980 0x400d8c07:0x3ffcaa30 0x400d8f53:0x3ffcaa50 0x400d8f7f:0x3ffcaa70 0x400d8f93:0x3ffcaa90 0x400d4c25:0x3ffcaab0 0x400d2ef9:0x3ffcaad0 0x400f1bf9:0x3ffcabf0




ELF file SHA256: 502ea2d025fa95f0
2

isn't that suppose to be google's ip??

good luck.. ~q

3

I got it working!!

Problem was that the Service account key was too short. I looked the key from the screen where I made the key, but it shows only a small part. The correct key was found in the .JSON file that was automatically downloaded when I created the key.

Now I can write data to sheets from ESP32!!

4

No. It is supposed to be the IP which the ESP32 was assigned from my WIFI router.

5

I have this exact same problem. I verified the info being provided is correct, from the json file. What else would be causing this problem? I was going to go into the gsheets.begin code to backtrack and maybe put in some debugging prints but I can't find it.

6

Have you followed the library instructions? I tried it many times until i got it working. My key was to take the service account key from .json file.

7

It would help if there was more detail to the error when and where it occurs. Which instructions are you referring to? Thanks for your time.

8

On the librarys github page is a very good instruction. Do exactly as it says.

1 Like
9

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.