# Google Sheets odd append behavior

**URL:** <https://discourse.nodered.org/t/google-sheets-odd-append-behavior/74388>\
**Category:** General\
**Created:** [30 January 2023 05:46 UTC](https://discourse.nodered.org/t/google-sheets-odd-append-behavior/74388 "2023-01-30T05:46:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![raisingskell](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/raisingskell/32/75233_2.png) [@raisingskell](https://discourse.nodered.org/u/raisingskell)\
**Post date:** [30 January 2023 05:46 UTC](https://discourse.nodered.org/t/google-sheets-odd-append-behavior/74388/1 "2023-01-30T05:46:37Z")

</div>

I'm appending time in Col A and temp in Col B to Sheet1. Pretty simple and all works perfectly. Here's what appears to me to be odd behavior.

Since Sheet1 simply collects data I use Sheet2 to process it.

So in Sheet2 A1 I use =Sheet1!A1 then =Sheet1!A2, =Sheet1!A3, etc down the column. New values are appended perfectly in Sheet1 but when they are, they force the next open row on Sheet2 to change the formula so instead I get =Sheet1!A1 then =Sheet1!A2, _=Sheet1!A4_. It eliminates =Sheet1!A3 and replaces it with =Sheet1!A4 and therefore nothing is updated in Sheet2.

So I must have something set up incorrectly with either the Google Sheets Node or the spreadsheet but I'm at a loss to understand what it is. I've never seen this behavior before using append.

Thoughts appreciated.

I'm using node-red-contrib-google-sheets v1.1.2, method = append row and cells = Sheet1!A1:B1

---

<div class="post-metadata">

**Author:** ![PdeJ](https://avatars.discourse-cdn.com/v4/letter/p/c89c15/32.png) [@PdeJ](https://discourse.nodered.org/u/PdeJ)\
**Post date:** [31 January 2023 12:15 UTC](https://discourse.nodered.org/t/google-sheets-odd-append-behavior/74388/2 "2023-01-31T12:15:15Z")

</div>

I am not familiar with the Google Sheets Node, but if you can't resolve your issue I suggest you use a Google Form to register your data to a Google Sheet via an HTTP Request Node. It is the standard way that I send data to Google Sheets from Node Red. For more information you can see [my project notes](https://sites.google.com/view/pdej/ha-pircam/google-sheets).

---

<div class="post-metadata">

**Author:** ![raisingskell](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/raisingskell/32/75233_2.png) [@raisingskell](https://discourse.nodered.org/u/raisingskell)\
**Post date:** [31 January 2023 16:44 UTC](https://discourse.nodered.org/t/google-sheets-odd-append-behavior/74388/3 "2023-01-31T16:44:23Z")

</div>

Thanks for the tip. I'll check it out.

---

<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:** [1 April 2023 16:44 UTC](https://discourse.nodered.org/t/google-sheets-odd-append-behavior/74388/4 "2023-04-01T16:44:49Z")

</div>

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