# 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: 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:

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

The question should be specific, self-contained, and written in natural language.
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.