Smartsheet
Dynamic work & collaboration software
Start for freeCategory
Works with
AI Compatible
Tools
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
Add Row to Sheet
Adds a row to a sheet. See docs here
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
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
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
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
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
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
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
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
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
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
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
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
List Folder Options
Retrieves available folder options from a workspace. See the documentation
List Sheet Options
Retrieves available options for the Sheet field. See the documentation
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
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
List Workspace Templates
Lists templates available in your workspaces. Use this to find template IDs for **New Sheet From Template**. See the documentation
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
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
New Sheet From Template
Creates a new sheet from a template. See docs here
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
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
Update Row
Updates a row in a sheet. See docs here Return only the translated text without explanations.
Update Sheet
Update a sheet's properties such as its name. Use **List Sheets** to find the sheet ID first. See the documentation