Smartsheet

undefined

Detail	Value
Category	Project Management
Base URL	https://api.smartsheet.com/2.0
Authentication	Bearer Token
Endpoints	7
Connector key	smartsheet

Using Smartsheet in a workflow

1. Go to Connections and click New Connection.
2. Pick Smartsheet from the marketplace.
3. Enter your credentials (see Authentication above for what's expected).
4. In a workflow, drop an API Call node and select this connection.
5. Pick the operation you need from the Operation dropdown — the full list is below.

Available endpoints

Endpoint	Summary
GET	List Sheets
GET	Create Sheet
GET	Add Rows
GET	Update Rows
GET	List Columns
GET	Search Sheet
GET	List Reports

Each endpoint is documented in full below. Use the outline on the right to jump to one.

GET

List Sheets

Detail	Value
Operation ID	list_sheets_0
Method	GET
Path	``

Parameters

No parameters.

Using this endpoint in a workflow

1. Add an API Call node to your workflow.
2. Pick your Smartsheet connection from the Connection dropdown.
3. In the Operation dropdown, select list_sheets_0.
4. Fill in the parameter fields that appear. Use {{...}} to reference upstream values.

What it returns

The API Call node writes the response to the workflow context:

{
  status: 200,
  success: true,
  data: { ...response body from the API... },
  latencyMs: 142
}

Reference response fields downstream as {{nodeId.data.path}}. The exact response shape is documented on the upstream Smartsheet API reference.

GET

Create Sheet

Detail	Value
Operation ID	create_sheet_1
Method	GET
Path	``

Parameters

No parameters.

Using this endpoint in a workflow

1. Add an API Call node to your workflow.
2. Pick your Smartsheet connection from the Connection dropdown.
3. In the Operation dropdown, select create_sheet_1.
4. Fill in the parameter fields that appear. Use {{...}} to reference upstream values.

What it returns

The API Call node writes the response to the workflow context:

{
  status: 200,
  success: true,
  data: { ...response body from the API... },
  latencyMs: 142
}

Reference response fields downstream as {{nodeId.data.path}}. The exact response shape is documented on the upstream Smartsheet API reference.

GET

Add Rows

Detail	Value
Operation ID	add_rows_2
Method	GET
Path	``

Parameters

No parameters.

Using this endpoint in a workflow

1. Add an API Call node to your workflow.
2. Pick your Smartsheet connection from the Connection dropdown.
3. In the Operation dropdown, select add_rows_2.
4. Fill in the parameter fields that appear. Use {{...}} to reference upstream values.

What it returns

The API Call node writes the response to the workflow context:

{
  status: 200,
  success: true,
  data: { ...response body from the API... },
  latencyMs: 142
}

Reference response fields downstream as {{nodeId.data.path}}. The exact response shape is documented on the upstream Smartsheet API reference.

GET

Update Rows

Detail	Value
Operation ID	update_rows_3
Method	GET
Path	``

Parameters

No parameters.

Using this endpoint in a workflow

1. Add an API Call node to your workflow.
2. Pick your Smartsheet connection from the Connection dropdown.
3. In the Operation dropdown, select update_rows_3.
4. Fill in the parameter fields that appear. Use {{...}} to reference upstream values.

What it returns

The API Call node writes the response to the workflow context:

{
  status: 200,
  success: true,
  data: { ...response body from the API... },
  latencyMs: 142
}

Reference response fields downstream as {{nodeId.data.path}}. The exact response shape is documented on the upstream Smartsheet API reference.

GET

List Columns

Detail	Value
Operation ID	list_columns_4
Method	GET
Path	``

Parameters

No parameters.

Using this endpoint in a workflow

1. Add an API Call node to your workflow.
2. Pick your Smartsheet connection from the Connection dropdown.
3. In the Operation dropdown, select list_columns_4.
4. Fill in the parameter fields that appear. Use {{...}} to reference upstream values.

What it returns

The API Call node writes the response to the workflow context:

{
  status: 200,
  success: true,
  data: { ...response body from the API... },
  latencyMs: 142
}

Reference response fields downstream as {{nodeId.data.path}}. The exact response shape is documented on the upstream Smartsheet API reference.

GET

Search Sheet

Detail	Value
Operation ID	search_sheet_5
Method	GET
Path	``

Parameters

No parameters.

Using this endpoint in a workflow

1. Add an API Call node to your workflow.
2. Pick your Smartsheet connection from the Connection dropdown.
3. In the Operation dropdown, select search_sheet_5.
4. Fill in the parameter fields that appear. Use {{...}} to reference upstream values.

What it returns

The API Call node writes the response to the workflow context:

{
  status: 200,
  success: true,
  data: { ...response body from the API... },
  latencyMs: 142
}

Reference response fields downstream as {{nodeId.data.path}}. The exact response shape is documented on the upstream Smartsheet API reference.

GET

List Reports

Detail	Value
Operation ID	list_reports_6
Method	GET
Path	``

Parameters

No parameters.

Using this endpoint in a workflow

1. Add an API Call node to your workflow.
2. Pick your Smartsheet connection from the Connection dropdown.
3. In the Operation dropdown, select list_reports_6.
4. Fill in the parameter fields that appear. Use {{...}} to reference upstream values.

What it returns

The API Call node writes the response to the workflow context:

{
  status: 200,
  success: true,
  data: { ...response body from the API... },
  latencyMs: 142
}

Reference response fields downstream as {{nodeId.data.path}}. The exact response shape is documented on the upstream Smartsheet API reference.