# Insert data into Gsheet in same row with new timestamp

**URL:** https://discourse.nodered.org/t/insert-data-into-gsheet-in-same-row-with-new-timestamp/65275
**Category:** General
**Created:** [18 July 2022 16:13 UTC](https://discourse.nodered.org/t/insert-data-into-gsheet-in-same-row-with-new-timestamp/65275 "2022-07-18T16:13:33Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![1onkar](https://avatars.discourse-cdn.com/v4/letter/1/ba9def/32.png) [@1onkar](https://discourse.nodered.org/u/1onkar)
#### Post date: [18 July 2022 16:13 UTC](https://discourse.nodered.org/t/insert-data-into-gsheet-in-same-row-with-new-timestamp/65275/1 "2022-07-18T16:13:34Z")

</div>

Hi..  
I need help to Insert data into Google sheet from Nodered. I followed this YouTube video [Insert Data to Google Sheet Autoatic with Node Red [บันทึกข้อมูลลง Google Sheet ด้วย Node Red] - YouTube](https://www.youtube.com/watch?v=GKZ9Ro_3-ik) . It works , rather than creating a new row each time, I want to keep update only one row every time with new timestamp and new values. Please advise, thanks in advance for helping me out.

---

<div class="post-metadata">

### Author: ![sammachin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/sammachin/32/5121_2.png) [@sammachin](https://discourse.nodered.org/u/sammachin)
#### Post date: [19 July 2022 11:09 UTC](https://discourse.nodered.org/t/insert-data-into-gsheet-in-same-row-with-new-timestamp/65275/2 "2022-07-19T11:09:54Z")

</div>

Have a look at the Google Sheets node [node-red-contrib-google-sheets (node) - Node-RED](https://flows.nodered.org/node/node-red-contrib-google-sheets)

That will allow you to update specific cells in the sheet.

---

<div class="post-metadata">

### Author: ![1onkar](https://avatars.discourse-cdn.com/v4/letter/1/ba9def/32.png) [@1onkar](https://discourse.nodered.org/u/1onkar)
#### Post date: [19 July 2022 14:26 UTC](https://discourse.nodered.org/t/insert-data-into-gsheet-in-same-row-with-new-timestamp/65275/3 "2022-07-19T14:26:47Z")

</div>

Hi Sammachin.. Thanks for your response. I could read a value but could not write a random value with Time stamp. I am just new learner. Could you please create a sample Flow to write/read a random value with time stamp. I want to keep updating same row/cell every time with new random number and new datetime. Thanks

---

<div class="post-metadata">

### Author: ![sammachin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/sammachin/32/5121_2.png) [@sammachin](https://discourse.nodered.org/u/sammachin)
#### Post date: [19 July 2022 15:31 UTC](https://discourse.nodered.org/t/insert-data-into-gsheet-in-same-row-with-new-timestamp/65275/4 "2022-07-19T15:31:53Z")

</div>

There are example flows included with the nodes

---

<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: [17 September 2022 20:37 UTC](https://discourse.nodered.org/t/insert-data-into-gsheet-in-same-row-with-new-timestamp/65275/6 "2022-09-17T20:37:51Z")

</div>

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