# 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

![](https://1755238209-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FNnEkyZmLMSWTDXxpygbG%2Fuploads%2Fgit-blob-2debb715443beca9980335dfde850fb867bdd057%2Fimage%20\(128\).png?alt=media)

Press Go to credentials

![](https://1755238209-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FNnEkyZmLMSWTDXxpygbG%2Fuploads%2Fgit-blob-64f1195d8054a65338fa0eed84030d6a3ac4b433%2Fimage%20\(293\).png?alt=media)

Press Cancel

![](https://1755238209-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FNnEkyZmLMSWTDXxpygbG%2Fuploads%2Fgit-blob-026de11fe8a6ea1c7cf334af984cfa2bc791a5e3%2Fimage%20\(261\).png?alt=media)

Proceed to OAuth consent screen menu

![](https://1755238209-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FNnEkyZmLMSWTDXxpygbG%2Fuploads%2Fgit-blob-707b67db5a9e1836a43405f7bb963b7b30a03176%2Fimage%20\(195\).png?alt=media)

Choose user type and press Create

![](https://1755238209-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FNnEkyZmLMSWTDXxpygbG%2Fuploads%2Fgit-blob-a7b166f29c9d0c6ff8ac80533b2635c75c1f0f56%2Fimage%20\(133\).png?alt=media)

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

![](https://1755238209-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FNnEkyZmLMSWTDXxpygbG%2Fuploads%2Fgit-blob-1be36b2cff09e05e34a79f6d6f71be3bf6eec121%2Fimage%20\(138\).png?alt=media)

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

![](https://1755238209-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FNnEkyZmLMSWTDXxpygbG%2Fuploads%2Fgit-blob-f57666b1265a73e692b233171a2a48150c880c2b%2Fimage%20\(248\).png?alt=media)

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

![](https://1755238209-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FNnEkyZmLMSWTDXxpygbG%2Fuploads%2Fgit-blob-94d11a8359cb95b6ee4db84c06ee06e312f20583%2Fimage%20\(198\).png?alt=media)

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.

![](https://1755238209-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FNnEkyZmLMSWTDXxpygbG%2Fuploads%2Fgit-blob-8e5106519058d52427a2c76f32f63f516b2493c4%2Fimage%20\(257\).png?alt=media)

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.

![](https://1755238209-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FNnEkyZmLMSWTDXxpygbG%2Fuploads%2Fgit-blob-56fbc8b9e386748fde66c718adc9f7c929c8fbf2%2Fimage%20\(142\).png?alt=media)