How do I import or somehow use columns in another sheet? For example, I did “Find people that work at these companies” but I have custom cells on that “Find Companies” sheet. So I want to compose an email in and add things from both sheets as sources to compose the email.
You can use our "write to table" feature to transfer data between tables in your workbook. This is perfect for combining company and people data. 1. Set up the "write to table" action in your source table 2. Select your destination table (where you want to compose emails) 3. Map the columns you want to transfer For email composition, you can then use dynamic column referencing to personalize your messages by inserting fields like company details directly into your drafts. Clay automatically links your Find Companies table to your Find People table, allowing you to extract company attributes directly into your people data.
Is the function called “Send table data”?
Yes, the feature is called "Send table data" - it's our newest way to send data between tables. It replaced the legacy "Write to table" feature, though you may still see "Write to table" as an option when using the "Add Enrichment" button. You can access it by clicking Actions → Send table data while in your source table.
I ran this
Making it look like this in the sheet
After running "Send table data, " go to Actions > Draft Email in your destination table. When composing your email, use the forward slash (/) menu to reference columns from both sheets. This lets you insert dynamic data from either table directly into your email body.
After using "Send table data" to transfer information between tables, you can customize how the data appears by: 1. Using the "Merge columns" feature to combine data from different sources: • Click "Add Column" → "Merge columns" • Write a formula using the "/" key to reference columns you want to combine 2. Rearranging your columns by clicking on a column header and using "Insert left" or "Insert right" 3. Hiding parent columns or any columns you don't need by clicking the column header and selecting "Hide" This lets you create a customized view that combines data from both your source and destination tables.
Under “Rows from:” should I see stuff? If the goal is to get people data in here
Yes, if you're using "Send table data" to get people data into your sheet, you should see people data under the "Rows from:" section. This feature allows you to send each person as a separate row from your source table. Clay automatically links your Find Companies table to your Find People table, letting you extract company attributes directly into your people data. If you don't see the data, check that you've properly linked the tables and selected the correct source column containing your people list.
Can you get me some human help?
Yes, we have two ways of doing this, sounds like you need #2 ! :) 1. [Send Table Data::](https:://www.clay.com/university/guide/send-table-data) You can send data into a new table using the “Send Table Data” option. This is great for sending lists of objects, individual values, or both. For example, if you have an enrichment with a list of multiple objects, you would select the “write to table list” option. You can also add other values to match that are in this table but not as a list. 2. [Lookup::](https:://www.loom.com/share/ad767e3be9914d19a2f6647efe4dfa85?sid=c8b78c32-9bc1-4501-8124-d6c70d2218cf) If you want to add more information that you already found from a previous table to the current data you have (e.g., matching domains), then “lookup” is the best option. This allows you to call matching data into one table. Let me know if that answers your questions. Happy prospecting! 💪✨
.png){kind=logo}
