Node types reference

This page is the one-stop reference for every node type on the FlowBuilder canvas. Each row tells you what the node does, what it consumes (rows, control-flow, none), and what it emits. For a deep walk-through of a specific node, click through to its own page in the Nodes sidebar.

Node	Group	What it does
Start	Control	Marks where a run begins. Every workflow needs one entry point.
Source Node	Source	Reads rows from any configured connector: database, file, or API.
Webhook Trigger	Source	Exposes a signed URL; an incoming POST starts a run with its body.
API Request	Source	Emits one row with the method, path, parameters, allowed headers and body of the incoming API request.
Data Profile	Transform	Profiles columns: nulls, distinct counts, ranges, and type drift.
Data Dedupe	Transform	Matches records that mean the same entity, scores them, and routes each kind of duplicate to its own output.
SQL	Transform	Transform/Filter via SQL
Transform	Transform	Visual field mapping: rename, cast, and derive output columns.
Transform (Legacy)	Transform	Legacy Transform alias (map)
Filter	Transform	Keeps or drops rows using a condition, with the dropped rows on their own port.
Compute	Transform	Adds computed columns, sorts, and aggregates with group-by and window functions.
Message	Transform	Renders rows into a text, CSV, or JSON message body from a template.
Reshape	Transform	Pivots rows into columns, or unpivots columns back into rows.
Script	Transform	Runs your own DuckDB SQL over the incoming rows.
Union	Transform	Stacks rows from several inputs that share the same columns.
Lookup	Transform	For each row, fetches matching values from a second reference source.
Join	Transform	Inner, left, right, or full join of two inputs on matching keys.
Sub-workflow	Transform	Runs another workflow as a single step and returns its output.
Document / PDF	Transform	Extracts text and tables from PDFs, or renders rows into a PDF.
AI Prompt	AI	Sends each row to a model with a prompt template and returns its answer.
Loop (container)	Decision	A container node: the nodes placed inside it run once per item.
Node Call	Decision	Calls a reusable project node for each item.
Loop	Decision	Expands a nested list into rows, or repeats until a condition is met.
Router	Decision	Sends each row down one branch based on a value or a rule.
Fork	Decision	Sends every row to all of its branches in parallel.
Human Approval	Decision	Pauses the run until an assigned person approves or rejects.
Database Script	Database	Executes DDL or stored procedures directly on a database connection.
Target Node	Target	Writes or upserts rows into a configured connector.
API Response	Target	Sets the status code, headers and body the endpoint returns from the incoming rows.
Log	Output & Observability	Writes structured events to the run log for debugging.
Notification	Output & Observability	Sends an email, Slack, or Teams message.
Variable	Variable	Sets run-scoped variables that later nodes can read.
Cache	Cache	Writes rows into a named cache for later lookups in the same run.