Skip to main content

Workflow Result

Defines the result returned when a workflow is triggered by TRIGGERWORKFLOW or other callers.

Overview​

The Workflow Result node captures the output of a workflow so that it can be returned to the caller. Use it when a workflow is invoked via the TRIGGERWORKFLOW spreadsheet formula and you want to return data back to the cell.

The node runs once (not per item) and requires an explicit Response Value parameter that defines exactly what data is returned.

If no Workflow Result node is present, the TRIGGERWORKFLOW formula returns the text "Workflow completed" with no data.

Parameters​

ParameterDescriptionRequired
Response ValueThe data to return as the workflow result.Yes

Response Value​

A JSON expression that defines the result. Supports expressions.

If the value is an array, each element becomes a result item. If it is a single object, it becomes one result item.

Output​

The Workflow Result node outputs the response value items to its main output, so you can chain additional nodes after it if needed.

Usage​

With TRIGGERWORKFLOW Formula​

  1. Create a workflow with a Manual Trigger node
  2. Add your processing nodes (Sheet Calc, Edit Item, etc.)
  3. Add a Workflow Result node at the end
  4. Set the Response Value to the data you want returned
  5. In a spreadsheet cell, use =TRIGGERWORKFLOW("workflow-id") to run the workflow and receive the result

Examples​

Return a Summary​

A workflow that aggregates data and returns a summary:

Manual Trigger -> Get Table -> Aggregate -> Edit Item -> Workflow Result

Set Response Value on the Workflow Result node to:

{{ { "totalRevenue": $item.data.sum, "count": $item.data.count } }}

Use Trigger Data​

Pass data from the formula into the workflow and return processed results:

In the spreadsheet:

=TRIGGERWORKFLOW("workflow-id", "{""name"": ""Alice""}")

In the workflow:

Manual Trigger -> JS Code (process trigger data) -> Workflow Result

The Manual Trigger outputs the item {"name": "Alice"}, which flows through the workflow. The Workflow Result node defines what is returned to the formula.

Tips​

  • Only one Workflow Result node is needed per workflow. If multiple are present, the last one to execute sets the result.
  • The node has no effect when the workflow is run from a scheduled trigger or other non-formula triggers — it simply passes items through.
  • The result is stored in-memory during execution, so there is no persistence overhead.