Arthur MCPArthur MCP
Dashboard
How it worksFeaturesDocsEarly accessGitHubDashboard

How to integrate Smartsheet using MCP

Read and update Smartsheet sheets, columns, reports, and users. This guide creates an MCP server from Arthur's Smartsheet template — tools preconfigured against https://api.smartsheet.com/2.0 — and finishes by sharing the server's MCP swagger documentation.

Steps

  1. Open the Secrets vault and create a secret named SMARTSHEET_API_KEY holding your access token. Generate a personal API access token from your Smartsheet account (Personal Settings > API Access) and send it as Authorization: Bearer . OAuth2 access tokens obtained via the full authorization flow work the same way.

    Open the Secrets vault to store the Smartsheet credential before using the template

    Start the New secret wizard

    Name the secret SMARTSHEETAPIKEY — servers reference it by this name

  2. Go to the REST API Templates gallery and search for Smartsheet.

    Record what the credential is for so it stays recognizable

    Continue to the protected value step

  3. Click Use template on the Smartsheet card to open the server-creation dialog.

    Enter the credential value — a demo value here; use your real key when adopting the integration

    Review the generated secret reference syntax

  4. Review the server name and select SMARTSHEET_API_KEY in the credential field — the dialog only accepts vault secrets, and it lists every tool that will be created.

    Store the SMARTSHEETAPIKEY secret in the vault

    Open the REST API template gallery

    Search the gallery for the Smartsheet integration

  5. Click Create server. Arthur creates the server, applies the authentication, and generates all the tools.

    Open the Smartsheet template with its preconfigured tools

    Name the server after the integration it provides

    Pick the SMARTSHEETAPIKEY secret from the vault suggestions

    Select the stored credential

    Create the Smartsheet server with its preconfigured tools

  6. Open the server's Tools tab to review the generated tools.

    Review the tools generated from the Smartsheet template

  7. Open the server's Connect section and click Share the MCP swagger documentation — Arthur generates the public documentation link and QR code for this server.

    Open the server's Connect section, where the MCP endpoint and its documentation live

    Open the MCP swagger documentation share panel

    Show the generated swagger documentation link and QR code for this server

Confirm it worked

The server appears with 5 preconfigured tool(s): list_sheets, get_sheet, add_column, list_reports, list_users. The Connect section offers the MCP swagger documentation — a shareable page with setup instructions for any AI client.

Good to know

  • List and retrieve Smartsheet sheets and reports, add columns to a sheet, and list account users. Requires a Smartsheet personal API access token (Business or Enterprise plan) or an OAuth2 access token.
  • This integration requires a credential (bearer). Get one at https://app.smartsheet.com/b/signup.
  • Official API documentation: https://developers.smartsheet.com/api/smartsheet/openapi/
  • Editing a tool later never changes the template — templates are starting points, and the server is fully yours after creation.

Related

Tutorial video