Send table data

Send data between tables to create simple multi-table setups.

By

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 ActionsSend 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.
Note: When you first send a row, it creates a new row in the destination table. For subsequent sends, it updates that same row.

Using Send row

Send row sends each row as-is to another table. It’s useful for filtering, segmenting data, or separating logic across multiple tables. It also lets you transfer specific columns, keeping your data aligned and reducing manual entry across tables.

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 People table row.

Best practices & troubleshooting

  • There can be a maximum of 10 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).
    • 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
Starter
Explorer
Pro
Enterprise