In this article
The Filter Row Elements tool allows you to filter and process individual rows of data within your automation by defining conditions that determine which elements are passed to the next steps of the workflow.
This is especially useful when working with orders, as filtering and segmenting incoming data helps organize internal logistics, product delivery, and post-sales processes. In many cases, a single order may contain products or services handled by different departments, making it necessary to separate these items and route them to the appropriate responsible parties.
With the Filter Row Elements tool, you can extract from an order only the data required for this segmentation and efficiently distribute it in subsequent steps — for example, to the person responsible for processing a specific purchase.
Example 1. Filtering and routing high-value orders from Mercado Libre
In this example, we show how to filter new Mercado Libre orders by order value and payment currency (USD). When these conditions are met, a deal will be created in Pipedrive and assigned to the manager responsible for handling this type of sale.
You can apply the same logic to build automations between different marketplaces, sales platforms, and CRMs, depending on your business needs and workflow structure.
Before you start
Before creating the automation, make sure that both applications used in this scenario are connected to Albato.
To do this, go to the Apps tab, click Add a connection, and search for Mercado Libre and Pipedrive.
Creating the automation
- Go to the Automations tab in Albato and click Create new automation.
- In the first step, add a trigger. Select the Mercado Libre app and choose the Order Created event.
- Add a tool by clicking the + button.
- Select the Filter Row Elements tool.
- Choose the data set you want to filter. Click on the step and select Order Created – Order Items.
Configuring filter conditions
Configure the conditions so that Albato filters only orders that meet the following criteria:
- total order value is greater than 1000;
- payment currency is USD.
- Then, select the required parameters, define the condition types, and enter the corresponding values.
- Make sure the Mode option is set to Leave item. This ensures that only items matching the specified conditions are passed to the next steps.
Processing multiple items
- Next, add another tool and select Iterator.
- This step allows Albato to process each matching product separately if an order contains multiple items that meet the defined conditions. After adding the iterator, select the array coming from the previous step.
Creating a deal in Pipedrive
- Add the Pipedrive app and select the Create Deal action.
- Fill in the deal fields using the customer contact information from the order, along with the product data provided by the iterator.
- In the Owner (User ID) field, select the person responsible for handling this type of deal in Pipedrive.
You can also map additional product details (such as name, size, weight, warranty, and other attributes) to custom fields in Pipedrive.
- Once all required fields are filled in, activate the automation. From this point on, the automation will run automatically for every new order received from Mercado Libre.
Only order items that meet the defined conditions will be passed to the next steps, processed individually, and converted into deals in Pipedrive assigned to the appropriate manager.
By using the Filter Row Elements tool together with the Iterator tool, you can control how specific items within an order are handled, without affecting the processing of the entire order.
This approach helps you:
- segment orders based on business rules;
- route data to the right teams or systems;
- scale your automations without duplicating scenarios.
You can further adapt this automation by changing the filter conditions, for example, by product category, price range, currency, or any other attributes relevant to your workflow.
