Send table data

Send table data in Clay lets you route records between tables, making multi-table setups simple to manage and intuitive to use.

Sending table data

To send data from one table to another:

1. While in a table, click Exports → Send table data.
2. Select the destination table.
3. Choose the method:
   • Send row: Choose which columns to send as a row to the other table.
   • Send row for each item in a list
4. Click Save.

Using Send row

Send row sends each row as-is to another table. Use it to filter or segment data, or to separate logic across multiple tables. It transfers specific columns, keeping your data aligned and reducing manual entry. Any extracted basic field can be sent to the destination table using the checklist selectors.

Additionally you can:

• Send nested data from the parent table. (This is useful when you want to avoid extracting basic fields from an action column's output.)
• Rename any field in the destination table using the destination column dropdown.

Using Send row for each item in a list

Each cell can hold a list of items, like a list of people found at a company. To turn each item in that list into its own row in another table, use Send row for each item in a list.

This is useful for flattening lists. For example, if you find multiple people at a company, you can send each person as a separate row in the destination table. This method always creates a new row in the destination table for each item.

Mapping table data in the destination table

Send table data creates a source column in the destination table.

To map data from the source column to an existing column or a new column in the table:

1. Click into the source cell.
2. Hover over the field.
3. Click Add to column.
4. Name the column and click Create column, or click Map to existing column for the chosen field.

Guide: Merging two tables with Send table data

Best practices & troubleshooting

• There can be a maximum of 20 tables connected. This includes tables across workbooks.
• Data can only be sent in a linear direction (A → B → C). In other words, loops are not possible (A → B → C → A).
  • If you want to receive data in the table you're also sending data from, use one of these other actions:
    • Lookup Multiple Rows in Other Table
    • Lookup Single Row in Other Table