Need Help Parsing AI Research Prompt Results into JSON Format

Jill M. · 2025-11-11 23:01:42.578917+00

Posting here for any ideas, I have an AI research prompt that is returning multiple names, linkedin and titles all in one string. I cannot seem to parse this with a formula into a JSON that write to table can use? I really don't want to use another AI to parse and charge credits just to be able to write this return into another table. Is there anyway to formula parse into a JSON for the Select List from a Column functionality in Write to Table?

Need Help Parsing AI Research Prompt Results into JSON Format | Clay

Clay Support
APP
·
·
You can use our Formulas feature to split your combined string data without using additional AI credits.
For parsing multiple names and titles from one string:
1. Add a new column and select Formulas
2. In the AI formula generator, specify operations like "Extract first name from string" or "Extract job title from third segment"
3. Use the / command to reference your source column
For comma-separated data specifically, you can use Extract Data From Values with this regex: [^,"]+\"?[^,"]+ to split values into a list.
Could you copy and paste the JSON structure you're working with so I can provide more specific guidance for your parsing needs?
Jill M.
·
·
This is my formula
Jill M.
·
·
JSON.stringify(({{Decision Makers}}||"")?.split("---")?.map(s=>({name:(s?.match(/Name:\s*([^\n\r]+)/i)||[])[1]||"",title:(s?.match(/Title:\s*([^\n\r]+)/i)||[])[1]||"",linkedin:(s?.match(/LinkedIn:\s*([^\n\r]+)/i)||[])[1]||""}))?.filter(o=>o?.name||o?.title||o?.linkedin))
Clay Support
APP
·
·
Your formula looks good for parsing the data structure. The issue might be with how Write to Table handles the JSON output.
Try removing JSON.stringify() from your formula since Write to Table expects the actual array/object structure, not a stringified version.
So your formula would be:
(#{{Decision Makers}}||"")?.split("---")?.map(s=>({name:(s?.match(/Name:\s*([^ \r]+)/i)||[])[1]||"",title:(s?.match(/Title:\s*([^ \r]+)/i)||[])[1]||"",linkedin:(s?.match(/LinkedIn:\s*([^ \r]+)/i)||[])[1]||""}))?.filter(o=>o?.name||o?.title||o?.linkedin)
If you're still getting [object Object] errors, you'll need to reference specific keys from your parsed data.
Can you paste the exact output you're seeing from your current formula?
Jill M.
·
·
I get invalid formula when I try your recommendation.
Jill M.
·
·
Here is a sample of the output from my formula
Jill M.
·
·
[{"linkedin":"https://www.linkedin.com/in/clarenceafoster","name":"Clarence Foster","title":"Business Information Security Officer (BISO)"}]
Clay Support
APP
·
·
Your JSON output looks correct - it's a valid array with objects containing the right structure. The "invalid formula" error when removing JSON.stringify() suggests Write to Table needs the stringified version after all.
Since your current formula with JSON.stringify() is working and producing valid JSON, try using it as-is in Write to Table. For the "Select List from a Column" functionality, you can reference specific keys from your parsed data like /name, /title, or /linkedin to extract individual values.
If you're still getting [object Object] errors, make sure you're referencing specific keys rather than the entire object.
Can you copy and paste the exact error message you're seeing in Write to Table when using your current formula?
Jill M.
·
·
I get "Please add a valid list here." when I reference this in the select list from a column
Clay Support
APP
·
·
The "Please add a valid list here" error happens because Write to Table expects the actual array structure, not a stringified JSON. Try adding your formula column through the "Other data from this table" section instead of directly referencing it in the select list field.
Your current JSON output shows a valid array structure, so this should work once you add it through the correct section.
Can you copy and paste your exact formula into the chat so I can see if there are any formatting issues causing the error?
Jill M.
·
·
I already did. Can I speak with a human?
Clay Support
APP
·
·
I understand your frustration, and I’ll connect you to a human agent who can assist you further.
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
image.png(93 kB)
Jill M.
·
·
https://app.clay.com/workspaces/745725/workbooks/wb_0t4wjccyyG3ekjg2Y2D/tables/t_0t59y63B2cyt6ZkEdZM/views/gv_0t59y638ARv2Hirtjxe
Munnawar H.
·
·
Hi Jill,
Thank you for reaching out to the support team. Is the current issue you have that you wish to output the results from an AI prompt into a JSON? Can you send me a link to the table that you're working on so I can dive in and take a look?
I look forward to your response.

20 comments