Google Sheets

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

1. Navigate to the developer console.

2. Create a new project or choose an existing one, then press Continue

3. Press Go to credentials

4. Press Cancel

5. Proceed to OAuth consent screen menu

6. Choose user type and press Create

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

8. Navigate to the Credentials menu, then click on Create credentials. Click on OAuth client ID

9. In the Application type dropdown list, choose Desktop app and enter application name (any). Press Create button. Securely store the information from the pop up window (Your client ID and Your client secret). Press OK

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

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

Contents

There are the following element for working with Google Sheets:

1. Google Sheets document.

2. Write range.

3. Read range.