Streamline Investor Results for Easy Email Enrichment

Steve G. · 2025-04-09T06:17:01.966862+00:00

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.

Sources: Writing Investors from Funding Rounds into a New Table | Clay Enrich People (Waterfalls) [Clay 101] - Clay University

6 comments