Get Smartsheet: Smartsheet action

Inputs

The fields this action accepts.

Every field can be mapped from an upstream trigger, AI step, table row, or hard-coded literal.

Field	Type	Required	Description
Sheet ID sheet_id	string	Required	The Sheet ID assigned by Smartsheet. Find via the corresponding list/search operation in this app. Use the exact ID, not a name or label.

Sample request

{
  "sheet_id": "{{trigger.sheet_id}}"
}

Returns

{
  "id": 12345,
  "name": "Projects",
  "rows": [
    {
      "id": 1001,
      "cells": [
        {
          "value": "Build feature X",
          "columnId": 1
        }
      ]
    }
  ],
  "columns": [
    {
      "id": 1,
      "title": "Task"
    }
  ],
  "totalRowCount": 1
}

Use these fields in downstream nodes for routing, logging, or error handling.

FAQ

Questions about Get Smartsheet.

What does the Get Smartsheet action do in Smartsheet?

Returns the full sheet — schema (columns with types), rows, attachments references. The lookup before update workflows or for full-sheet export.

What inputs does Get Smartsheet require?

Required: Sheet ID. Every input accepts a static value or a variable from any upstream node in your workflow.

Can I use dynamic inputs from earlier workflow nodes?

Yes. Any field on this action can pull values from upstream nodes, whether that's a form response, a trigger payload, an AI output, or a lookup result.

What happens if Smartsheet returns an error?

The workflow pauses on the failed node, the error message is captured in the run log, and you can retry the run with one click. Auto-retry policies are configurable per workflow with exponential backoff up to 5 attempts.

Does Get Smartsheet support batch operations?

Yes. Run Get Smartsheet inside a Loop node to process arrays. Tiny Command handles Smartsheet's rate limits automatically so you don't have to throttle manually.

More actions