Converting AI JSON Output to a Contact Table with Separate Columns

Michiel v. · 2025-04-25T13:44:54.54024+00:00

I have a list of companies. In a new column I have used an AI search to find Contacts at these Companies. The AI search returns a JSON response containing: Name, Job Title, Work Email, LinkedIn profile for several Contacts at a company. How can I convert this JSON output to a new Contact table where 1 row is 1 contact and Name, Job Title, Work Email, and LinkedIn profile are separate columns?

To convert your JSON response into a new Contact table, you can use our "write to table" feature. Here's how: 1. Create a new table in Clay for your contacts. 2. Use the "write to table" action to import your JSON data. 3. Map the JSON fields to your new table columns: • Name • Job Title • Work Email • LinkedIn profile This will create a new row for each contact, with separate columns for each field. If you're having trouble with the JSON formatting, please copy and paste it into the chat so we can help troubleshoot further. Need more assistance? Just ask to talk to a person for human support.

Source: Enrich Person with Apollo.io | Clay.com

2 comments