Clay Icon
Join the Community
02 Support

Extracting First Name from Email Data: Seeking Team Assistance

Avatar of Andrew L.Andrew L.
·
·

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!

19 comments

  • Avatar of Clay T.
    Clay T.
    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 😉

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Hi Andrew L., taking a look!

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Which column are you hoping to extract the first name from?

  • Avatar of Andrew L.
    Andrew L.
    ·
    ·

    Thanks, out of the search result found column which contains the Title

  • Avatar of Andrew L.
    Andrew L.
    ·
    ·

    Hi Anjali, any ideas? Clay T.

  • Avatar of Clay T.
    Clay T.
    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

  • Avatar of Clay T.
    Clay T.
    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.

  • Avatar of Clay T.
    Clay T.
    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

  • Avatar of Andrew L.
    Andrew L.
    ·
    ·

    Thanks Arturo, that makes sense. Not sure I see the example you added? I will try that in chatGPT though.

  • Avatar of Clay T.
    Clay T.
    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

  • Avatar of Clay T.
    Clay T.
    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 :)

  • Avatar of Andrew L.
    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?

  • Avatar of Clay T.
    Clay T.
    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

  • Avatar of Clay T.
    Clay T.
    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

  • Avatar of Andrew L.
    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?

  • Avatar of Andrew L.
    Andrew L.
    ·
    ·
  • Avatar of Clay T.
    Clay T.
    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.

  • Avatar of Andrew L.
    Andrew L.
    ·
    ·

    It worked! Really appreciate the help, this is fantastic.