Google Sheets Connector

An Orchesty connector for Google Sheets, a web-based spreadsheet application that enables users to create, edit, and collaborate on spreadsheets in real time.

Application Type

OAuth 2.0

This connector uses Google OAuth 2.0 with the auth/spreadsheets scope. After entering your credentials in Orchesty, you will be redirected to Google to authorize access.

| Field | Description | |---|---| | client_id | OAuth Client ID from the Google Cloud Console | | client_secret | OAuth Client Secret from the Google Cloud Console |

Components

| Class | Type | Description | |---|---|---| | GoogleSheetCreateSpreadsheetConnector | Connector | Creates a new Google Sheets spreadsheet with an initial sheet populated from a 2D data array via POST /v4/spreadsheets |

Setup

Credentials

1. Go to the Google Cloud Console and open your project.
2. Navigate to APIs & Services → Credentials.
3. Create an OAuth 2.0 Client ID (type: Web application).
4. Add the Orchesty OAuth callback URL to Authorized redirect URIs.
5. Copy the Client ID and Client Secret.
6. Enable the Google Sheets API under APIs & Services → Library.
7. In Orchesty, open the Google Sheets application settings, enter the credentials, and complete the OAuth authorization flow.

API Documentation

Google Sheets REST API: https://developers.google.com/sheets/api/reference/rest

Installation & Usage

Install the package:

npm install @orchesty/connector-google-sheet @orchesty/nodejs-sdk
# or
pnpm add @orchesty/connector-google-sheet @orchesty/nodejs-sdk

Register the application and nodes in your Orchesty DI container:

import { container } from '@orchesty/nodejs-sdk';
import { OAuth2Provider } from '@orchesty/nodejs-sdk/dist/lib/Authorization/Provider/OAuth2/OAuth2Provider';
import GoogleSheetApplication from '@orchesty/connector-google-sheet/dist/GoogleSheetApplication';
import GoogleSheetCreateSpreadsheetConnector from '@orchesty/connector-google-sheet/dist/Connector/GoogleSheetCreateSpreadsheetConnector';

const app = new GoogleSheetApplication(container.get(OAuth2Provider));
container.setApplication(app);
container.setNode(new GoogleSheetCreateSpreadsheetConnector(), app);

License

This connector is released under the Apache License 2.0. See the LICENSE file for the full license text.

Contributing

Contributions are welcome! This connector is part of the open-source Orchesty Node.js Connectors monorepo.

For guidelines on how to create or update connectors — including project setup, coding conventions, and how to write tests — please refer to the Contributing to Connectors guide.

All contributions should include:

• Source code in src/ following the existing connector structure
• Tests in src/**/__tests__/ with input.json, mock.json, and output.json fixtures
• An updated CHANGELOG.md entry