Extracting Names from Claygent Response into Separate Rows | Clay

Extracting Names from Claygent Response into Separate Rows

Hey everyone, looking for some advice here. I'm using Claygent to scrape the "Our team" pages from websites. Claygent then outputs each name into a new line inside the response cell. I then want to find emails, etc for all these people based on Name & Domain. The issue is that the Claygent response is written into a single Cell. How can I extract each name (which is on a separate line) into a self-contained row? If i need to set up Claygent output differently to accomplish this, plz let me know! thanks yall

22 comments

Muhammad S.
·
·
You can feed the raw data from claygent into Chatgpt and have it return the names of people into JSON format as a list. Then you can write that into another table. Each contact will be written on a seperate row this way in the new table.
Daniil P.
·
·
woah! how do i do that? does that need to be part of my initial prompt, or would I make another enrichment that takes my cell and asks GPT to return json format list?
Daniil P.
·
·
not sure what you mean by "raw data"
Muhammad S.
·
·
Whatever is returned by claygent is what I would call "raw data"
Daniil P.
·
·
like this?
Daniil P.
·
·
i tried "write to other table" but clay said that my input isnt a list
Muhammad S.
·
·
In chatgpt configuration can you turn this toggle on and rerun?
Daniil P.
·
·
Niceeeee!!!!!!
Daniil P.
·
·
thanks so much!
Daniil P.
·
·
here's my prompt. do i even need that if I have the toggle on?
Daniil P.
·
·
"Your job is to take plain text organized in a paragraph and return each line into JSON format as a list. Here's the text /people "
Muhammad S.
·
·
toggle must be on to return the data in the form which can be written to other table.
Daniil P.
·
·
or can i literally just tell gpt to "output /people"
Daniil P.
·
·
yeah it worked
Daniil P.
·
·
just not sure if the prompt needs to mention to output json or if the toggle does that for me?
Muhammad S.
·
·
Prompt needs to mention JSON + Toggle needs to be on
Daniil P.
·
·
Daniil P.
·
·
alright sweet!
Daniil P.
·
·
tysm
LuisArturo
·
·
Hey there Daniil thanks for reaching out and appreciate you jumping in Muhammad! Let us know if you have any other questions Daniil!
Channeled
APP
·
·
Hi Daniil P.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Daniil P.!