Google Sheets

Connect Dataworkz to Google Sheets to use spreadsheet data in your pipelines and AI applications.

Dataworkz supports two authentication methods for Google Sheets: Dataworkz OAuth (recommended) and Service Account OAuth.

Prerequisites

Dataworkz OAuth

Authorize Dataworkz to access your Google Sheets data using your Google account.

Service Account OAuth

1. Follow the Setup Service Account instructions to create a service account.

2. Share the target Google Sheet with the service account's email address.

3. In Google Cloud Console, go to APIs & Services > Enabled APIs & services and enable both:

   • Google Sheets API

   • Google Drive API

---

Create a Google Sheets Connector

Navigate to Configuration (gear icon) > Integrations > SaaS Applications > Google Sheets.

Google Sheets — list of configured connectors

Click + Add new configuration.

Add New Google Sheets — enter instance name and select OAuth option

Enter a Google instance name and select an OAuth option.

Dataworkz OAuth

1. With Dataworkz OAuth selected, click Sign in with Google and complete the Google authorization flow.

2. After authorization, the following fields appear:

Field	Required	Description
Workspace	Yes	The Dataworkz workspace to associate with this connector.
Spreadsheet url	No	The URL of the Google Sheet to connect.
Spreadsheet name	No	Select the specific sheet (tab) within the spreadsheet from the dropdown. Populate after entering the URL.

1. Click Save.

Add New Google Sheets — Workspace and spreadsheet fields after Dataworkz OAuth authorization

Service Account OAuth

1. Select Service Account OAuth from the OAuth option dropdown.

2. Enter the following credentials from your Google Cloud service account:

Field	Required	Description
Client Id	Yes	The service account client ID.
Client email	Yes	The service account email address.
Authenticate certificate option	Yes	How the certificate is provided — Text to paste directly, or File to upload.
Authenticate certificate type	Yes	The certificate format — typically Pem.
Private key id	Yes	The ID of the private key from the service account JSON.
Private key	Yes	The private key contents from the service account JSON.
Workspace	Yes	The Dataworkz workspace to associate with this connector.
Spreadsheet url	No	The URL of the Google Sheet to connect.
Spreadsheet name	No	Select the specific sheet (tab) within the spreadsheet from the dropdown.

1. Click Authenticate. If authentication succeeds, click Save.

Add New Google Sheets — Service Account OAuth fields

The new connector appears in the Google Sheets list and is ready to use as a data source in your pipelines.