Tableur

Performs CRUD operations on workspace spreadsheets: read rows, write data, delete, or query with filters.

Common parameters

Parameter	Type	Required	Variable	Description
operation	choice (read, write, delete, query)	Yes	No	Type of operation to perform on the spreadsheet.
spreadsheetId	dynamic value	Yes	Yes	Target spreadsheet ID. Can be selected via the picker or provided as a variable.
tabId	dynamic value	No	Yes	Tab ID for source-linked spreadsheets. Defaults to the first tab.
outputVariable	text	No	No	Output variable name to reference results in subsequent blocks.

Parameters marked Variable = Yes accept the {{blockName.field}} syntax.

Parameters by operation

read — Read

Retrieve rows from the spreadsheet with filters, sorting, and pagination.

Parameter	Type	Required	Variable	Description
filters	array	No	No	Filter conditions (column, operator, value). Operators: =, !=, >, <, >=, <=, contains, in, is_null, is_not_null.
columns	array	No	No	Specific columns to return. Empty = all columns.
sortBy	text	No	No	Column name to sort results by.
sortOrder	choice (asc, desc)	No	No	Sort order: ascending (A-Z, 0-9) or descending (Z-A, 9-0). (Default: "asc")
limit	number	No	No	Maximum number of rows to return. (min 1)
offset	number	No	No	Number of rows to skip (pagination). (Default: 0, min 0)
includeMetadata	boolean	No	No	Include row metadata (ID, creation/modification dates). (Default: false)

write — Write

Insert or update rows in the spreadsheet.

Parameter	Type	Required	Variable	Description
writeMode	choice (insert, upsert)	No	No	Write mode: insert (new rows) or upsert (insert or update based on row_id). (Default: "insert")
rows	dynamic value	Yes	Yes	Rows to write. Variable containing an array of objects (one key per column).
columnMapping	array	No	No	Mapping between source fields and spreadsheet columns (sourceField → targetColumn).
validateTypes	boolean	No	No	Validate data types before writing. (Default: false)
triggerEmbedding	boolean	No	No	Trigger RAG embedding indexation after writing. (Default: false)

Parameters marked Variable = Yes accept the {{blockName.field}} syntax.

delete — Delete

Delete rows from the spreadsheet by filters or by IDs.

Parameter	Type	Required	Variable	Description
deleteMode	choice (by_filters, by_row_ids)	Yes	No	Delete mode: by filter conditions or by row IDs. (Default: "by_filters")
deleteFilters	array	No	No	Filter conditions to identify rows to delete (by_filters mode).
deleteRowIds	dynamic value	No	Yes	Variable containing the list of row IDs to delete (by_row_ids mode).
includeDeletedIds	boolean	No	No	Include the list of deleted IDs in the output. (Default: false)

Parameters marked Variable = Yes accept the {{blockName.field}} syntax.

query — Query

Execute a natural language query on the spreadsheet.

Parameter	Type	Required	Variable	Description
query	dynamic value	Yes	Yes	Natural language query (e.g. Which clients have revenue > 10000?).

Parameters marked Variable = Yes accept the {{blockName.field}} syntax.

Output

Output variable : spreadsheetResult

{
  "success": false,
  "rows": [],
  "total": 0,
  "has_more": false
}

Example

Read data from a spreadsheet.

Input :

{"operation": "read", "spreadsheetId": "sp-123"}

Output :

{"rows": [{"col1": "A", "col2": 42}], "count": 1}

Tip

Operations: read, write, delete, query. Use query with filters for conditional reads.