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
4xxon writes - double-check required fields; the agent confirms before write actions.
Links
We love our partners - FlyMy.AI builds with the best. Thanks, Smartsheet!