API Endpoint
Calls any REST API once per row. Pick the method, set the URL, and add query parameters, headers, and a body for the methods that take one, all of which can include your columns through/. For authenticated APIs, add your key as an Authorization header. There is also a built-in rate limit setting so you stay inside an API’s allowances on large runs.
The response lands in the cell as an object with the status code, headers, and body. Drill into it downstream with /, or pull a deep field like body.data.name into its own column with Extract Field From Object.
Formula
Computes a value from your other columns with a Python-style expression, such as${price} * ${quantity} or ${name}.lower().strip(). Insert columns with / as usual. Comparisons, string methods, and common functions like len, round, sum, min, and max are all available, and numeric-looking text is treated as numbers so arithmetic just works. It costs nothing to run.
Waterfall
Tries several columns in order and keeps the first non-empty result. The classic use is enrichment fallbacks, try the best data source first, then cheaper or broader ones, and stop as soon as one answers, so later steps are skipped and cost nothing. Add each step by picking an existing column, or create a new one right inside the waterfall with its + button. If a step returns an object, you can point the waterfall at one specific field of it, so the step only wins when that field has a value. A step that fails is simply passed over, and the next one runs.
