Google Sheets Integration

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:

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

Setup

1. Create a Google Sheets OAuth App

1. Go to Google Cloud Console
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:

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:

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:

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:

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

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

Configuration Options

Tools

google_sheets_append_values

Sheets append values

google_sheets_batch_update

Sheets batch update

google_sheets_batch_update_values

Sheets batch update values

google_sheets_clear_values

Sheets clear values

google_sheets_create

Sheets create

google_sheets_delete

Sheets delete

google_sheets_get

Sheets get

google_sheets_get_values

Sheets get values

google_sheets_list

Sheets list

google_sheets_update_values

Sheets update values

Notes

• Category: Productivity
• Authentication mode: OAuth