How to access data read from google sheets

I am sure this is simple but as a newbie I am struggling.
I have a node that reads 3 cells from a Google sheet. That all works great. Now what I'd like to do is parse out the values in the array to individual global variables.
I feel foolish but I don't seem to get how to get these values out of the msg.payload.
The text below shows the msg.payload from the Gsheets-Get node. I have tried to use array for each index but no joy. Any help is much appreciated.

8/7/2023, 4:59:31 PMnode: 289aad7a.027592
0 : msg : Object
payload: array[1]
0: array[3]
0: "1"
1: "0"
2: "-1"
topic: "0"
_msgid: "e12ba25a.8b6fa"

There’s a great page in the docs (Working with messages : Node-RED) that will explain how to use the debug panel to find the right path to any data item.

Pay particular attention to the part about the buttons that appear under your mouse pointer when you over hover a debug message property in the sidebar.


This is just the document I needed. Thank you very much!

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