# Smartsheet MCP Integration

> Software dinámico de trabajo & colaboración

## Overview

| Property | Value |
|----------|-------|
| Category | Productividad |
| Type | PIPEDREAM |
| Tools | 27 |
| URL | https://jelou.ai/es/marketplace/smartsheet |

## Available Tools (27)

### Add Column

Add a new column to a sheet. Specify the column title, type, and optionally the position and picklist options. For PICKLIST columns, provide the `options` array with valid values. Use **List Columns** to see existing columns before adding. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/columns/columns-addtosheet)

### Agregar fila a la hoja

Añade una fila a una hoja. [Ver la documentación aquí](https://smartsheet.redoc.ly/tag/rows#operation/rows-addToSheet)

### Copy Rows

Copy one or more rows from a source sheet to a destination sheet. The rows remain in the source sheet and are duplicated in the destination. Cell values, formatting, and attachments are copied. The destination sheet must have compatible columns. Use **Get Sheet** to find row IDs in the source sheet. To move rows instead (removing them from the source), use **Move Rows**. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/rows/copy-rows)

### Copy Sheet

Copy an existing sheet to a new location. Creates a complete duplicate including all rows, columns, formatting, and attachments. Specify a destination workspace or folder, or omit both to copy to the user's home (Sheets folder). Returns the new sheet's ID and permalink. Use **List Sheets** to find the source sheet ID. To move a sheet instead (removing it from the original location), use **Move Sheet**. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/sheets/copy-sheet)

### Create Sheet

Create a new blank sheet with column definitions in a workspace or folder. Columns array defines the schema — each column needs a `title` and `type`. Supported column types: TEXT_NUMBER, DATE, DATETIME, CONTACT_LIST, CHECKBOX, PICKLIST, DURATION, PREDECESSOR, ABSTRACT_DATETIME. For PICKLIST columns, include an `options` array with the valid values. You must provide either a Workspace ID or Folder ID — the home-level create endpoint is deprecated. Use **List Sheets** to verify the sheet was created. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/sheets/create-sheet-in-workspace)

### Delete Column

Permanently delete a column from a sheet. WARNING: This is irreversible — all cell data in the column is permanently destroyed. Use **List Columns** to find the column ID before deleting. Consider using **Get Sheet** to review the column's data before deletion. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/columns/column-delete)

### Delete Rows

Delete one or more rows from a sheet by row ID. This is permanent and cannot be undone. Use **Get Sheet** or **Search** to find row IDs first. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/rows/delete-rows)

### Delete Sheet

Permanently delete a sheet. This is irreversible — all data, rows, and columns are destroyed. Use **List Sheets** to find the sheet ID first. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/sheets/deletesheet)

### Email Sheet

Send a sheet as an email attachment to one or more recipients. The sheet can be sent as PDF, Excel, or PDF Gantt format. Use **List Sheets** to find the sheet ID. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/sheets/sheet-send)

### Get Current User

Get the authenticated user's identity — returns user ID, email, first/last name, and account details. Use this when the user says 'my sheets' or 'my account' to identify the owner. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/users/get-current-user)

### Get Row

Retrieve a single row from a sheet by row ID, with cell values keyed by column name instead of column ID. Returns a human-readable object like `{"Species": "Velociraptor", "Status": "Monitoring"}` plus row metadata. When a cell has a displayValue (formatted date, contact name), that is returned instead of the raw value. Use **Get Sheet** or **Search** to find row IDs. To update a row after reading it, use **Update Row**. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/rows/row-get)

### Get Sheet

Get a sheet's full structure: column definitions (name, type, options, ID), all rows with cell values, and sheet metadata. This is the primary schema discovery tool — call it BEFORE **Add Row to Sheet** or **Update Row** to learn column names, types, and IDs. Returns rows with cell values keyed by column name for readability. For a lightweight column-only view, use **List Columns** instead. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/sheets/getsheet)

### Import Sheet

Import a CSV or XLSX file as a new Smartsheet sheet in a workspace or folder. The file's first row becomes column headers by default (adjust with Header Row Index). You must provide either a Workspace ID or Folder ID — the home-level import endpoint is deprecated. Supported formats: CSV (.csv) and Excel XLSX (.xlsx). Use **List Sheets** to verify the sheet was created after import. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/imports/import-sheet-into-workspace)

