Blocks
Smartsheet
Spreadsheet-style project management and collaboration
Integrate with Smartsheet to manage sheets, rows, columns, automate workflows, create reports, and collaborate on projects. Perfect for teams handling complex projects with OAuth 2.0 authentication.
Block Preview
Smartsheet
Spreadsheet-style project management and collaboration
Usage
- Add the block to your workflow and connect it to the upstream step.
- Connect the required credentials or OAuth provider before running.
- Fill in required inputs and optional parameters for the run.
- Run a test execution, inspect outputs, and iterate before deploying.
- Deploy the smartsheet block with monitoring enabled in production.
Inputs (UI)
Smartsheet Account
oauth-inputPlaceholder: Select Smartsheet account
Layout: full
Provider: smartsheet
Operation
dropdownLayout: full
Options: List Sheets, Get Sheet, Create Sheet, Add Row
Sheet ID
short-inputPlaceholder: Enter sheet ID
Layout: full
Condition: operation = ["get_sheet","add_row","update_row","delete_row","add_column","share_sheet"]
Sheet Name
short-inputPlaceholder: My Project Sheet
Layout: full
Condition: operation = "create_sheet"
Row ID
short-inputPlaceholder: Enter row ID
Layout: full
Condition: operation = ["update_row","delete_row"]
Column Title
short-inputPlaceholder: Column name
Layout: full
Condition: operation = "add_column"
Column Type
dropdownLayout: half
Condition: operation = "add_column"
Options: Text/Number, Date, Checkbox, Dropdown List
Cell Values (JSON)
long-inputPlaceholder: {"Column1": "Value1", "Column2": "Value2"}
Layout: full
Condition: operation = ["add_row","update_row"]
Share with Email
short-inputPlaceholder: user@example.com
Layout: half
Condition: operation = "share_sheet"
Access Level
dropdownLayout: half
Condition: operation = "share_sheet"
Options: Viewer, Editor, Admin
Inputs (API)
credential
stringRequired
operation
stringRequired
sheetId
stringOptional
sheetName
stringOptional
rowId
stringOptional
columnTitle
stringOptional
columnType
stringOptional
cellValues
stringOptional
Optional
accessLevel
stringOptional
Outputs
Primary response type:
{
"data": "json"
}