How to Filter and Transfer Selected Contacts in a Table

William R. · 2025-11-04 01:34:23.099149+00

Hey Guys. I have multiple people from a company in the table. I only want to send 3 people with valid emails to the next table. How can I do that?

How to Filter and Transfer Selected Contacts in a Table | Clay

Clay Support
APP
·
·
To send only 3 people with valid emails to another table:
1.
Use checkboxes: Manually check the "Send table data" boxes for exactly 3 rows with valid emails
2.
Set up Send table data: Click Actions → Send table data, select your destination table, and choose Send row [1]
3.
Add conditions: Use conditional runs with "Only run if" settings to filter for valid emails (e.g., {{email}} is not empty) [2]
This approach lets you control exactly which 3 people get sent while ensuring they have valid emails.
Clay Support
APP
·
·
Was that helpful?
William R.
·
·
I have huge lists. I can't do manual
Clay Support
APP
·
·
For large lists, use Write to Other Table with conditional logic:
1.
Add a Write to Other Table column
2.
In Run Settings, use "Only run if" with conditions like: • {{email}} is not empty (valid emails only) • Add a counter or use row limits
3.
Set up list mapping to automatically send the first 3 people with valid emails to your destination table [1] [2]
The conditional runs feature lets you add programmable logic to control exactly which rows get processed, eliminating manual selection [3].
Clay Support
APP
·
·
Did that answer your question?
William R.
·
·
How can I add a counter or use row limits?
Clay Support
APP
·
·
For row limits: Click the Rows button in your table toolbar, enter the starting row and desired row limit, then click Save changes. [1]
For counters: Add a Row Number column using a number generator, then filter rows with numbers greater than or equal to your desired starting point.
You can also run columns from specific rows by clicking the column header, hovering over "Run Column", then selecting "Choose Number of Rows to Run" to specify starting row and count.
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you still need help setting up the counter or row limits to automate sending only 3 people with valid emails, I’m here to assist. Would you like to provide more details about what you’re trying to achieve so we can continue?
William R.
·
·
Yeah. Give more details
Clay Support
APP
·
·
Here are detailed methods to automatically send only 3 people with valid emails:
Method 1: Row Limits + Write to Table
1.
Click Rows button in toolbar, set starting row to 1 and row limit to 3 [1]
2.
Add Write to Table column with condition {{email}} is not empty in "Only run if" settings [2] [3]
Method 2: Column Run Control
1.
Click your column header → hover "Run Column" → select "Choose Number of Rows to Run"
2.
Specify starting row and count (e.g., rows 1-3)
Method 3: Row Number Filter
1.
Add Row Number column using number generator
2.
Filter rows where row number ≤ 3 AND email is not empty
The conditional "Only run if" setting ensures only valid emails get processed automatically.
Clay Support
APP
·
·
Was that helpful?
William R.
·
·
I want this to be automatic
William R.
·
·
Nothing manual
Clay Support
APP
·
·
Use write to table with conditional logic for fully automatic filtering:
1.
Add a write to table column
2.
In Run Settings, set Only run if condition: {{email}} is not empty
3.
Add a second condition to limit to 3 people using a formula or row counter
4.
Enable Auto-update to automatically process new rows [1]
The Only run if feature lets you set conditions to control when the column runs automatically, ensuring only valid emails get processed without any manual intervention. [2] [3]

28 comments