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

[email protected], [email protected]

Output

{
  "mcl-output": {
    "values": [
      { "email": "[email protected]" },
      { "email": "[email protected]" }
    ]
  }
}

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": "[email protected]" },
    { "email": "[email protected]" }
  ]
}

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