Google Sheets

This document describes the Dataworkz connector configuration required to access Google Sheets. Dataworkz requires one of the following OAuth setup before proceeding with the configuration

1. OAuth

2. Service Account

OAuth

You need to authorize Dataworkz to access your Google Sheets data

Service Account

In order to setup service accountOAuth follow the Setup Service Account instructions. After that goto “APIs & Services” -> “Enabled APIs & services” and enable the following.

1. Google Sheets API

2. Google Drive API

Create Connector for Google Sheets

1. Login to Dataworkz Application

2. Goto Configuration -> SaaS Applications -> Google Sheet

3. Click the + icon to add a new configuration

4. Enter name for the configuration in the above screen

5. Select the authentication option for your account (OAuth / Service Account)

OAuth

1. This requires using Google OAuth to authorize Dataworkz to access Google Sheets

2. Select the workspace

3. Provide URL of the google sheet

4. From the dropdown select the tab from the list of tabs in the spreadsheet

5. Click Save

Service Account OAuth

1. Enter the Client ID

2. Enter the Client email ID

3. Select the certification option & type

4. Enter the Private Key ID

5. Enter the Private Key

6. Select the workspace & collection

7. Test the connection

8. Select the workspace

9. Provide URL of the google sheet

10. From the dropdown select the tab from the list of tabs in the spreadsheet

11. Click Save

Newly created connector would show up in the list of Google Sheet configurations