steyi-ss

n8n node for Smartsheet API integration

Package Information

Downloads: 39 weekly / 710 monthly
Latest Version: 1.0.16

Available Nodes

Steyi Smartsheet icon
Steyi Smartsheet
Interact with Smartsheet API (Steyi)
Steyi Smartsheet Trigger icon
Steyi Smartsheet Trigger
Starts the workflow when Smartsheet events occur (Steyi)

Documentation

n8n-nodes-steyi-ss

Community n8n node for Smartsheet providing broad API coverage including sheets, rows, columns, webhooks, reports, admin operations, and data conversion utilities.

✨ Features

  • Full Smartsheet API coverage
  • Sheet, row, column, report, and admin operations
  • Webhook + Trigger support
  • Smart value conversion for complex column types
  • Dynamic dropdowns with caching
  • Designed for large workflows and automation

📦 Installation

npm install n8n-nodes-steyi-ss

Then enable Community Nodes in n8n and restart.

🔐 Credentials

Uses a Smartsheet API Token.

Create one here:
https://app.smartsheet.com/b/home

📚 Resources & Operations

Sheets

  • List Sheets
  • Get Sheet
  • Create Sheet
  • Update Sheet
  • Delete Sheet
  • Search Sheet

Rows

  • Add Row
  • Update Row
  • Delete Row
  • Get Row
  • Get Row (Mapped by Column Title or ID)

Supports:

  • Cell value mapping
  • Attachments (file or link)
  • Discussions
  • Parent/child row placement

Columns

  • Get Columns
  • Update Column

Includes column type metadata in dropdowns.

Webhooks

  • List Webhooks
  • Create Webhook
  • Update Webhook
  • Delete Webhook

Notes

  • Webhooks are auto-enabled
  • Callback URL must be publicly accessible
  • Defaults to subscribing to all events (*.*)

Reports

  • List Reports
  • Get Report

Admin

Users

  • List Users
  • Get User
  • Add User
  • Update User
  • Delete User

Groups

  • List Groups
  • Get Group
  • Create Group
  • Update Group
  • Delete Group

Group Members

  • List Members
  • Add Members
  • Remove Member

Converter Utilities

CSV → MULTI_CONTACT_LIST

Converts comma-separated emails into Smartsheet MCL format.

Input

email1@example.com, email2@example.com

Output

{
  "mcl-output": {
    "values": [
      { "email": "email1@example.com" },
      { "email": "email2@example.com" }
    ]
  }
}

CSV → MULTI_PICKLIST

Converts comma-separated values into MPL format.

Output

{
  "mpl-output": {
    "values": ["Option 1", "Option 2"]
  }
}

🧱 Column Value Formatting

Used when adding or updating rows.

TEXT_NUMBER / DATE / DATETIME

"Example Text"
123
"2024-01-15"

CHECKBOX

Accepted string values (auto-converted):

true, false, 1, 0, yes, no

PICKLIST

"High Priority"

Must exactly match column options (case-sensitive)

MULTI_CONTACT_LIST

{
  "values": [
    { "email": "john@example.com" },
    { "email": "jane@example.com" }
  ]
}

Automatically transformed to Smartsheet API format.

MULTI_PICKLIST

{
  "values": ["Option 1", "Option 2"]
}

⚡ Webhook Trigger Node

Steyi Smartsheet Trigger starts workflows on Smartsheet events.

Features

  • Auto-creates webhooks
  • Handles verification challenges
  • Manages lifecycle automatically
  • Subscribes to all sheet events

⚠️ Localhost Warning

Smartsheet requires a public webhook URL.

If running n8n locally:

  1. Use a tunnel (e.g. ngrok)
    ngrok http 5678
  2. Or deploy n8n publicly
  3. Or set WEBHOOK_URL to a public endpoint

🔽 Dynamic Dropdowns

Cached for 60 seconds:

  • Sheets
  • Columns (with type)
  • Users
  • Groups
  • Group Members
  • Workspaces
  • Folders
  • Webhooks
  • Discussions

Manual ID entry via expressions is always supported.

📖 Smartsheet API Docs

https://smartsheet-platform.github.io/api-docs/

🪪 License

MIT

Discussion