Query Nodes in Automations

Query nodes work with system data, secrets, and table records.

Read Secret

The Read Secret node retrieves a secret from the Vault for use in downstream nodes.

What it does

It safely resolves a stored secret at run time.

How to configure it

The configuration panel includes:

• Node label

  The display name of the node.

• Secret

  Lets you choose which stored secret to use.

• Alias

  Defines the name used to reference the resolved secret later.

The UI note explains that:

• the secret value is resolved at run time

• it is never stored in context body, logs, or API responses

• it can be referenced downstream using the alias

When to use it

Use Read Secret when the automation needs access to:

• API keys

• private tokens

• credentials

• sensitive configuration values

Query Rows

The Query Rows node finds one or more rows in a workspace table.

What it does

It searches table data so later steps can use the result.

How to configure it

The configuration panel includes:

• Label

  The name shown on the node.

• Table

  Selects the table to query.

• Find by

  Lets you choose the lookup mode:

  • Row ID

  • Filters

• Conditions

  Lets you add one or more filters.

• Limit (max 500)

  Controls how many rows may be returned.

When to use it

Use Query Rows when the automation needs to:

• look up records before taking action

• find matching rows by condition

• fetch data that will be updated, deleted, or reused later

Insert Rows

The Insert Rows node creates one or more rows in a workspace table.

What it does

It writes new records into a selected table.

How to configure it

The configuration panel includes:

• Label

  The node name.

• Table

  Selects the destination table.

• Insert mode

  The screenshot shows:

  • Single row

  • From step

• Fields

  Lets you add the field values that will be inserted.

When to use it

Use Insert Rows when the automation should create records automatically, such as:

• new leads

• imported events

• tickets

• sync entries

• system-generated logs

Update Rows

The Update Rows node modifies one or more existing rows in a workspace table.

What it does

It updates selected fields in existing records.

How to configure it

The configuration panel includes:

• Label

• Table

• Fields to update

• Target

  • Row ID

  • Filters

• Conditions

  • lets you add filters

When to use it

Use Update Rows when the automation should change existing records, such as:

• updating a status

• filling in a calculated field

• marking a row as processed

• syncing data from another source

Delete Rows

The Delete Rows node removes one or more rows from a workspace table.

What it does

It deletes records that match the selected target and conditions.

How to configure it

The configuration panel includes:

• Label

• Table

• Target

  • Row ID

  • Filters

• Conditions

  • requires at least one condition to prevent accidental mass deletion

When to use it

Use Delete Rows when the automation should remove records automatically, but only with very clear filters and control.

This node should be used carefully because it affects stored data directly.