> 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)