Issue with Sending Contacts from Apollo to Another Table

I have a problem sending people (Apollo - find people by job title) To another table. There is an option to send "People" list but ther are also "Contacts" lists in the result. No matter which cell I pick to send the list, "Contacts" is not an option. So I cannot send contacts to the other list. See attached images. Driving me crazy. Ay help appreciated!

5 comments

Channeled
APP
·
·
To send "Contacts" lists to another table in Clay, use the "write to table" feature. First, ensure the column you want to transfer actually contains a list (not just a single value). If the "Contacts" option isn't appearing, it may be due to the data not being formatted as a list. Try adding the list through the "Other data from this table" section. Here's a step-by-step approach: ** Select your Clay account and the destination table. ** Choose the column with the lists you want to map (e.g., your "Contacts" list). ** Map the list properties to the new table's columns. ** If the list still doesn't appear, check that the data is structured as a list and not as individual objects or values. If you continue to have trouble, you can watch a video tutorial for troubleshooting: Video Tutorial. If the issue persists, you may want to request human assistance by clicking on "Talk to a person" in your chat window.
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University
Ross R.
·
·
No note helpful
Ross R.
·
·
https://app.clay.com/workspaces/467449/workbooks/wb_Gk53zkEdUpEh/tables/t_0svkrqgnHrKC4QCV9UU/views/gv_0svkrqgf5SRy8qjCCFq
Bo (.
·
·
Hey, Sorry you’re running into this—it’s a known issue where the Contacts list isn’t directly mapped for sending to another table. Here’s a workaround to get it moving: 1. Add a new Formula column. 2. Use a forward slash to reference the contacts part of the result (e.g., /contacts). 3. Then, when using Write to Other Table, click the gear icon, and set the list source as: JSON.parse(/your_formula_column) This will let you send the contact data properly. I’ve flagged the bug to the team so it’s on their radar. Let me know if you want help writing the formula.
Ross R.
·
·
thanks