Smartsheet Integration

The Smartsheet integration provides access to manage Smartsheet sheets, rows, columns, workspaces, reports, and attachments through the Integrate MCP server.

Installation

The Smartsheet integration is included with the SDK:

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

Setup

1. Create a Smartsheet OAuth App

1. Create an OAuth application for Smartsheet
2. Configure your redirect URI
3. Note your Client ID and Client Secret

2. Configure the Integration on Your Server

Add the Smartsheet integration to your server configuration. The integration automatically reads SMARTSHEET_CLIENT_ID and SMARTSHEET_CLIENT_SECRET from your environment variables:

import { createMCPServer, smartsheetIntegration } from "integrate-sdk/server";

export const { client: serverClient } = createMCPServer({
  apiKey: process.env.INTEGRATE_API_KEY,
  integrations: [
    smartsheetIntegration({
      scopes: ["READ_SHEETS", "WRITE_SHEETS", "ADMIN_SHEETS", "READ_USERS", "READ_WORKSPACES", "ADMIN_WORKSPACES"], // Optional
    }),
  ],
});

You can override the environment variables by passing explicit values:

smartsheetIntegration({
  clientId: process.env.CUSTOM_SMARTSHEET_ID,
  clientSecret: process.env.CUSTOM_SMARTSHEET_SECRET,
      scopes: ["READ_SHEETS", "WRITE_SHEETS", "ADMIN_SHEETS", "READ_USERS", "READ_WORKSPACES", "ADMIN_WORKSPACES"], // Optional
});

3. Client-Side Usage

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

import { client } from "integrate-sdk";

await client.authorize("smartsheet");
const result = await client.smartsheet.listSheets({});

console.log(result);

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

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

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

Configuration Options

Default Scopes

These defaults are applied unless you override scopes in the integration config:

• READ_SHEETS
• WRITE_SHEETS
• ADMIN_SHEETS
• READ_USERS
• READ_WORKSPACES
• ADMIN_WORKSPACES

Tools

smartsheet_list_sheets

List sheets

smartsheet_get_sheet

Get sheet

smartsheet_create_sheet

Create sheet

smartsheet_add_rows

Add rows

smartsheet_update_rows

Update rows

smartsheet_list_workspaces

List workspaces

smartsheet_list_reports

List reports

smartsheet_list_attachments

List attachments

Notes

• Category: Productivity
• Authentication mode: OAuth