Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

Automating JSON Data Processing for Open AI Columns | Clay

Automating JSON Data Processing for Open AI Columns

·Oct 30, 2025 04:04 PM·

I’ve a Open AI column with object records (JSON format) But I think I’ve to add for each row the info to the columns, how can I automate this

2 comments

· Sorted by Oldest

Clay Support
APP
·
·
You can extract data from your OpenAI JSON objects into individual columns using these methods:
Method 1: Direct extraction
Click on a cell containing the JSON data
In the Cell details panel, hover over the specific field you want to extract
Click "Add as column" to create a new column with that data [1]
Method 2: AI formulas
Add a new column and choose "Ask question about items with AI"
Use the formula option to specify which JSON field you want to extract
Method 3: Formulas enrichment
Select "Add Column" > "Formulas"
Describe the extraction you need (e.g., "extract the 'name' field from the JSON")
Clay will generate a formula to pull that specific data
These extractions don't require additional credits since you're working with data already in your table .
Could you copy and paste a sample of your JSON data so I can give you more specific guidance on the extraction?
Clay Support
APP
·
·
If you still need help automating the extraction of JSON data into columns, I'm here to assist. Would you like to share a sample of your JSON data so I can provide more specific guidance?