Use formula to parse the json

Rana · 2025-10-30 16:05:13.421517+00

Use formula to parse the json If there is no dynamic column

To parse JSON using formulas in Clay:

1.
Add a new column and select Formula
2.
In the AI Formula Generator, describe what you want to extract (e.g., "Extract the value from {{JSON Column}}.keyName")
3.
Use / to reference the column containing your JSON
4.
Click Generate Formula and review the output [1]

If you're seeing [object Object] errors, you need to specify the exact JSON key you want. For example, if your column references .response but you need a value inside it, update the formula to reference the specific key like .response.LinkedInOutreachMessage.

Can you paste your JSON into the chat? This will help me provide specific guidance on the exact formula you need.

2 comments