Insert data into Gsheet in same row with new timestamp

General
1

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

2

Have a look at the Google Sheets node node-red-contrib-google-sheets (node) - Node-RED

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

3

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

4

There are example flows included with the nodes

6

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