Smartsheet
Project ManagementGive AI agents full control of Smartsheet: 49 actions covering sheets, rows, columns, attachments, discussions, workspaces, reports, search, and webhooks, including exporting sheets and downloading attachments straight to FlowRunner file storage.
What This Integration Enables
Smartsheet wins in companies where the real operational system is a grid with owners, dates, and attachments, and the recurring failure is that humans are the sync mechanism. This connector replaces that job. With 49 actions, FlowRunner agents run the full surface: append and update rows with precise cell targeting, move and copy rows across sheets, manage columns, attach files and links, run discussions, provision workspaces and folders, read cross-sheet reports, search everything, export sheets to Excel, PDF, or CSV straight into FlowRunner file storage, and register webhooks so sheets can start flows instead of just receiving from them. Two capabilities deserve the emphasis. Create Update Request turns status collection into a system: recipients fill a form scoped to exactly the rows and columns you chose, without needing a license. And Get Cell History makes the grid auditable, every value a cell has held, with who and when. A tracker that fills itself and can prove its own history is an operations tool, not a spreadsheet.
Without FlowRunner
With FlowRunner
Use Case Scenarios
Intake without a gatekeeper
Form submissions and CRM records append to the intake sheet through Add Rows as they arrive. The agent fires Create Update Request to each row's owner for the fields only they know, and answers land directly in the cells. A daily sweep with Search Sheet flags rows whose required columns are still empty, and the follow-up nudge lands as a Create Discussion on Row comment instead of another email thread nobody can find later.
The reporting pack that assembles itself
Every Friday, Get Report pulls the cross-sheet portfolio roll-up, the agent writes the summary to the ops dashboard in [Google Sheets](/integrations/google-sheets), and Export Sheet produces the board-ready PDF, saved to FlowRunner file storage with a stable link that goes out through [Gmail](/integrations/gmail-service). When an executive asks why a milestone moved, Get Cell History answers with the exact change, its author, and its date, and the answer posts to [Slack](/integrations/slack) in minutes.
Sheets that trigger work, not just record it
Create Webhook registers a callback on the master tracker and Set Webhook Status completes the verification handshake. From then on, sheet edits start flows: a status cell flipped to Blocked opens an escalation, a new row in the vendor sheet kicks off onboarding, an attachment added to a compliance row gets pulled by Download Attachment into FlowRunner file storage before Smartsheet's two-minute URLs expire. The grid stops being where work is written down and becomes where work starts.
Human-in-Loop Highlight
Delete Sheet is unusual among destructive operations for what it lacks: a net. The API deletes the sheet with every row, attachment, and discussion, and it does not go to a trash folder; there is no restore window. Delete Column is its quieter sibling, removing a column and all its cell data across every row. Both belong in cleanup flows and neither belongs to an agent's judgment. When a workspace consolidation runs, the agent stages the evidence per candidate sheet: last modified date from List Sheets, row count, an Export Sheet archive already saved to file storage as insurance. The operations owner reviews the list and approves each deletion by name. Only then do the deletes execute. The archive step is automation being careful; the approval is a person deciding, because the API offers no second chance to.
Agent Capabilities
49 actionsSheets
8- List Sheets Lists accessible sheets with IDs, access levels, and timestamps, filterable by modification date.
- Get Sheet Retrieves a sheet's columns and rows with cell values, with row filtering, column trimming, and optional attachments and discussions.
- Create Sheet Creates a sheet from a name and column list with one primary column.
- Copy Sheet Copies a sheet to a folder or workspace, optionally including data, attachments, and discussions.
- Move Sheet Moves a sheet to a folder, workspace, or home.
- Update Sheet Renames a sheet or updates its user settings.
- Delete Sheet Permanently deletes a sheet with no trash recovery. The operation this page's human gate exists for.
- Export Sheet Exports to Excel, PDF, or CSV saved in FlowRunner file storage with a download URL.
Rows
7- Add Rows Appends or positions rows with cells keyed by column ID. The intake write.
- Update Rows Changes listed cells on existing rows, leaving others untouched.
- Get Row Retrieves one row's cells, hierarchy, and timestamps, with optional rich cell data.
- Delete Rows Permanently deletes rows with their attachments and discussions, skipping already-deleted IDs by default.
- Move Rows to Another Sheet Moves rows between compatible sheets, children included, returning ID mappings.
- Copy Rows to Another Sheet Copies rows to another sheet, originals intact, returning ID mappings.
- Get Cell History Retrieves every value a cell has held with author and timestamp. The audit answer.
Columns
5- List Columns Lists a sheet's columns with IDs, types, and picklist options.
- Get Column Retrieves one column's definition and validation flag.
- Add Column Adds a typed column at a position, with picklist options and validation.
- Update Column Changes a column's title, type, position, options, or validation.
- Delete Column Permanently deletes a column and all its cell data. Runs only with review.
Attachments
6- List Attachments Lists sheet, row, and comment attachments with type, size, and creator.
- Attach URL to Row Attaches a web link to a row's attachments panel.
- Attach File to Row Uploads a FlowRunner file as a row attachment.
- Get Attachment Retrieves attachment metadata with a download URL that expires in about two minutes.
- Download Attachment Saves an attachment's bytes to FlowRunner file storage with a stable URL. The right choice when a later step needs the file.
- Delete Attachment Permanently deletes an attachment, all versions included.
Discussions
5- List Discussions Lists sheet and row discussions, optionally with full comment threads.
- Create Discussion on Row Starts a thread on a row with an initial comment.
- Create Discussion on Sheet Starts a sheet-level thread not tied to a row.
- Add Comment Adds a comment to an existing thread.
- Delete Discussion Permanently deletes a thread with its comments and attachments.
Workspaces and Folders
6- List Workspaces Lists accessible workspaces with access levels.
- Get Workspace Retrieves a workspace's sheets, folders, reports, and dashboards, optionally fully nested.
- Create Workspace Creates an empty workspace. The provisioning step for new programs.
- List Home Folders Lists folders in the user's personal Sheets area.
- Get Folder Retrieves a folder's contents in home or workspaces.
- Create Folder in Workspace Creates a top-level folder in a workspace.
Reports
2- List Reports Lists accessible cross-sheet reports.
- Get Report Retrieves a report's aggregated rows, each tagged with its source sheet.
Search
2- Search Sheet Full-text search within one sheet, returning row matches ready for Get Row.
- Search Everything Full-text search across all accessible content, scoped by type. The entry point when you only have a keyword.
Users and Contacts
3- Get Current User Retrieves the token owner's profile and account flags. The connection check.
- List Users Lists the organization's users, for admins.
- List Contacts Lists the user's personal contacts, valid for contact columns and update-request recipients.
Update Requests
1- Create Update Request Emails recipients a form scoped to chosen rows and columns, no license needed. The status-collection engine.
Webhooks
4- List Webhooks Lists the user's webhooks with scope, callback, and status.
- Create Webhook Registers a callback for all changes on a sheet, created disabled pending verification.
- Set Webhook Status Enables or disables a webhook, driving the challenge handshake that must echo back before events flow.
- Delete Webhook Permanently deletes a webhook and stops its deliveries immediately.
Frequently Asked Questions
What can FlowRunner do with Smartsheet?
FlowRunner agents can run List Sheets, Get Sheet, and Create Sheet in Smartsheet, plus 46 more actions.
Does connecting Smartsheet to FlowRunner require OAuth?
No. Smartsheet connects to FlowRunner with an API key, no OAuth flow required.
Can Smartsheet trigger a FlowRunner workflow automatically?
Smartsheet doesn't currently expose triggers in FlowRunner. It connects as an action step inside workflows started by another trigger.
Start building with Smartsheet
$100 in credits. No card required. Connect in minutes.