Smartsheet
Turn requests and orders into Smartsheet work, and keep status in step across your tools.
31 ways to read, 12 ways to write, each write switched on by you.
Quality checks
Built and tested with example responses.
- Ready to connect: doneEvery listed action is built in.
- Built and tested with example responses: doneEach action is built from the provider’s published API and tested against example responses, errors, rate limits and paging.
Connected, approved, proven.
The things teams do most with Smartsheet, an example flow with a person in the loop, and what Nexra keeps as proof.
Top actions
- Attach link to rowApproval by rule
- Add columnApproval by rule
- List report rowsRead
Example flow
- Smartsheet · List report rowsDone
- Smartsheet · Attach link to rowNeeds approval
- Nexra · Record the decision and result in the evidence chainProven
Example workflow. Routine runs go through on their own. Only a change your rules flag, such as one over a limit you set, waits for the right person, who sees the exact change and the rule before it reaches Smartsheet.
What gets logged
- Whether it ran on its own or who approved it, and under which rule
- A fingerprint of the exact request sent to Smartsheet
- Smartsheet's reply: what it created or changed
- One entry in the evidence chain, linked to the one before
Try this in the sandbox
Run the whole flow with test data in your sandbox, then connect your own account when you are ready to go live.
For developers
Technical detail
Read and write Smartsheet workspaces, folders, sheets, columns and rows with column-title mapping; read reports, dashboards, cell history, discussions, webhooks, users and groups.
Smartsheet Inc. API docs- Source actions
- 31
- Destination actions
- 12
- Data types
- 20
What you can map
Reads are always available. Writes are off until you switch them on for a connection, and governed writes follow your policies.
Attachments3
- Attach link to rowDestinationNot retried automaticallyApproval before production
Attaches a URL (link) to a row. File uploads are not supported.
- Get attachmentSource
Attachment metadata. The temporary download link is not returned.
- List attachmentsSource
Attachment metadata on a sheet, or on one row when a row ID is given.
Cell history1
- List cell historySource
Previous values of one cell with who changed them and when.
Columns4
- Add columnDestinationNot retried automaticallyApproval before production
Adds a column to a sheet at a position.
- Get columnSource
One column with its type, options and formula.
- List columnsSource
Columns of a sheet with IDs, titles and types, for mapping row cells.
- Update columnDestinationProvider duplicate protectionApproval before production
Renames, moves, retypes or changes the options of a column.
Comments2
- Add commentDestinationNot retried automaticallyApproval before production
Adds a comment to an existing discussion.
- Edit commentDestinationProvider duplicate protectionApproval before production
Replaces the text of a comment the token owner wrote.
Current user1
- Get current userSource
The token owner's profile and account.
Discussions3
- Start discussionDestinationNot retried automaticallyApproval before production
Starts a discussion with a first comment on a row, or on the sheet when no row is given.
- Get discussionSource
One discussion with all its comments.
- List discussionsSource
Discussions on a sheet or a row, including their comments.
Folder children1
- List folder contentsSource
Sheets, reports, dashboards and folders directly inside a folder.
Folders2
- Create folderDestinationNot retried automaticallyApproval before production
Creates a folder in a workspace or inside another folder.
- Get folderSource
Folder metadata.
Groups2
- Get groupSource
One group with its members.
- List groupsSourceIncremental
Groups in the organisation account, optionally modified since a time.
Report rows1
- List report rowsSource
Rows of a report with cells keyed by report column title; each row keeps its source sheet ID.
Reports2
- Get reportSource
Report metadata with its columns and total row count.
- List reportsSourceIncremental
Reports the token owner can access, optionally modified since a time.
Rows5
- Add rowDestinationNot retried automaticallyApproval before production
Adds a row at the top or bottom of the sheet, as a child of a parent row, or next to a sibling row.
- Get rowSource
A single row with its cells keyed by column title.
- List rowsSourceIncremental
Rows of a sheet with cells keyed by column title and by column ID, optionally only rows modified since a time.
- Search sheetSource
Finds rows, discussions and attachments in a sheet that match text.
- Update rowDestinationProvider duplicate protectionApproval before production
Updates cells of an existing row, or moves it under a new parent row.
Search1
- Search everythingSource
Searches sheets, reports, dashboards, rows, discussions and attachments the token owner can see.
Sheet summary fields1
- List sheet summary fieldsSource
Sheet summary fields (title, type, value and formula).
Sheets4
- Create sheetDestinationNot retried automaticallyApproval before production
Creates a sheet with columns in a workspace or folder. Exactly one column must be primary.
- Get sheetSource
Sheet metadata with its columns, row count, owner and version (rows are read with List rows).
- List sheetsSourceIncremental
Sheets the token owner can access, optionally modified since a time.
- Rename sheetDestinationProvider duplicate protectionApproval before production
Renames a sheet.
Sights2
- Get dashboardSource
One dashboard with its widgets.
- List dashboardsSource
Dashboards (sights) the token owner can access.
Users2
- Get userSource
One user's profile (requires a system administrator token).
- List usersSource
Users in the organisation account (requires a system administrator token).
Webhooks2
- Get webhookSource
One webhook with its scope, events and status.
- List webhooksSource
Webhooks owned by the token owner (shared secrets are never returned).
Workspace children1
- List workspace contentsSource
Sheets, reports and folders directly inside a workspace.
Workspaces3
- Create workspaceDestinationNot retried automaticallyApproval before production
Creates an empty workspace owned by the token owner.
- Get workspaceSource
Workspace metadata (name, access level, permalink).
- List workspacesSource
Workspaces visible to the token owner.
Access and limits
- Authentication
- Smartsheet API access token
- Plans and access
- Smartsheet Business and Enterprise plans (the API is restricted to these plans). Access follows the sharing permissions of the user who owns the access token.
- Test environment
- Use a Smartsheet trial or a developer account; there is no separate sandbox host.
- Rate limits
- 300 requests per minute per token; file attachments and cell history count 10x. HTTP 429 on excess.
- Pagination
- page/pageSize with totalPages for sheets, columns, discussions, attachments, cell history, webhooks, groups and users; sheet and report rows page by totalRowCount; workspaces, folder contents and dashboards use maxItems/lastKey tokens.
- Provider events
- Smartsheet webhooks with callback verification and HMAC signatures. Flows run on demand, on a schedule, or when a scheduled check finds new or changed records.
Before you build a flow
- Row writes take column IDs. Reads return cells keyed by column title as well as by column ID; map titles to IDs with List columns.
- Smartsheet Gov (api.smartsheetgov.com) is not offered.
- Attachment metadata is read and URL attachments can be added; file uploads and downloads are not transferred.
- Smartsheet has no idempotency key; uncertain row additions are not repeated automatically.
- Deletes of any kind, sharing, automation rules, update requests, proofs, publishing, copy and move are not implemented (intentional exclusions).
- Attachment reads return metadata only; Smartsheet's temporary download URL is never returned.
- Webhooks are read-only and their shared secrets are never returned; creating, enabling or resetting webhooks is not implemented.
- Cell history calls count as 10 requests against the 300-per-minute limit.
- Report rows map cells by virtual column ID onto report column titles; report rows cannot be written (write to the source sheet).
- The reports list endpoint is documented without paging parameters, so it is read as one page. Global search returns at most 100 results.
- Users and groups lists, and user reads, need a system administrator token; members are returned on Get group only.
Developer reference
- Create the Smartsheet Inc. credentials described above with the narrowest permissions your flows need.
- In Nexra, open Connect, then Connections, then New connection, choose Smartsheet, enter its settings and credentials, and tick only the write actions you need. Connection guide
- Test the connection, then use its actions as flow sources and destinations. Flow guide
Machine-readable detail: GET /api/public/connect/connectors/smartsheet and the Connections API.