Skip to main content

Nodes Reference

Nodes are the building blocks of workflows. Each node performs a specific operation on your data.

Node Categories

Triggers

Trigger nodes start workflow execution. Every automated workflow needs at least one trigger.

NodeDescription
Manual TriggerManually start workflow execution
Scheduled TriggerRun workflows on a schedule
Google Drive TriggerRun when files change in Google Drive

Data Operations

Read from and write to your data sources.

NodeDescription
Get TableRetrieve rows from a spreadsheet table
Insert RowsAdd or update rows in a worksheet
Update CellUpdate specific cells in a spreadsheet
Edit Table ColumnModify column values in table rows
Data ExtractorExtract structured data from files using AI

Transformations

Modify and reshape your data.

NodeDescription
Edit ItemAdd, modify, or remove fields from items
AggregateGroup items and calculate summaries
SplitExpand array fields into multiple items
MergeCombine multiple input streams
LimitRestrict the number of items
JS CodeExecute custom JavaScript
Sheet CalcEvaluate spreadsheet formulas

Flow Control

Control how data routes through your workflow.

NodeDescription
IfRoute items based on conditions
FilterKeep only items matching criteria
SwitchRoute items to multiple branches
Error CatcherHandle errors from other nodes

External Services

Interact with external APIs and services.

NodeDescription
Call URLMake HTTP requests
Prompt AIGenerate content with AI
Send GmailSend emails via Gmail

File Operations

Work with files and exports.

NodeDescription
Export to ExcelCreate Excel files from data
Export to CSVCreate CSV files from data
Copy FileCopy or move files
Rename FileRename files

Common Node Features

Parameters vs Settings

Every node has two configuration sections:

  • Parameters - Define what the node does (input values, field mappings, etc.)
  • Settings - Control how the node executes (batch size, error handling, etc.)

Error Handling

All nodes have an error output. When an item causes an error:

  1. An error item is created with the error message
  2. The error item goes to the error output (if connected)
  3. Other items continue processing (unless "stop on error" is enabled)

Connect the error output to handle failures gracefully, or use the Error Catcher node.

Expressions

Most parameters support expressions using {{...}} syntax:

{{$item.data.fieldName}}           // Access item fields
{{$item.data.price * $item.data.qty}} // Calculations
{{$item.data.name.toUpperCase()}} // JavaScript methods
{{$("Node Name").item.data.fieldName}} // Reference a specific node

Toggle between literal values and expressions using the mode switch in the parameter input.