![google-sheets icon](/docs/img/components/icons/60/Z29vZ2xlLXNoZWV0cw==.png)

# Google Sheets Connector

key: google-sheets[Source](https://github.com/prismatic-io/components/tree/main/components/google-sheets)[API Docs](https://developers.google.com/workspace/sheets/api/guides/concepts)[API Changelog](https://developers.google.com/workspace/sheets/release-notes)[Connector Changelog](#changelog)

## Description[​](#description "Direct link to Description")

[Google Sheets](https://www.google.com/sheets/about/) is a cloud-based spreadsheet service from Google. This component allows you to create and manage spreadsheets, manipulate sheets and rows, and read cell data within Google Drive.

#### API Documentation[​](#api-documentation "Direct link to API Documentation")

This component was built using the [Google Sheets API](https://developers.google.com/sheets/api/reference/rest) v4. Additional information can be found in the [Google Sheets API Guides](https://developers.google.com/sheets/api/guides/concepts).

## Connections[​](#connections "Direct link to Connections")

### Google Sheets OAuth 2.0[​](#oauth2 "Direct link to Google Sheets OAuth 2.0")

**key: oauth2**

The Google Sheets component authenticates requests through the Google Cloud Platform (GCP) OAuth 2.0 service. A GCP OAuth 2.0 app is required for the integration to authenticate and perform Google Sheets tasks on behalf of users.

#### Prerequisites[​](#prerequisites "Direct link to Prerequisites")

* A Google Developer account (sign up at <https://console.cloud.google.com/>)

#### Setup Steps[​](#setup-steps "Direct link to Setup Steps")

To create a Google Sheets OAuth 2.0 app:

1. Open the Google Sheets API console at <https://console.cloud.google.com/apis/api/sheets.googleapis.com>.

2. Click **CREATE PROJECT** to create a new GCP project, or select an existing project.

3. Enable the **Google Sheets API** for the project by clicking **ENABLE**.

4. On the sidebar, select **Credentials**.

5. Configure the OAuth 2.0 Consent Screen by clicking **CONFIGURE CONSENT SCREEN**.

   <!-- -->

   1. Choose a **User Type** of **External** so the app will be available to users outside the organization.
   2. Fill out the OAuth consent screen with an app name, support email, and other required information.
   3. On the Scopes page, add the necessary scopes (see scope configuration below).
   4. Enter **test users** for testing purposes. The app will only work for those testing users until it is published.
   5. When ready for production, click **PUBLISH APP** on the **OAuth consent screen** to allow users to authorize the integration.

6. Once the consent screen is configured, open the **Credentials** page from the sidebar.

7. Click **+CREATE CREDENTIALS** and select **OAuth client ID**.

   <!-- -->

   1. Under **Application type** select **Web application**.
   2. Under **Authorized redirect URIs** enter the OAuth 2.0 callback URL: `https://oauth2.prismatic.io/callback`
   3. Click **CREATE**.

8. Copy the **Client ID** and **Client Secret** that are generated.

#### Configure the Connection[​](#configure-the-connection "Direct link to Configure the Connection")

* Enter the **Client ID** and **Client Secret** from the OAuth app credentials.

* For **Scopes**, use the following value:

  ```text
  https://www.googleapis.com/auth/spreadsheets https://www.googleapis.com/auth/drive.file https://www.googleapis.com/auth/drive.readonly

  ```

  * The `spreadsheets` scope allows full access to Google Sheets.
  * The `drive.file` scope allows access to files created or opened by the integration.
  * The `drive.readonly` scope allows read-only access to Drive metadata.
  * Refer to [Google's OAuth 2.0 Scopes for Google APIs](https://developers.google.com/identity/protocols/oauth2/scopes#sheets) for additional scope information.

#### App Verification[​](#app-verification "Direct link to App Verification")

Google requires OAuth apps that request access to user data to pass a verification review before being deployed at scale. This process ensures the app complies with Google's API Services User Data Policy, accurately represents its functionality, and handles user data responsibly.

Google OAuth apps pass through three stages before they are ready for production use.

**Testing (unpublished):** The app is only accessible to users manually added as test users in the OAuth consent screen. Up to 100 test users are allowed — all other users receive an error. This is the expected state during initial development.

**Published, unverified:** After publishing the app, all Google users can authenticate. However, for sensitive scopes, users see a **"This app isn't verified"** warning. Users can proceed by clicking **Advanced** → **Go to \[app name] (unsafe)**, but this warning reduces trust and may be blocked by organizations with strict Google Workspace policies.

**Verified:** Google has reviewed and approved the app. No warning is shown. Verification is required before deploying to production users.

#### Publishing the App[​](#publishing-the-app "Direct link to Publishing the App")

Publishing is required before any users outside the test list can authenticate:

1. In the [Google Cloud Console](https://console.cloud.google.com/), navigate to **APIs & Services** → **OAuth consent screen**
2. Click **PUBLISH APP** and confirm

#### Requesting Verification[​](#requesting-verification "Direct link to Requesting Verification")

The scopes used by this component are classified as **sensitive** by Google. Submitting for verification removes the "This app isn't verified" warning:

1. On the **OAuth consent screen**, click **Prepare for verification**
2. Provide a privacy policy URL, authorized domain, and app logo
3. Submit for review — Google typically responds within several weeks

Refer to [Google's OAuth consent screen documentation](https://support.google.com/cloud/answer/10311615) for the full verification requirements.

| Input         | Notes                                                                                                                                                                                                                                     | Example                                                                                                                                      |
| ------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------- |
| Authorize URL | The OAuth 2.0 Authorization URL for Google Sheets.                                                                                                                                                                                        | https\://accounts.google.com/o/oauth2/v2/auth?access\_type=offline\&prompt=consent                                                           |
| Client ID     | Client ID from your Google Cloud Console OAuth credentials. [Learn more](https://developers.google.com/workspace/guides/create-credentials#oauth-client-id)                                                                               | 123456789012-abcdefghijklmnopqrstuvwxyz123456.apps.googleusercontent.com                                                                     |
| Client Secret | Client Secret generated in your Google Cloud Console OAuth credentials. [Learn more](https://developers.google.com/workspace/guides/create-credentials#oauth-client-id)                                                                   | GOCSPX-abcdefghijklmnopqrstuvwxyz                                                                                                            |
| Scopes        | Space-delimited list of OAuth scopes to request. Common scopes include spreadsheets (read/write), drive.file (create/edit files), and drive.readonly. [Learn more](https://developers.google.com/identity/protocols/oauth2/scopes#sheets) | https\://www\.googleapis.com/auth/spreadsheets https\://www\.googleapis.com/auth/drive.file https\://www\.googleapis.com/auth/drive.readonly |
| Token URL     | The OAuth 2.0 Token URL for Google Sheets.                                                                                                                                                                                                | https\://oauth2.googleapis.com/token                                                                                                         |

## Triggers[​](#triggers "Direct link to Triggers")

### Spreadsheet Change Events[​](#spreadsheetchangeevents "Direct link to Spreadsheet Change Events")

Receive change notifications for a Google Spreadsheet. Automatically creates and manages a Google Drive push notification subscription when the instance is deployed, and removes the subscription when the instance is deleted. | **key: spreadsheetChangeEvents**

| Input          | Notes                                   | Example                                      |
| -------------- | --------------------------------------- | -------------------------------------------- |
| Connection     | The Google Sheets connection to use.    |                                              |
| Spreadsheet ID | The spreadsheet to monitor for changes. | 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms |

The Spreadsheet Change Events trigger automatically creates and manages [Google Drive push notification subscriptions](https://developers.google.com/drive/api/guides/push) for a Google Spreadsheet. This trigger handles the complete webhook lifecycle, including subscription creation, renewal, and deletion, eliminating the need for manual webhook configuration.

When the trigger is used in a flow:

* **On Instance Deploy**: The trigger creates a Google Drive file watch subscription for the specified spreadsheet. The subscription monitors all changes to the spreadsheet file and automatically renews before expiration.
* **On Scheduled Renewal**: The trigger automatically renews the subscription before it expires (subscriptions have a 7-day lifespan) to ensure uninterrupted change notifications.
* **On Instance Deletion**: The trigger removes the watch subscription from Google Drive and cleans up all associated resources.

#### Configuration[​](#configuration "Direct link to Configuration")

Configure the trigger with the following inputs:

* **Connection**: Google Sheets OAuth 2.0 connection with permissions to access Google Drive and create file watch subscriptions
* **Spreadsheet ID**: The unique identifier of the Google Spreadsheet to monitor (found in the spreadsheet URL: `https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit`)

#### How It Works[​](#how-it-works "Direct link to How It Works")

The trigger manages push notifications through Google Drive's file watch API:

**On Instance Deploy:**

1. Creates a file watch subscription using the [Google Drive Files: watch](https://developers.google.com/drive/api/reference/rest/v3/files/watch) endpoint
2. Generates a unique channel ID for the subscription
3. Sets a 7-day expiration for the subscription
4. Stores the channel ID, resource ID, and expiration in cross-flow state
5. Google sends a sync notification to confirm the subscription is active

**On Change Notification:**

1. Receives push notification from Google Drive when the spreadsheet changes

2. Validates the channel ID and resource ID match the stored subscription (prevents unauthorized calls)

3. Checks the resource state from `X-Goog-Resource-State` header:

   <!-- -->

   * **update**: Spreadsheet content or properties changed
   * **remove**: Spreadsheet was deleted or moved to trash
   * **sync**: Initial confirmation notification

4. For update events, fetches current spreadsheet metadata including all worksheets and file details

5. Routes the enriched payload to the appropriate branch

#### Branches[​](#branches "Direct link to Branches")

The trigger uses two branches to handle different notification types:

**Push Notifications** - Handles actual spreadsheet change events:

* Triggered when the spreadsheet is updated or removed
* Payload includes enriched spreadsheet metadata, file details, and notification information
* The `notification.resourceState` field indicates whether the spreadsheet was updated or removed
* The `notification.changedFields` field specifies what changed (e.g., "content,properties")

**Log Messages** - Handles system notifications:

* Triggered for sync notifications (initial subscription confirmation)
* Triggered for scheduled renewal confirmations
* Provides operational visibility into subscription lifecycle events
* Useful for debugging and monitoring subscription health

#### Returned Data[​](#returned-data "Direct link to Returned Data")

The trigger returns different data structures depending on the notification type.

Example payload for spreadsheet update notification

```json
{
  "spreadsheet": {
    "title": "Example Spreadsheet",
    "spreadsheetId": "1ABC123DEF456GHI789JKL012MNO345PQR678STU901",
    "worksheets": [
      {
        "title": "Sheet1",
        "sheetId": 0,
        "rowCount": 1000,
        "columnCount": 26
      }
    ],
    "worksheetCount": 1
  },
  "file": {
    "name": "Example Spreadsheet",
    "modifiedTime": "2026-01-06T22:25:56.293Z",
    "lastModifyingUser": {
      "kind": "drive#user",
      "displayName": "John Doe",
      "photoLink": "https://lh3.googleusercontent.com/a/ExamplePhotoLinkId",
      "me": true,
      "permissionId": "12345678901234567890",
      "emailAddress": "john.doe@example.com"
    },
    "webViewLink": "https://docs.google.com/spreadsheets/d/1ABC123DEF456GHI789JKL012MNO345PQR678STU901/edit?usp=drivesdk",
    "size": "1024"
  },
  "notification": {
    "resourceState": "update",
    "changedFields": "content,properties",
    "resourceId": "ExampleResourceId1234567890",
    "timestamp": "2026-01-06T22:26:35.618Z"
  }
}

```

Example payload for spreadsheet removal notification

When a spreadsheet is deleted or moved to trash, the payload contains minimal information:

```json
{
  "spreadsheet": null,
  "file": null,
  "notification": {
    "resourceState": "remove",
    "changedFields": null,
    "resourceId": "ExampleResourceId1234567890",
    "timestamp": "2026-01-06T22:26:35.618Z"
  }
}

```

Example payload for sync notification (Log Messages branch)

```json
{
  "notification": {
    "resourceState": "sync",
    "resourceId": "ExampleResourceId1234567890",
    "timestamp": "2026-01-06T22:26:35.618Z",
    "type": "sync"
  }
}

```

Example Payload for <!-- -->Spreadsheet Change Events[⤓](https://prismatic.io/docs/example-payloads/google-sheets/triggers/spreadsheetChangeEvents.json "Download example payload")

Loading…

***

## Data Sources[​](#data-sources "Direct link to Data Sources")

### Select Column[​](#selectcolumn "Direct link to Select Column")

Select a Column from a Worksheet | **key: selectColumn** | **type: picklist**

| Input           | Notes                                                                                                                                              | Example                                      |
| --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- |
| Connection      | The Google Sheets connection to use.                                                                                                               |                                              |
| Spreadsheet ID  | The unique identifier of the spreadsheet. You can find the spreadsheet ID in the URL: https\://docs.google.com/spreadsheets/d/SPREADSHEET\_ID/edit | 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms |
| Worksheet Title | The title of the worksheet within the spreadsheet.                                                                                                 | Sheet1                                       |

Example Payload for <!-- -->Select Column[⤓](https://prismatic.io/docs/example-payloads/google-sheets/data-sources/selectColumn.json "Download example payload")

Loading…

***

### Select Columns[​](#selectcolumns "Direct link to Select Columns")

Select Columns from a Worksheet | **key: selectColumns** | **type: objectSelection**

| Input           | Notes                                                                                                                                              | Example                                      |
| --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- |
| Connection      | The Google Sheets connection to use.                                                                                                               |                                              |
| Spreadsheet ID  | The unique identifier of the spreadsheet. You can find the spreadsheet ID in the URL: https\://docs.google.com/spreadsheets/d/SPREADSHEET\_ID/edit | 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms |
| Worksheet Title | The title of the worksheet within the spreadsheet.                                                                                                 | Sheet1                                       |

Example Payload for <!-- -->Select Columns[⤓](https://prismatic.io/docs/example-payloads/google-sheets/data-sources/selectColumns.json "Download example payload")

Loading…

***

### Select Spreadsheet[​](#selectspreadsheet "Direct link to Select Spreadsheet")

Select a Spreadsheet | **key: selectSpreadsheet** | **type: picklist**

| Input      | Notes                                | Example |
| ---------- | ------------------------------------ | ------- |
| Connection | The Google Sheets connection to use. |         |

***

### Select Worksheet[​](#selectworksheet "Direct link to Select Worksheet")

Select a Worksheet | **key: selectWorksheet** | **type: picklist**

| Input            | Notes                                                                                                                                              | Example                                      |
| ---------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- |
| Connection       | The Google Sheets connection to use.                                                                                                               |                                              |
| Spreadsheet ID   | The unique identifier of the spreadsheet. You can find the spreadsheet ID in the URL: https\://docs.google.com/spreadsheets/d/SPREADSHEET\_ID/edit | 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms |
| Worksheet Return | Select whether to return the worksheet ID (numeric) or name (title) in the response.                                                               | false                                        |

Example Payload for <!-- -->Select Worksheet[⤓](https://prismatic.io/docs/example-payloads/google-sheets/data-sources/selectWorksheet.json "Download example payload")

Loading…

***

## Actions[​](#actions "Direct link to Actions")

### Add Worksheet[​](#addsheet "Direct link to Add Worksheet")

Add a new Worksheet to a Google Sheet Document | **key: addSheet**

| Input           | Notes                                                                                                                                              | Example                                      |
| --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- |
| Connection      | The Google Sheets connection to use.                                                                                                               |                                              |
| Column Headings | An array of strings representing the column header names.                                                                                          | See Example                                  |
| Spreadsheet ID  | The unique identifier of the spreadsheet. You can find the spreadsheet ID in the URL: https\://docs.google.com/spreadsheets/d/SPREADSHEET\_ID/edit | 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms |
| Worksheet Title | The title of the worksheet within the spreadsheet.                                                                                                 | Sheet1                                       |

***

### Append Rows[​](#appendrows "Direct link to Append Rows")

Append new rows to a Worksheet | **key: appendRows**

| Input            | Notes                                                                                                                                                                       | Example                                      |
| ---------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- |
| Connection       | The Google Sheets connection to use.                                                                                                                                        |                                              |
| Rows             | An array of row data. Can be an array of arrays (e.g., \[\[1,2,3], \[4,5,6]]) or an array of objects where keys are column headers (e.g., \[{"Column 1": "a"}]).            | See Example                                  |
| Spreadsheet ID   | The unique identifier of the spreadsheet. You can find the spreadsheet ID in the URL: https\://docs.google.com/spreadsheets/d/SPREADSHEET\_ID/edit                          | 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms |
| Store Raw Values | When true, stores values exactly as provided without conversion. When false, values are converted as if typed into the spreadsheet (e.g., "=SUM(A1:A5)" becomes a formula). | false                                        |
| Worksheet Title  | The title of the worksheet within the spreadsheet.                                                                                                                          | Sheet1                                       |

***

### Clear Worksheet[​](#clearsheet "Direct link to Clear Worksheet")

Clear all data in the a Worksheet | **key: clearSheet**

| Input           | Notes                                                                                                                                              | Example                                      |
| --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- |
| Connection      | The Google Sheets connection to use.                                                                                                               |                                              |
| Spreadsheet ID  | The unique identifier of the spreadsheet. You can find the spreadsheet ID in the URL: https\://docs.google.com/spreadsheets/d/SPREADSHEET\_ID/edit | 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms |
| Worksheet Title | The title of the worksheet within the spreadsheet.                                                                                                 | Sheet1                                       |

***

### Create Spreadsheet[​](#createdocument "Direct link to Create Spreadsheet")

Create a new Google Sheet Document | **key: createDocument**

| Input          | Notes                                | Example |
| -------------- | ------------------------------------ | ------- |
| Connection     | The Google Sheets connection to use. |         |
| Document Title | Specifies the title of the document. | Sheet1  |

***

### List Columns[​](#listcolumns "Direct link to List Columns")

Get the headers of a Worksheet | **key: listColumns**

| Input           | Notes                                                                                                                                              | Example                                      |
| --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- |
| Connection      | The Google Sheets connection to use.                                                                                                               |                                              |
| Spreadsheet ID  | The unique identifier of the spreadsheet. You can find the spreadsheet ID in the URL: https\://docs.google.com/spreadsheets/d/SPREADSHEET\_ID/edit | 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms |
| Worksheet Title | The title of the worksheet within the spreadsheet.                                                                                                 | Sheet1                                       |

Example Payload for <!-- -->List Columns[⤓](https://prismatic.io/docs/example-payloads/google-sheets/actions/listColumns.json "Download example payload")

Loading…

***

### List Rows[​](#getrows "Direct link to List Rows")

List the cell values of rows in a Worksheet | **key: getRows**

| Input           | Notes                                                                                                                                              | Example                                      |
| --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- |
| Connection      | The Google Sheets connection to use.                                                                                                               |                                              |
| Limit           | The maximum number of rows to retrieve.                                                                                                            | 100                                          |
| Offset          | The number of rows to skip from the top of the worksheet.                                                                                          | 0                                            |
| Spreadsheet ID  | The unique identifier of the spreadsheet. You can find the spreadsheet ID in the URL: https\://docs.google.com/spreadsheets/d/SPREADSHEET\_ID/edit | 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms |
| Worksheet Title | The title of the worksheet within the spreadsheet.                                                                                                 | Sheet1                                       |

Example Payload for <!-- -->List Rows[⤓](https://prismatic.io/docs/example-payloads/google-sheets/actions/getRows.json "Download example payload")

Loading…

***

### List Worksheets[​](#listsheets "Direct link to List Worksheets")

List information about all Worksheets in a Google Sheet Document | **key: listSheets**

| Input          | Notes                                                                                                                                              | Example                                      |
| -------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- |
| Connection     | The Google Sheets connection to use.                                                                                                               |                                              |
| Spreadsheet ID | The unique identifier of the spreadsheet. You can find the spreadsheet ID in the URL: https\://docs.google.com/spreadsheets/d/SPREADSHEET\_ID/edit | 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms |

Example Payload for <!-- -->List Worksheets[⤓](https://prismatic.io/docs/example-payloads/google-sheets/actions/listSheets.json "Download example payload")

Loading…

***

### Raw Request[​](#rawrequest "Direct link to Raw Request")

Send raw HTTP request to Google Sheets | **key: rawRequest**

| Input                   | Notes                                                                                                                                                                                                                                                                                 | Example                                                       |
| ----------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------- |
| Connection              | The Google Sheets connection to use.                                                                                                                                                                                                                                                  |                                                               |
| Data                    | The HTTP body payload to send to the URL.                                                                                                                                                                                                                                             | {"exampleKey": "Example Data"}                                |
| File Data               | File Data to be sent as a multipart form upload.                                                                                                                                                                                                                                      | \[{key: "example.txt", value: "My File Contents"}]            |
| File Data File Names    | File names to apply to the file data inputs. Keys must match the file data keys above.                                                                                                                                                                                                |                                                               |
| Form Data               | The Form Data to be sent as a multipart form upload.                                                                                                                                                                                                                                  | \[{"key": "Example Key", "value": new Buffer("Hello World")}] |
| Header                  | A list of headers to send with the request.                                                                                                                                                                                                                                           | User-Agent: curl/7.64.1                                       |
| Max Retry Count         | The maximum number of retries to attempt. Specify 0 for no retries.                                                                                                                                                                                                                   | 0                                                             |
| Method                  | The HTTP method to use.                                                                                                                                                                                                                                                               |                                                               |
| Query Parameter         | A list of query parameters to send with the request. This is the portion at the end of the URL similar to ?key1=value1\&key2=value2.                                                                                                                                                  |                                                               |
| Response Type           | The type of data you expect in the response. You can request json, text, or binary data.                                                                                                                                                                                              | json                                                          |
| Retry On All Errors     | If true, retries on all erroneous responses regardless of type. This is helpful when retrying after HTTP 429 or other 3xx or 4xx errors. Otherwise, only retries on HTTP 5xx and network errors.                                                                                      | false                                                         |
| Retry Delay (ms)        | The delay in milliseconds between retries. This is used when 'Use Exponential Backoff' is disabled.                                                                                                                                                                                   | 0                                                             |
| Timeout                 | The maximum time that a client will await a response to its request                                                                                                                                                                                                                   | 2000                                                          |
| URL                     | Input the path only (/v4/spreadsheets/{spreadsheetId}), The base URL is already included (https\://sheets.googleapis.com). For example, to connect to https\://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}, only /v4/spreadsheets/{spreadsheetId} is entered in this field. | /v4/spreadsheets/{spreadsheetId}                              |
| Use Exponential Backoff | Specifies whether to use a pre-defined exponential backoff strategy for retries. When enabled, 'Retry Delay (ms)' is ignored.                                                                                                                                                         | false                                                         |

***

### Remove Worksheet[​](#removesheet "Direct link to Remove Worksheet")

Remove a Worksheet from a Google Sheet Document | **key: removeSheet**

| Input           | Notes                                                                                                                                              | Example                                      |
| --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- |
| Connection      | The Google Sheets connection to use.                                                                                                               |                                              |
| Spreadsheet ID  | The unique identifier of the spreadsheet. You can find the spreadsheet ID in the URL: https\://docs.google.com/spreadsheets/d/SPREADSHEET\_ID/edit | 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms |
| Worksheet Title | The title of the worksheet within the spreadsheet.                                                                                                 | Sheet1                                       |

***

### Set Header Row[​](#setheaderrow "Direct link to Set Header Row")

Set the column headings in a Worksheet | **key: setHeaderRow**

| Input           | Notes                                                                                                                                              | Example                                      |
| --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- |
| Connection      | The Google Sheets connection to use.                                                                                                               |                                              |
| Column Headings | An array of strings representing the column header names.                                                                                          | See Example                                  |
| Spreadsheet ID  | The unique identifier of the spreadsheet. You can find the spreadsheet ID in the URL: https\://docs.google.com/spreadsheets/d/SPREADSHEET\_ID/edit | 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms |
| Worksheet Title | The title of the worksheet within the spreadsheet.                                                                                                 | Sheet1                                       |

***

### Update Rows[​](#updaterows "Direct link to Update Rows")

Update call values of rows in a Worksheet | **key: updateRows**

| Input            | Notes                                                                                                                                                                       | Example                                      |
| ---------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- |
| Connection       | The Google Sheets connection to use.                                                                                                                                        |                                              |
| Spreadsheet ID   | The unique identifier of the spreadsheet. You can find the spreadsheet ID in the URL: https\://docs.google.com/spreadsheets/d/SPREADSHEET\_ID/edit                          | 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms |
| Store Raw Values | When true, stores values exactly as provided without conversion. When false, values are converted as if typed into the spreadsheet (e.g., "=SUM(A1:A5)" becomes a formula). | false                                        |
| Worksheet Title  | The title of the worksheet within the spreadsheet.                                                                                                                          | Sheet1                                       |
| Values           | An object where keys are row numbers and values are objects mapping column names to cell values.                                                                            | See Example                                  |

***

## Changelog[​](#changelog "Direct link to Changelog")

### 2026-04-30[​](#2026-04-30 "Direct link to 2026-04-30")

Updated spectral version

### 2026-01-26[​](#2026-01-26 "Direct link to 2026-01-26")

Added **Spreadsheet Change Events** trigger with automatic webhook lifecycle management for real time spreadsheet notifications
