Filter US Leads & Clean Fields

Created by

Adam Pearce

Actor

Dataset Filter & Transform

Filter scraped leads to one country and value threshold, trim/lowercase emails, cast a currency string to a number, and build a summary field, in one Actor run.

Try for free

Dataset Filter & Transformnerolabs/dataset-filter-transform

Name

Country

Revenue

+3 fields

Input

Data (inline)

name:jane doe+4

email:JANE@Example.com+4

country:US+4

revenue:$12,500.00+4

active:yes+4

signupDate:2026-03-14+4

Transform steps (applied in order, before filtering)

op:trim+3

field:name+3

Filter conditions (applied after transforms)

field:country+2

operator:equals+2

value:US+2

Combine filters with:AND

Export file formats:csv+1

Output fields

Name

Country

Revenue

Active

Signup date

Summary

How it works

Sign up on Apify or log in

The Dataset Filter & Transform Actor is ready to run with the inputs already set for "Filter US Leads & Clean Fields". Sign up or log in and you'll land in Apify Console with a copy of this exact task.

Start the "Filter US Leads & Clean Fields" task

The Dataset Filter & Transform Actor will start running based on the input automatically. You can also change all the input fields, like data (inline), transform steps (applied in order, before filtering), and more, to match your specific use case.

Receive the "Filter US Leads & Clean Fields" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as name, email, country, and more.

Integrate into your workflow

The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow. You can also run the "Filter US Leads & Clean Fields" task via API.