If prospeo outputs 6 different emails, how can I tell Clay to use the one that has the business owners first name in it? The 6 emails are all output and bundled into one cell when we use the "Find Email Addresses Associated with a Domain" option. Of course it's not always 6 it finds. It could be any number of emails returned/found.
Hi David - Happy Saturday ๐ Thanks for reaching out! Iโve recorded a GIF to show you the steps: 1. Find the formula name of the fields you want to cross-reference. 2. Create a formula column and write a prompt to find the email that contains parts of the full name. 3. Hit save. Youโll see the result in your table. For more on how formulas work, check out this guide: How to Use AI Formulas. Let me know if you need further help! ๐ https://downloads.intercomcdn.com/i/o/w28k1kwz/1246002399/f5f2ab7472d0cb55f3fec17c449d/CleanShot+2024-11-09+at+_378zKB8OkR.gif?expires=1731186000&signature=4c7179416cc44a7dda1dac3724f17a25a85724c2cd48653ba1b07a9b0deadb1a&req=dSIjEMl%2Bn4JWUPMW1HO4zbMTvWKCmF04Koopk%2Bq9QZBYEqS1nRqG7j2c11zN%0A8mqa%0A
Thanks Bo! I really appreciate that! I have no idea how its working though as I copied your actions and formula exactly in another column and can't get the same result ๐ Your column is working though so thats great!
Hi there, The prompts use AI to generate results, so if itโs not working as expected, you might need to adjust the wording. Alternatively, you can copy the JavaScript directly and modify the column reference (e.g., {{column}}) without linking the objects. Hereโs an example to help you get started Let me know if you need further assistance! ๐ https://downloads.intercomcdn.com/i/o/w28k1kwz/1246017230/422d73126efddf27fe8c2c8f4cc9/CleanShot+2024-11-09+at+_19X9ig5SJS.gif?expires=1731187800&signature=a384c819b75de65269b9af750426bc83243dcb8c5d3ff844313a566baf4baeca&req=dSIjEMl%2FmoNcWfMW1HO4zc%2FG2PKQ3UGXfesw58auA8Xi2vJh5HQrE1STVeUb%0A14vW%0A
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!