When I export a table to CSV , if I run an enrichment like enrich profile or company profile, it doesnt show the json in the doc. i want to feed the json with all the info to chatgpt so it selects the exact inputs we should use for our pormpts etc. how is this possible?
CSV exports mirror your Clay table exactly, but object fields (like enrichment JSON data) won't display raw data values in the export. To access the full JSON data from enrichments, you can use a formula called "stringify" to get the entire profile JSON into one cell for analysis. This allows you to work with the complete JSON structure within Clay before exporting. Alternatively, create a dedicated "CSV Export View" by duplicating your current view and including only the specific JSON fields you need for ChatGPT analysis.
person
agent
Hello Edward! Thanks for reaching out! You would have to extract the json into individual columns before exporting it. CSV will not support nested columns so for them to show up this would be the best solution!
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.
hey
any updates?
?????
