Hi,
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
object
payload: array[1]
0: array[3]
0: "1"
1: "0"
2: "-1"
topic: "0"
_msgid: "e12ba25a.8b6fa"