### List Columns

List all columns in a sheet, returning each column's ID, title, type, options (for PICKLIST/CONTACT_LIST), validation, and position index. This is lighter-weight than **Get Sheet** when you only need the column schema and not row data. Use this before **Add Row to Sheet** or **Update Row** to discover column names and types. For full sheet data including rows, use **Get Sheet** instead. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/columns/columns-listonsheet)

### List Folder Options

Retrieves available folder options from a workspace. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/workspaces/get-workspace-children)

### List Sheet Options

Retrieves available options for the Sheet field. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/sheets/list-sheets)

### List Sheets

List all sheets the authenticated user can access, with name, ID, creation/modification dates, owner, and permalink. Use this to find sheet IDs before calling **Get Sheet**, **Add Row to Sheet**, **Update Row**, **Delete Rows**, **Copy Sheet**, or **Move Sheet**. To search sheets by content rather than listing them, use **Search** instead. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/sheets/list-sheets)

### List Template ID Options

Retrieves available options for the Template ID field.

### List Workspace Options

Retrieves available options for the Workspace field using token-based pagination. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/workspaces/list-workspaces)

### List Workspace Templates

Lists templates available in your workspaces. Use this to find template IDs for **New Sheet From Template**. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/workspaces/get-workspace-children)

### Move Rows

Move one or more rows from a source sheet to a destination sheet. WARNING: Rows are permanently removed from the source sheet. Cell values, formatting, and attachments are transferred. The destination sheet must have compatible columns. Use **Get Sheet** to find row IDs in the source sheet. To copy rows instead (keeping them in the source), use **Copy Rows**. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/rows/move-rows)

### Move Sheet

Move a sheet to a different workspace, folder, or home. The sheet is removed from its current location. As of 2025-12-23, `destinationType` is required. Use **List Sheets** to find the sheet ID. To copy a sheet instead (keeping the original), use **Copy Sheet**. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/sheets/move-sheet)

### Nueva hoja desde plantilla

Crea una nueva hoja a partir de una plantilla. [Consulte la documentación aquí](https://smartsheet.redoc.ly/tag/sheets#operation/create-sheet-in-sheets-folder)

### Search

Full-text search across all sheets or within a specific sheet. Returns matching rows, cells, and sheet names with context. To find a sheet by name, use **List Sheets** instead — this tool searches content within sheets. Provide a `sheetId` to scope the search to a single sheet, or omit it to search globally. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/search/list-search)

### Update Column

Update a column's title, type, or position in a sheet. Use **List Columns** to find the column ID and current properties before updating. Note: some type conversions may cause data loss. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/columns/column-updatecolumn)

### Actualizar fila

Actualiza una fila en una hoja. [Ver la documentación aquí](https://smartsheet.redoc.ly/tag/rows#operation/update-rows)

### Update Sheet

Update a sheet's properties such as its name. Use **List Sheets** to find the sheet ID first. [See the documentation](https://developers.smartsheet.com/api/smartsheet/openapi/sheets/updatesheet)

## Supported Channels

This integration works with:
- WhatsApp Business API
- Facebook Messenger
- Instagram Direct Messages
- Web Chat Widget

## AI Assistants Compatible

- ChatGPT (via MCP)
- Claude (via MCP)
- Gemini (via MCP)
- Custom AI Agents

## Quick Start

1. Sign up at https://apps.jelou.ai/signup
2. Navigate to Marketplace and add Smartsheet
3. Authenticate your Smartsheet account
4. Configure your messaging channels (WhatsApp, Facebook, etc.)
5. Copy the MCP server URL to your AI assistant

## Example Use Cases

- Automate customer inquiries using Smartsheet data
- Send notifications via WhatsApp when Smartsheet events occur
- Query Smartsheet data directly from ChatGPT or Claude
- Build AI agents that interact with Smartsheet

## Resources

- [All Integrations](https://jelou.ai/es/marketplace)
- [Full Documentation](https://jelou.ai/llms-full.txt)
- [API Docs](https://docs.jelou.ai)
- [Help Center](https://help.jelou.ai)