# Smartsheet

Manage Smartsheet: sheets, rows, columns, reports, attachments, webhooks. Exposes **36 actions** covering the full API surface
the agent needs - read and write.

## What it can do

| Method | What it does |
| --- | --- |
| `smartsheet_list_workspaces` | List all workspaces - GET /workspaces. |
| `smartsheet_get_workspace` | Get one workspace - GET /workspaces/{id}. |
| `smartsheet_list_folders` | List folders in a workspace - GET /workspaces/{id}/folders. |
| `smartsheet_get_folder` | Get one folder - GET /folders/{id}. |
| `smartsheet_create_folder` | Create a folder - POST /folders. |
| `smartsheet_update_folder` | Update a folder - PUT /folders/{id}. |
| `smartsheet_delete_folder` | Delete a folder - DELETE /folders/{id}. |
| `smartsheet_list_sheets` | List all sheets - GET /sheets. |
| `smartsheet_get_sheet` | Get one sheet - GET /sheets/{id}. |
| `smartsheet_create_sheet` | Create a sheet - POST /sheets. |
| `smartsheet_update_sheet` | Update a sheet - PUT /sheets/{id}. |
| `smartsheet_delete_sheet` | Delete a sheet - DELETE /sheets/{id}. |
| `smartsheet_get_sheet_columns` | Get all columns for a sheet - GET /sheets/{id}/columns. |
| `smartsheet_create_column` | Create a column - POST /sheets/{id}/columns. |
| `smartsheet_update_column` | Update a column - PUT /sheets/{id}/columns/{columnId}. |
| `smartsheet_delete_column` | Delete a column - DELETE /sheets/{id}/columns/{columnId}. |
| `smartsheet_list_rows` | List rows in a sheet - GET /sheets/{id}/rows. |
| `smartsheet_get_row` | Get one row - GET /sheets/{id}/rows/{rowId}. |
| `smartsheet_add_rows` | Add rows to a sheet - POST /sheets/{id}/rows. |
| `smartsheet_update_rows` | Update rows - PUT /sheets/{id}/rows. |
| `smartsheet_delete_rows` | Delete rows - DELETE /sheets/{id}/rows?ids=1,2,3. |
| `smartsheet_copy_rows` | Copy rows to another sheet - POST /sheets/{id}/rows/copy. |
| `smartsheet_list_reports` | List all reports - GET /reports. |
| `smartsheet_get_report` | Get one report - GET /reports/{id}. |
| `smartsheet_list_attachments` | List attachments - GET /{parentType}s/{id}/attachments. |
| `smartsheet_get_attachment` | Get one attachment - GET /{parentType}s/{id}/attachments/{attachmentId}. |
| `smartsheet_add_attachment` | Add an attachment - POST /{parentType}s/{id}/attachments. |
| `smartsheet_delete_attachment` | Delete an attachment - DELETE /{parentType}s/{id}/attachments/{attachmentId}. |
| `smartsheet_list_discussions` | List discussions - GET /{parentType}s/{id}/discussions. |
| `smartsheet_create_discussion` | Create a discussion - POST /{parentType}s/{id}/discussions. |
| `smartsheet_list_shares` | List shares (permissions) - GET /{objectType}s/{id}/shares. |
| `smartsheet_add_share` | Add a share (grant permission) - POST /{objectType}s/{id}/shares. |
| `smartsheet_delete_share` | Delete a share (remove permission) - DELETE /{objectType}s/{id}/shares/{shareId}. |
| `smartsheet_list_automation_rules` | List automation rules - GET /sheets/{id}/automationrules. |
| `smartsheet_get_automation_rule` | Get one automation rule - GET /sheets/{id}/automationrules/{ruleId}. |
| `smartsheet_get_user_profile` | Get the authenticated user's profile - GET /user/profile. |

## How to get credentials

This connector uses an **API key / token**. Create one in the provider
dashboard, then paste it into FlyMyAI:

- **`SMARTSHEET_ACCESS_TOKEN`** - Smartsheet - Account - Personal Settings - API Access - Generate new access token. (https://app.smartsheet.com/)

## Fields to fill in FlyMyAI

| FlyMyAI field | Where it comes from |
| --- | --- |
| `SMARTSHEET_ACCESS_TOKEN` | Smartsheet - Account - Personal Settings - API Access - Generate new access token. |

## Troubleshooting

- **`401 Unauthorized` / `403 Forbidden`** - the token is wrong, expired, or missing a required scope - regenerate it.
- **`429 Too Many Requests`** - you hit the provider rate limit; retry after a short backoff.
- **Unexpected `4xx` on writes** - double-check required fields; the agent confirms before write actions.

## Links

- [Smartsheet API documentation](https://smartsheet.com/api/2.0)