Arlet
Smartsheet

Connect Smartsheet to Codex

Search, read and write Smartsheet from Codex. Arlet links the two through one MCP connection and takes care of keys and authentication.

Enable Smartsheet in ArletCodex connection guide (docs)

Use Smartsheet's official MCP server from the AI services you already use, through Arlet. Set a Smartsheet API access token and the connection is ready.

From searching workspaces and reading sheets to adding and updating rows, reading reports, replying to discussions and reviewing automated workflows, your AI can do it all. What it can read and write matches the Smartsheet permissions of the user who issued the token. Business, Enterprise and Advanced Work Management plans are covered, and the connection targets accounts in the US region (mcp.smartsheet.com).

How to connect Smartsheet to Codex

  1. 1

    In the Arlet dashboard, open Integrations → Add an integration and choose Smartsheet. Set your Smartsheet API key, name the connection and click Create.

  2. 2

    In your terminal, run codex mcp add arlet --url https://mcp.arlet.dev/mcp/ to add Arlet as an MCP server.

  3. 3

    Codex detects OAuth support and opens your browser. Sign in with Google and click Allow on the consent screen.

  4. 4

    Once connected, both the CLI and the IDE extension can call Arlet tools (the configuration is shared).

If the browser does not open, run codex mcp login arlet to redo the authentication.

What you can do

Smartsheet tools that Codex can call.

  • search

    Search sheets, reports, dashboards, folders and workspaces by name or content.

  • list_workspaces

    List the workspaces you can access.

  • browse_workspace

    List the sheets, reports, dashboards and folders at the top of a workspace.

  • get_sheet_summary

    Read sheet data with optional filtering, sorting and column selection.

  • find_in_sheet

    Search for text inside a sheet and return matching cells.

  • get_columns

    Get a sheet's columns with their types and settings.

  • add_rows

    Add rows to a sheet.

  • update_rows

    Update many rows and cells in one operation.

  • get_cell_history

    Read the change history of a cell.

  • create_sheet

    Create a blank sheet or one from a template.

  • get_report

    Read a report's columns, rows and cells.

  • list_discussions

    Read the discussions and comments on a sheet or row.

  • add_comment

    Reply to a discussion.

  • get_workflows

    List the automated workflows attached to a sheet.

The tool list follows what Smartsheet's official MCP server provides and may change.

Example uses

  • Surface overdue work

    Pull overdue and not-started tasks out of a WBS sheet, group them by owner and prepare the weekly status meeting.

  • Update progress in bulk

    Apply the status and due-date changes agreed in a meeting to every affected row at once.

  • Read a portfolio report

    Summarize the highest-risk projects, and why, from a report that rolls up several sheets.

  • Trace a change

    Check when and by whom a specific cell changed and explain the history behind a decision.

Prompts you can use as-is

  • In the 'Product Launch' sheet, list the overdue tasks grouped by owner
  • From the PMO report, list the projects with a red status and the reasons
  • Push the phase 2 tasks in the 'Migration Plan' sheet out by two weeks
  • Who last changed the total cell in the 'Budget' sheet, and when?

Use Smartsheet with other AI clients