Get Table

Retrieves all rows from a spreadsheet table as workflow items.

Overview

The Get Table node reads data from a named table in your spreadsheet. Each row becomes a separate item that flows through your workflow.

Use it to:

• Load data for processing
• Start workflows with fresh table data
• Read reference data for lookups

Parameters

Parameter	Description	Required
Table Name	The table to read from (dropdown)	Yes
Lido Spreadsheet URL	Override the default spreadsheet	No

Table Name

Select from available tables in your spreadsheet. Tables are named ranges with headers defined in your Lido workspace.

Lido Spreadsheet URL

By default, the node reads from your workflow's associated spreadsheet. Use this parameter to read from a different Lido spreadsheet by providing its URL.

Output

Each table row becomes an item with the following structure:

{
  "type": "tableRow",
  "data": {
    "Name": "Acme Corp",
    "Status": "Active",
    "Amount": 1500
  },
  "columnNameToPosition": {
    "Name": { "row": 2, "col": 1 },
    "Status": { "row": 2, "col": 2 },
    "Amount": { "row": 2, "col": 3 }
  }
}

Field	Description
type	Always "tableRow"
data	Object with column names as keys and cell values
columnNameToPosition	Cell positions for each column (used for updates)
file	File info if table contains a file column

Examples

Load Customer Data

1. Add Get Table node
2. Select your "Customers" table
3. Connect to downstream nodes

Each customer row flows as a separate item.

Filter and Process

[Get Table: Orders] → [Filter: status = pending] → [Process]

The Get Table outputs all orders; the Filter keeps only pending ones.

Read from Different Spreadsheet

1. Add Get Table node
2. Select your table
3. Set Lido Spreadsheet URL to the other spreadsheet's URL

Tips

• Tables must be defined in your Lido spreadsheet first
• Empty rows in the table are skipped
• Column headers become exact field names (case-sensitive)
• The node runs once and outputs all rows as separate items
• Use with Filter or If nodes to process specific rows
• The columnNameToPosition data enables Edit Table Column to update source rows