> For the complete documentation index, see [llms.txt](https://astro-rpa.gitbook.io/astro-rpa-user-guide/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://astro-rpa.gitbook.io/astro-rpa-user-guide/g_elements/el_basic/gsheets.md).

# Google Sheets

In order to connect to Google Sheets services you need to complete following steps:

Navigate to developer console <https://console.developers.google.com/flows/enableapi?apiid=sheets.googleapis.com>

Create new project or choose existing then press Continue

![](/files/0R06bRp8aGdqKxBuAwR4)

Press Go to credentials

![](/files/EIjQCQOz2aa7Dd6UIEPW)

Press Cancel

![](/files/a1akOt9vp9Kv5YNGJoAu)

Proceed to OAuth consent screen menu

![](/files/mtdKgOI5ooBxwcHT0Mnn)

Choose user type and press Create

![](/files/MXK0oWCxRIzNlLKWYExV)

Enter application name (any), user support email address and developer email then press Save and continue on all following forms

![](/files/kaNmmLFOOGyvBoIm802H)

Navigate to Credentials menu then press Create credentials button. Click OAuth client ID

![](/files/NVae9OITRut8zQXPkygc)

Choose Desktop app and enter application name (any). Press Create button. Securely store information from pop up window (**Your client ID** and **Your client secret**). Press OK

![](/files/PyuTiGTBrMf8kAtvL5zX)

Download json file by pressing the button at application row. You will need to enter full local path to this file in property **File path** of **Google Sheets document** element.

![](/files/8ktHPSp8OxPDG3pNoceE)

To work with table you will need it's ID. You can get ID from table URL - it is the alphanumerical string between d/ and /edit parts. Enter that ID into **Spreadsheet ID** property of **Google Sheets document** element.

![](/files/RqkPj3JGZoks26BBehOV)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://astro-rpa.gitbook.io/astro-rpa-user-guide/g_elements/el_basic/gsheets.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.