All docs
/
Export
/
Send table data

Send table data

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

Overview

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 → 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

Explore other docs

Web scraping

Sumble integration

Validate whether a company uses specific technologies.

View article
Export

Microsoft Teams integration

Send messages to Microsoft Teams channels directly from Clay.

View article
Enrich

EmailBison integration

Import leads into campaigns directly from Clay, ensuring accurate and efficient campaign execution.

View article

Keyboard shortcuts

Work faster in Clay with keyboard shortcuts.

View article
Export

Salesforce SOQL

The Salesforce SOQL source enables you to import records from Salesforce by writing custom queries.

View article
Transform

Share workbooks and tables as templates

Share your Clay workbooks and tables.

View article
Enrich

Zerobounce integration overview

Email validation and deliverability tools boost inbox placement and marketing ROI.

View article

Other popular resources

Experts

Find a Clay Expert

Explore our network of Clay experts and agencies

View experts
Community

Join our slack community

Find help in our slack community, and support channels

Go to slack
Cohorts

Join a cohort, learn Clay fast!

The faster way to master Clay. Sign in if you're enrolled in a cohort (current or past) or apply to an upcoming one!

Learn more about cohorts