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