Smartsheet Trigger icon

Smartsheet Trigger

Starts the workflow when Smartsheet events occur

Overview

The Smartsheet Trigger node starts an n8n workflow when events occur in Smartsheet, specifically for changes related to a selected Sheet. It is useful for automating processes that need to react to updates, additions, or deletions within a Smartsheet sheet. For example, you could use this node to automatically send notifications, update databases, or trigger other workflows whenever a row is added or modified in a specific sheet.

Practical Examples

  • Notify your team via Slack when a new row is added to a project tracking sheet.
  • Sync changes from a Smartsheet sheet to another system (e.g., CRM, database).
  • Start approval workflows when certain cells are updated in a sheet.

Properties

Name Meaning
Type The type of Smartsheet object to watch for events. Options: Sheet.
Sheet The specific Smartsheet sheet to monitor for events. You can select from a list or specify the sheet ID using an expression.

Output

The node outputs the event payload received from Smartsheet as JSON. The structure of the output will match the webhook data sent by Smartsheet, which typically includes details about the event (such as event type, affected rows/cells, user info, etc.).

Example output:

[
  {
    "events": [
      {
        "eventId": "...",
        "objectType": "row",
        "eventType": "created",
        "userId": "...",
        // ...other event fields
      }
    ],
    // ...other webhook fields
  }
]

If the webhook request contains a challenge (for verification), the node responds with the required challenge response, but does not pass any data to the workflow in that case.

Dependencies

  • Smartsheet API: Requires a valid Smartsheet API credential configured in n8n (smartsheetApi).
  • The node must be accessible from Smartsheet's servers (publicly reachable URL) for webhooks to function.

Troubleshooting

  • Webhook Not Triggering: Ensure your n8n instance is publicly accessible and the webhook URL is correctly registered with Smartsheet.
  • Invalid Credentials: If the API key is missing or incorrect, the node will fail to create or delete webhooks.
  • Challenge Response Errors: If Smartsheet cannot verify the webhook due to an incorrect challenge response, check that your n8n instance is running and reachable.
  • "message":"SUCCESS" Not Returned: If the webhook creation or enabling step does not return "SUCCESS", the webhook setup may have failed—check your credentials and permissions.

Links and References

Discussion