Hey support team! TLDR; I’m trying to push both people data and associated company data into a new table via the "send table data" function, but I’m running into trouble when adding company info. My goal is to send over selected “Find people from companies” columns plus certain columns from the “Find companies” table, but only for contacts with a fit score ≥ 5. I was told to use the “select row from each item in list” option, but when I try to add the company table column there, I get an error saying I need to add a “valid list.” It won’t accept the company table column as input. Any ideas?
The "Send row for each item in a list" option requires a column containing a list of items (like people found at a company) to flatten into separate rows. For your use case combining people and company data, consider using Write to Other Table instead. This action is specifically designed for transferring data between Company and People tables. Since Clay automatically links Find Companies and Find People tables, you can pull company attributes directly into your People table using lookup columns rather than sending data. This approach lets you access company data without needing to send it separately, and you can filter by fit score ≥ 5 before the transfer.
Caterina H. The error happens because the “select row from each item in list” step requires an actual list object, but the direct company table column reference isn’t treated as a list in this context. The workaround is to first use a “Find companies” or “Filter list” step to produce a list of the company rows you need, then pass that list into the “select row” step. from there, you can merge the selected company fields with your “Find people from companies” results and apply your fit score ≥ 5 filter before sending the combined data to the new table
You're correct about the error. Instead of the complex workaround, consider using write to table which is designed for transferring data between Company and People tables. Since Clay automatically links Find Companies and Find People tables, you can pull company attributes directly into your People table using lookup columns rather than sending data separately. This lets you access company data without needing to send it, and you can filter by fit score ≥ 5 before transfer. This approach saves credits and creates a more integrated dataset combining individual and company information seamlessly.
