> For the complete documentation index, see [llms.txt](https://nexaflow.gitbook.io/nexaflow/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://nexaflow.gitbook.io/nexaflow/developer-apis/get-data-from-a-google-sheet.md).

# Get data from a Google Sheet

https\://nexaflow\.readme.io/reference/getgooglesheetdata

Video Link: <https://youtu.be/SSY0Pa964og>

API to get data from a single sheet.

1. Enter the Access token in Authentication block on the right, to access APIs. \
   And enter spreadsheet Id in the highlighted column (in the below image).

<figure><img src="https://387507878-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FycQB8h7OUwrj2xCwvIQS%2Fuploads%2FAlA9Cs4UKLYnLqRmvNq1%2Fimage.png?alt=media&amp;token=9a33cf7c-7711-4b4b-a033-000044eeb411" alt=""><figcaption></figcaption></figure>

2. Click on **Try It!** button. And you can see the data retrieved in the response tab.

<figure><img src="https://387507878-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FycQB8h7OUwrj2xCwvIQS%2Fuploads%2FK16s4O5vwPGyyMcjMtBT%2Fimage.png?alt=media&amp;token=fa2c147c-e892-482a-8bbc-1a00380688a4" alt=""><figcaption></figcaption></figure>