Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps

Community Guidelines

Powered by Tightknit

Streamline Investor Results for Easy Email Enrichment

·

·

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?

Loading attachments

Streamline Investor Results for Easy Email Enrichment | Clay

6 comments

· Sorted by Oldest

Loading comments

Channeled
APP
·
·
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
Steve G.
·
·
that doesn't explain how to separate by comma
Steve G.
·
·
https://app.clay.com/workspaces/552206/workbooks/wb_bA2gXCUcaiGV/tables/t_x5PQPVWv7QRU/views/gv_bbn5kSe7z25U
Muhammad S.
·
·
You can use GPT to convert it into array and then write the array to new table
Bo (.
·
·
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!
Channeled
APP
·
·