# How to access data read from google sheets
**URL:** https://discourse.nodered.org/t/how-to-access-data-read-from-google-sheets/80390
**Category:** General
**Created:** [7 August 2023 21:11 UTC](https://discourse.nodered.org/t/how-to-access-data-read-from-google-sheets/80390 "2023-08-07T21:11:19Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Stumbleinn](https://discourse.nodered.org/u/Stumbleinn)
#### Post date: [7 August 2023 21:11 UTC](https://discourse.nodered.org/t/how-to-access-data-read-from-google-sheets/80390/1 "2023-08-07T21:11:19Z")
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"
---
### Author:  [@Sean-McG](https://discourse.nodered.org/u/Sean-McG)
#### Post date: [7 August 2023 23:58 UTC](https://discourse.nodered.org/t/how-to-access-data-read-from-google-sheets/80390/2 "2023-08-07T23:58:58Z")
There’s a great page in the docs ([Working with messages : Node-RED](https://nodered.org/docs/user-guide/messages)) 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.
---
### Author:  [@Stumbleinn](https://discourse.nodered.org/u/Stumbleinn)
#### Post date: [8 August 2023 12:53 UTC](https://discourse.nodered.org/t/how-to-access-data-read-from-google-sheets/80390/3 "2023-08-08T12:53:02Z")
This is just the document I needed. Thank you very much!
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [7 October 2023 12:53 UTC](https://discourse.nodered.org/t/how-to-access-data-read-from-google-sheets/80390/4 "2023-10-07T12:53:24Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.