Smartsheet Integration

Manage Smartsheet sheets, rows, columns, workspaces, reports, and attachments

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

Create an OAuth application for Smartsheet
Configure your redirect URI
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

export interface SmartsheetIntegrationConfig {
  clientId?: string;

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

export interface SmartsheetListSheetsParams { page?: number;

`smartsheet_get_sheet`

Get sheet

export interface SmartsheetGetSheetParams { sheet_id: string;

`smartsheet_create_sheet`

Create sheet

export interface SmartsheetCreateSheetParams { sheet_json: string }

`smartsheet_add_rows`

Add rows

export interface SmartsheetAddRowsParams { sheet_id: string;

`smartsheet_update_rows`

Update rows

export interface SmartsheetUpdateRowsParams { sheet_id: string;

`smartsheet_list_workspaces`

List workspaces

export interface SmartsheetListWorkspacesParams { page?: number;

`smartsheet_list_reports`

List reports

export interface SmartsheetListReportsParams { page?: number;

`smartsheet_list_attachments`

List attachments

export interface SmartsheetListAttachmentsParams { sheet_id: string }

Notes

Category: Productivity
Authentication mode: OAuth