GSheet is "loading..." - previously worked

General
1

For a very long time I have had no issues with Node-RED and the gSheet plugin and today I decided to add some more cells to the look-up and place it into HomeAssistant (that's where everything else goes).
Out of the blue cell look-ups that had previously been working without any issue decided to give a random number (that wasn't correct) and now it simply says "Loading..." when I attach a debug node to it.

image
image332Ă—860 46.3 KB

Keep in mind this part of the spreadsheet has been untouched and the nodered flow has also been untouched. I have checked and verified several times that the felids are correct and correlate together.

2

@phoniclynx welcome to the forum.

Searching the nodes library with gSheets returns two nodes:

  1.   node-red-google-sheets-advance (last updated almost 3 years ago) and

  2.   node-red-contrib-google-sheets-advance (last updated a little over 5 months ago)

but since you didn't give the complete name of the node people will just be guessing if one of them is what you use.

If you are running NR on HomeAssistant, you should open an issue on their forum. There aren't many people on this forum that use HomeAssistant.

3

Sorry, I didn't realise there was more than one

node-red-contrib-google-sheets

is the one that I am using

4

try restarting Node-RED.

If you cannot get this going, then perhaps raise an issue on its repository: Issues · sammachin/node-red-contrib-google-sheets · GitHub

5

I installed the advanced one and it gave me the same result

6

Opened an issue here: Unable to read cell from gsheet's cell · Issue #28 · sammachin/node-red-contrib-google-sheets · GitHub

7

That suggests it is an issue with connectivity or google rather than node-red. Open the browser developer tools and see if there are any errors shown there.

1 Like