Sending Specific Cell Values between Tables: A Guide

David A. · 2025-10-29 21:22:45.135777+00

When using the "Send Table Data" action, can I send only a specific cell value in a row? Or can I only send an entire row? I have two tables, Table A, and Table B. I’m looking up the website URL in Table B, and if it exists in Table A, there is a column in Table A that says Record Found. That part is easy. What I want to do is this: If the website URL Record is found in Table B, then write value for the “First Name” column for that row in Table A into Table B, creating a new column in Table B.

Sending Specific Cell Values between Tables: A Guide | Clay

Clay Support
APP
·
·
Yes, you can send specific column values, not just entire rows. [1]
When using Send Table Data, choose which columns to send by selecting Send row and picking specific columns.
For your use case, you can also use Write to Table for column mapping. This lets you transfer specific columns from one table to another, keeping data aligned. [2] You can write individual values or entire lists depending on your column setup. [3]
To write the "First Name" value from Table A to Table B:
1.
In Table A, add a Write to Table column
2.
Select Table B as your destination
3.
Enter "/" to skip list selection
4.
Map the "First Name" column from Table A to a new or existing column in Table B [4]
You can use Only run if conditions to make it run only when the website URL record is found.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you need any more help with sending specific cell values or using Write to Table, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any challenges you’re facing?
David A.
·
·
It works, but it doesn't write the cell value in the correct row, it just writes the cell values at the bottom of the new column in Table B.
Clay Support
APP
·
·
When using write to table to transfer data between tables, it creates new rows rather than updating existing rows with matching criteria. [1]
For your use case—writing the "First Name" from Table A to the matching row in Table B based on website URL—you'll need a different approach since write to table doesn't support row-matching logic.
Send table data creates a new row on first send, then updates that same row on subsequent sends, but this also doesn't match rows based on lookup criteria. [2]
To write values to specific existing rows in Table B based on a lookup match, you may need to use a formula or enrichment approach in Table B itself that references Table A. Could you share more details about your current setup, specifically how you're performing the lookup between tables?
David A.
·
·
I'm using Row Lookup in Table A to find rows with in Table B with the matching values. In my case I'm looking at Website URL in table A, and checking if a row in Table B has a Website URL value containing the value in Table A.
Clay Support
APP
·
·
The current write to table and send table data features don't support matching and updating existing rows based on lookup criteria—they create new rows instead. [1]
For your workflow (writing "First Name" from Table A to the matching row in Table B based on website URL), you'll need to reverse your approach:
In Table B (where you want the data to appear), add a lookup enrichment that references Table A. This way, when Table B finds a matching website URL in Table A, it can pull the "First Name" value directly into the correct row in Table B.
This keeps the data aligned to the existing rows rather than creating new ones at the bottom.
Clay Support
APP
·
·
Is that what you were looking for?
David A.
·
·
That makes sense, but I don't have instructions on how to write the data. With the lookup enrichment I can only see how to look up, not lookup and write based on the condition.
Saad A.
·
·
Why don't you merge both of them?
Clay Support
APP
·
·
The lookup enrichment itself retrieves the data—it doesn't write it. Once the lookup finds the matching row in Table A, the returned data (like "First Name") automatically populates in that column in Table B. [1]
Here's how it works:
1.
In Table B, add a Lookup Single Row in Other Table enrichment
2.
Set Table to Search to Table A
3.
Set Target Column to the Website URL column in Table A
4.
Set Filter Operator to "contains" (or your preferred match type)
5.
Set Row Value to reference the Website URL column in Table B
Once the lookup runs, you can extract specific fields from the matched row. Click on a cell in the lookup column, hover over the "First Name" endpoint, and click Add as column to create a new column with just that value. [2] [3]
This pulls the First Name from the matched row in Table A directly into the correct row in Table B.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
When you use the Lookup Rows enrichment in Table B, it retrieves data from Table A—including the "First Name" field you need. [1]
To write that looked-up value into a column in Table B:
1.
Run the Lookup enrichment in Table B (searching Table A by website URL)
2.
Click into the cell containing the lookup results
3.
Hover over the "First Name" endpoint and click Add as column
4.
Choose to map it to an existing column or create a new one [2]
This writes the First Name value directly into the correct row in Table B where the lookup matched.
Clay Support
APP
·
·
Is that what you were looking for?
Saad A.
·
·
David A. - then simply send to other table

26 comments