Sending Data Between Tables Without Overwriting
To append data to a destination table while preserving existing data:
- Use the Send table data action to transfer data from your source table to the destination table
- In the mapping step, double-click each field to map it to existing columns in the destination table
- Configure the advanced settings:
- Enable "Map to existing columns"
- Disable "Auto-extract new columns"
Important Notes
- This approach appends new rows without modifying existing ones
- Clay automatically protects manually entered data in existing columns from being overwritten
- Clay will only auto-map to columns that contain formulas
February 2026