---
title: "Google Sheets Integration"
description: "Read and update Google Sheets spreadsheets"
---
The Google Sheets integration provides access to read and update Google Sheets spreadsheets through the Integrate MCP server.

## Installation

The Google Sheets integration is included with the SDK:

```typescript
import { googleSheetsIntegration } from "integrate-sdk/server";
```

## Setup

### 1. Create a Google Sheets OAuth App

1. Go to [Google Cloud Console](https://console.cloud.google.com)
2. Create a new OAuth application
3. Configure your redirect URI
4. Note your Client ID and Client Secret

### 2. Configure the Integration on Your Server

Add the Google Sheets integration to your server configuration. The integration automatically reads `GOOGLE_SHEETS_CLIENT_ID` and `GOOGLE_SHEETS_CLIENT_SECRET` from your environment variables:

```typescript
import { createMCPServer, googleSheetsIntegration } from "integrate-sdk/server";

export const { client: serverClient } = createMCPServer({
  apiKey: process.env.INTEGRATE_API_KEY,
  integrations: [
    googleSheetsIntegration({
    }),
  ],
});
```

You can override the environment variables by passing explicit values:

```typescript
googleSheetsIntegration({
  clientId: process.env.CUSTOM_GOOGLE_SHEETS_ID,
  clientSecret: process.env.CUSTOM_GOOGLE_SHEETS_SECRET,
});
```

### 3. Client-Side Usage

The default client automatically includes all integrations. You can use it directly:

```typescript
import { client } from "integrate-sdk";

await client.authorize("google_sheets");
const result = await client.google_sheets.list({});

console.log(result);
```

If you're using a custom client, add the integration to the integrations array:

```typescript
import { createMCPClient, googleSheetsIntegration } from "integrate-sdk";

const customClient = createMCPClient({
  integrations: [googleSheetsIntegration()],
});
```

## Configuration Options

<AutoTypeTable
  path="../src/integrations/google_sheets.ts"
  name="GSheetsIntegrationConfig"
/>


## Tools

### `google_sheets_append_values`

Sheets append values

<AutoTypeTable
  path="generated/tool-params/google_sheets.ts"
  name="GoogleSheetsAppendValuesParams"
/>

### `google_sheets_batch_update`

Sheets batch update

<AutoTypeTable
  path="generated/tool-params/google_sheets.ts"
  name="GoogleSheetsBatchUpdateParams"
/>

### `google_sheets_batch_update_values`

Sheets batch update values

<AutoTypeTable
  path="generated/tool-params/google_sheets.ts"
  name="GoogleSheetsBatchUpdateValuesParams"
/>

### `google_sheets_clear_values`

Sheets clear values

<AutoTypeTable
  path="generated/tool-params/google_sheets.ts"
  name="GoogleSheetsClearValuesParams"
/>

### `google_sheets_create`

Sheets create

<AutoTypeTable
  path="generated/tool-params/google_sheets.ts"
  name="GoogleSheetsCreateParams"
/>

### `google_sheets_delete`

Sheets delete

<AutoTypeTable
  path="generated/tool-params/google_sheets.ts"
  name="GoogleSheetsDeleteParams"
/>

### `google_sheets_get`

Sheets get

<AutoTypeTable
  path="generated/tool-params/google_sheets.ts"
  name="GoogleSheetsGetParams"
/>

### `google_sheets_get_values`

Sheets get values

<AutoTypeTable
  path="generated/tool-params/google_sheets.ts"
  name="GoogleSheetsGetValuesParams"
/>

### `google_sheets_list`

Sheets list

<AutoTypeTable
  path="generated/tool-params/google_sheets.ts"
  name="GoogleSheetsListParams"
/>

### `google_sheets_update_values`

Sheets update values

<AutoTypeTable
  path="generated/tool-params/google_sheets.ts"
  name="GoogleSheetsUpdateValuesParams"
/>

## Notes

- Category: Productivity
- Authentication mode: OAuth