# GSheet is "loading..." - previously worked

**URL:** <https://discourse.nodered.org/t/gsheet-is-loading-previously-worked/90579>\
**Category:** General\
**Tags:** home-assistant\
**Created:** [31 August 2024 08:08 UTC](https://discourse.nodered.org/t/gsheet-is-loading-previously-worked/90579 "2024-08-31T08:08:56Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![phoniclynx](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/phoniclynx/32/94091_2.png) [@phoniclynx](https://discourse.nodered.org/u/phoniclynx)\
**Post date:** [31 August 2024 08:08 UTC](https://discourse.nodered.org/t/gsheet-is-loading-previously-worked/90579/1 "2024-08-31T08:08:56Z")

</div>

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](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/1/41397228ec603913b4fc95379cc4a4d69d28f1dc.png)

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.

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [31 August 2024 10:18 UTC](https://discourse.nodered.org/t/gsheet-is-loading-previously-worked/90579/2 "2024-08-31T10:18:07Z")

</div>

@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.

---

<div class="post-metadata">

**Author:** ![phoniclynx](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/phoniclynx/32/94091_2.png) [@phoniclynx](https://discourse.nodered.org/u/phoniclynx)\
**Post date:** [31 August 2024 10:31 UTC](https://discourse.nodered.org/t/gsheet-is-loading-previously-worked/90579/3 "2024-08-31T10:31:03Z")

</div>

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

```auto
node-red-contrib-google-sheets

```

is the one that I am using

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [31 August 2024 10:36 UTC](https://discourse.nodered.org/t/gsheet-is-loading-previously-worked/90579/4 "2024-08-31T10:36:48Z")

</div>

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](https://github.com/sammachin/node-red-contrib-google-sheets/issues)

---

<div class="post-metadata">

**Author:** ![phoniclynx](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/phoniclynx/32/94091_2.png) [@phoniclynx](https://discourse.nodered.org/u/phoniclynx)\
**Post date:** [31 August 2024 10:39 UTC](https://discourse.nodered.org/t/gsheet-is-loading-previously-worked/90579/5 "2024-08-31T10:39:57Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![phoniclynx](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/phoniclynx/32/94091_2.png) [@phoniclynx](https://discourse.nodered.org/u/phoniclynx)\
**Post date:** [31 August 2024 13:26 UTC](https://discourse.nodered.org/t/gsheet-is-loading-previously-worked/90579/6 "2024-08-31T13:26:05Z")

</div>

Opened an issue here: [Unable to read cell from gsheet's cell · Issue #28 · sammachin/node-red-contrib-google-sheets · GitHub](https://github.com/sammachin/node-red-contrib-google-sheets/issues/28)

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [31 August 2024 14:22 UTC](https://discourse.nodered.org/t/gsheet-is-loading-previously-worked/90579/7 "2024-08-31T14:22:53Z")

</div>

> [@phoniclynx](#):
>
> I installed the advanced one and it gave me the same result

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.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [29 November 2024 14:23 UTC](https://discourse.nodered.org/t/gsheet-is-loading-previously-worked/90579/8 "2024-11-29T14:23:23Z")

</div>

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