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 connector list
Google Sheets — list of configured connectors

Click + Add new configuration.

Add New Google Sheets form
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 — Dataworkz OAuth authorized state
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 form
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.

Last updated