Extracting First Name from Email Data: Seeking Team Assistance

Hi Team, I ran a boolean search and used that to extract emails but can't seem to figure out how to get the First Name extracted from the snippet or title. Any help would be appreciated!

✅1

18 comments

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Andrew L.
·
·
https://app.clay.com/workspaces/225174/tables/t_uvAbsnwaQStj/views/gv_sXiDyrXe8nvf
Clay Team
APP
·
·
Hi Andrew L., taking a look!
Clay Team
APP
·
·
Which column are you hoping to extract the first name from?
Andrew L.
·
·
Thanks, out of the search result found column which contains the Title
Andrew L.
·
·
Hi Anjali, any ideas? Clay Team
Clay Team
APP
·
·
Hey Andrew, sorry for the delay. Perhaps Anjali had a few calls in between and wasn't able to circle back.I'll jump in here
Clay Team
APP
·
·
We can use the formula generator for this but since most of the Titles or Snippet sections aren't standardized, the code (which uses Javascript) won't be able to distinguish between a name or other words which is what AI may be best at in this case.
Clay Team
APP
·
·
If you want this to be much more consistent, I'd give those sections to chatGPT and ask it to create a separate list of just the name, title, and other information based on the inputs. I added an example to your table in case it helps. Let us know though
Andrew L.
·
·
Thanks Arturo, that makes sense. Not sure I see the example you added? I will try that in chatGPT though.
Clay Team
APP
·
·
Sorry, had to get the prompt so it took me a second. I'll add those credits back, once I can see it's a bit more consistent
Clay Team
APP
·
·
There you go, looks like it's working. Feel free to check the prompt and settings I added to the chatGPT column if it helps. Click on the header -> Edit Column to open that up.I just added the credits I used back in :)
Andrew L.
·
·
That is amazing, thanks! Very helpful to see how you did that. Is there also a way to just run it for say 100 rows instead of all 949?
Clay Team
APP
·
·
Yup!! Also in the column header -> Run Column :D... I have a video if it helpsHow to turn your table off, stop ongoing runs, also run a specific number of rows (bonus setting up row limits/filters) - https://www.loom.com/share/131e2c371a184748a87dc870304955b0
Clay Team
APP
·
·
And also one about JSON mode for chatGPT which is what I used here -> JSON mode in chatGPT: https://www.loom.com/share/317de47023fb429a80022de0f4a5d6dc
Andrew L.
·
·
This is really great, thanks Arturo. I did go and hit re-run 100 rows but now it says error.. Not sure what I'm doing wrong now?
Clay Team
APP
·
·
Hey Andrew, thanks for checking in again. Forgot to mention that this JSON setting only works with model GPT3.5, so if you change it to that let me know if it continues.
Andrew L.
·
·
It worked! Really appreciate the help, this is fantastic.

Extracting First Name from Email Data: Seeking Team Assistance | Clay