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.

Back to Catalog
Toolssmartsheet

Block Preview

Smartsheet

Spreadsheet-style project management and collaboration

Usage

  1. Add the block to your workflow and connect it to the upstream step.
  2. Connect the required credentials or OAuth provider before running.
  3. Fill in required inputs and optional parameters for the run.
  4. Run a test execution, inspect outputs, and iterate before deploying.
  5. Deploy the smartsheet block with monitoring enabled in production.

Inputs (UI)

Smartsheet Account

oauth-input

Placeholder: Select Smartsheet account

Layout: full

Provider: smartsheet

Operation

dropdown

Layout: full

Options: List Sheets, Get Sheet, Create Sheet, Add Row

Sheet ID

short-input

Placeholder: Enter sheet ID

Layout: full

Condition: operation = ["get_sheet","add_row","update_row","delete_row","add_column","share_sheet"]

Sheet Name

short-input

Placeholder: My Project Sheet

Layout: full

Condition: operation = "create_sheet"

Row ID

short-input

Placeholder: Enter row ID

Layout: full

Condition: operation = ["update_row","delete_row"]

Column Title

short-input

Placeholder: Column name

Layout: full

Condition: operation = "add_column"

Column Type

dropdown

Layout: half

Condition: operation = "add_column"

Options: Text/Number, Date, Checkbox, Dropdown List

Cell Values (JSON)

long-input

Placeholder: {"Column1": "Value1", "Column2": "Value2"}

Layout: full

Condition: operation = ["add_row","update_row"]

Share with Email

short-input

Placeholder: user@example.com

Layout: half

Condition: operation = "share_sheet"

Access Level

dropdown

Layout: half

Condition: operation = "share_sheet"

Options: Viewer, Editor, Admin

Inputs (API)

credential

string

Required

operation

string

Required

sheetId

string

Optional

sheetName

string

Optional

rowId

string

Optional

columnTitle

string

Optional

columnType

string

Optional

cellValues

string

Optional

email

string

Optional

accessLevel

string

Optional

Outputs

Primary response type:

{
  "data": "json"
}

Tool Access

smartsheet_api
Smartsheet | NowFlow Blocks