Hi Guys Is there an easy way to write these investor results to individual rows per investor, so that I can run an enrichment to find emails and contact them instead of copy pasting one by one?
You can use our "write to table" feature to handle this one-to-many data relationship. Here's how: 1. Add a "Write to Table" enrichment 2. Set up the mapping: • Select your Clay account • Choose your destination table • Select the column containing your investor lists • Map the investor properties to your new table columns This process will write each investor as a separate row in the destination table. Once you have individual rows for each investor, you can run an email enrichment using our waterfall enrichment process. This will help you find valid emails for contacting the investors.
that doesn't explain how to separate by comma
You can use GPT to convert it into array and then write the array to new table
Hey Steve - I recorded this walkthrough video showing exactly how to set this up: https://cln.sh/6NpbMmHL Let me know if you have any follow-up questions!