Smartsheet icon

Smartsheet

Consume Smartsheet API
Join our community

Actions10

Overview

This n8n node allows you to create a new sheet in Smartsheet within a specified folder, defining its name and columns. It is useful for automating the setup of structured spreadsheets for project management, data collection, or reporting workflows directly from n8n. For example, you could use this node to automatically generate a new task tracking sheet every time a new project is started in your workflow.

Properties

Name Meaning
Folder The destination folder in Smartsheet where the new sheet will be created. You can select from available folders or choose "No folder".
Sheet Name The name to assign to the new sheet (e.g., "Call Tracker"). This is required.
Columns The structure of columns to add to the new sheet. Each column includes:
- Title: Name of the column.
- Primary Column: Whether this is the primary column (true/false).
- Type: Data type of the column. Options:
  • Checkbox
  • Contact List
  • Date
  • Date & Time
  • Duration
  • Multi-Contact List
  • Picklist
  • Multi Picklist
  • Predecessor
  • Text/Number

- Width: Optional width of the column.
- Options: For "Picklist" type, specify allowed options as a list of strings.
Validation For "Picklist" columns, whether to enforce validation on the selected options (true/false).

Output

The output is a JSON object representing the newly created sheet. Typical fields include:

{
  "id": "sheet_id",
  "name": "Sheet Name",
  "columns": [
    {
      "id": "column_id",
      "title": "Column Title",
      "type": "TEXT_NUMBER",
      "primary": true,
      // ...other column properties
    }
    // ...more columns
  ],
  // ...other sheet metadata
}
  • The json field contains all relevant details about the created sheet and its columns.
  • No binary data is produced by this operation.

Dependencies

  • External Service: Requires access to the Smartsheet API.
  • API Key: You must configure Smartsheet API credentials in n8n under the name smartsheetApi.
  • n8n Configuration: Ensure the node has access to the necessary credentials and that the Smartsheet integration is enabled.

Troubleshooting

  • Missing Credentials: If the Smartsheet API credentials are not set up or are invalid, the node will fail with an authentication error. Make sure to provide valid API credentials in n8n.
  • Invalid Folder or Sheet Name: If the folder ID or sheet name is missing or incorrect, the node may return an error indicating the resource was not found or the request was invalid.
  • Column Definition Errors: If required column properties (like title or type) are missing, or if picklist options are not provided for a picklist column, the node may throw a validation error.
  • Common Error Messages:
    • "Authentication failed": Check your Smartsheet API credentials.
    • "Resource not found": Verify the folder selection and input values.
    • "Validation failed": Ensure all required fields are filled and column definitions are correct.

Links and References

Discussion