Using JSON Format: How to Output LinkedIn Profiles into New Columns for Cross-Referencing Emails?

Hello All, How do you use the Json format? I use claygent to give me 5 linkeldn profiles to use as a Lead magnet as inspired by Eric N. but Iam struggling to find a way to output each 5 into new columns so i cross reference their email. Sometimes i have names and position in "Results" and the linkeldn Url in the "Reasoning" or sometimes I have the names and linkeldn Url in the "Result".

✅1

10 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 😉
Jean M.
·
·
https://app.clay.com/workspaces/160947/tables/t_CbPz6U3VwB13/views/gv_NMiiw2nQpWn2
Eric N.
·
·
I use AI to seperate the links by commas Then the formula editor to separate those properly Then I enrich
👍1
Jean M.
·
·
The problem I have is for company A the links will be on "Results" and company B will be on "Reasoning"i am usimg claygent
Clay Team
APP
·
·
Hey Jean!! Happy to jump in. And yeah, it's quite tricky sometimes to get Claygent to return everything in one go because it may think it's looking for something else and separate it in the other sections.
Clay Team
APP
·
·
You can still use the formula generator to ask it to extract any URLs as a comma-separated string from any of those two sections. Not sure if the example I added helps
Jean M.
·
·
Hey Arturo O. how will I do that?
Clay Team
APP
·
·
Hey Jean, I actually added an example all the way at the end of your table, but not sure if that was the goal or value you were looking for. It's the final column
Jean M.
·
·
ok let me see
Jean M.
·
·
I cant see but I resolve the issue, I focused the ai enrichment on "steps taken" variable instead of reasoning
:sparkles-clay:1