Small BusinessIndependent InvestorTrade BusinessAccountingFinanceLegalMarketingOperationsSalesReal EstateTemplatesPricingDocs
Get started

Step Guide: Filter

Flow Control

Filter list data by rules before processing

Overview

The Filter step removes elements from an array based on conditions you define, outputting only the matching items. It has two actions: Filter, which keeps rows that match a condition, and Deduplicate, which collapses duplicate rows.

Filter Rows

Filter array elements by condition. Elements that match are included in the output; elements that don't are excluded. Place between a data source step and a For Each step to narrow down what gets processed.

  • Filter imported CSV or Google Sheets rows to only process relevant records
  • Remove invalid or incomplete entries before sending to downstream steps
  • Narrow down a large dataset to a subset matching specific criteria
  • Apply business rules to select which items proceed in the workflow

Reads an array from the input and applies configured filter conditions. Typically placed between a data source (CSV Import, Google Sheets Read, or Collect) and a For Each step. Conditions support AND/OR/NOT logic with operators like equals, contains, greater than, starts with, matches regex, is empty, and more. Outputs a list array of matching elements and a list_count.

Tips
  • Combine multiple conditions with AND/OR for complex filtering logic
  • Use filter to reduce iteration count before a For Each loop for better performance

Frequently Asked Questions

What's the difference between Filter and Condition?
Filter removes items from an array based on a condition; the output is a smaller array of the same shape. Condition routes the workflow down different paths. Use Filter to narrow lists, Condition to branch logic.
Can I combine multiple filter conditions?
Yes. Conditions support AND, OR, and NOT logic with operators like equals, contains, greater than, starts with, matches regex, and is empty.
Where should I place a Filter step?
Between a data source (CSV Import, Google Sheets Read, Collect) and a For Each loop. Filtering before iteration reduces the number of items processed downstream.
Can the Filter step also remove duplicates?
Yes. Switch its action from Filter to Deduplicate using the selector at the top of the step to collapse duplicate rows by the fields you choose. See the Deduplicate guide for how it decides which rows match and which one to keep.