Convert Clay Column Text to JSON for Data Manipulation

·

How do I convert text in a Clay column to JSON that I can and manipulate in other columns

· Sorted by Oldest

Channeled
APP
·
·
To convert text to JSON in Clay: 1. Use the ChatGPT integration with "Return as JSON Object" enabled 2. Make sure your prompt includes the word "json" 3. Define column outputs to structure the response When working with JSON, ensure proper formatting: ** Use double quotes for keys and strings ** Separate key-value pairs with commas * Format arrays and objects correctly with brackets If you're having formatting issues, please paste your JSON here so I can help troubleshoot further.
Sources: HTTP API integration overview | Documentation | Clay University ChatGPT: Generate text with OpenAI/GPT
Bo (.
·
·
If your column contains JSON as text, you can use a formula to parse it and extract specific values. Feel free to send the table URL if you want help setting it up directly.

Channeled
APP
·
·
To convert text to JSON in Clay: 1. Use the ChatGPT integration with "Return as JSON Object" enabled 2. Make sure your prompt includes the word "json" 3. Define column outputs to structure the response When working with JSON, ensure proper formatting: ** Use double quotes for keys and strings ** Separate key-value pairs with commas * Format arrays and objects correctly with brackets If you're having formatting issues, please paste your JSON here so I can help troubleshoot further.
Sources: HTTP API integration overview | Documentation | Clay University ChatGPT: Generate text with OpenAI/GPT
Bo (.
·
·
If your column contains JSON as text, you can use a formula to parse it and extract specific values. Feel free to send the table URL if you want help setting it up directly.