Fixing ChatGPT Enrichment Response Values in Excel

Hi team In a ChatGPT enrichment, I am getting the values "Response" or "[object Object]" in the enrichment column. I have created two columns to the right to display the enrichment responses in the table. If the value in the enrichment column is "Response", the response values are moved to the column on the right. However, if the value is "[object Object]", the columns with the responses remain blank. How can I fix this?

5 comments

Channeled
APP
·
·
To fix this issue and display the ChatGPT enrichment responses in your table, you'll need to create child columns from the parent enrichment column. Here's how: 1. Click on a cell in the enrichment column that contains "[object Object]". This will open the Cell details panel on the right. 2. In the panel, you'll see the specific endpoints (data points) from the enrichment. 3. Hover over the endpoint you want to display and click Add as column on the right. 4. You can either: • Create a new column by entering a description and clicking Create column • Map the data to an existing column by selecting it under Map to an existing columnThis will properly display the enrichment responses in your table instead of showing "[object Object]".For best results, make sure your enrichment has the proper data before running by using the Required to Run toggle in the Prompt Editor. This helps avoid errors from empty or incomplete rows. Sources: Referencing dynamic data from other columns | Documentation | Clay University Table columns overview | Documentation | Clay University
Channeled
APP
·
·
Was that helpful?
Channeled
APP
·
·
Great! I'm glad I could provide the information you needed. I'm here if you have any more questions.
Channeled
APP
·
·
Hi Joan C.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
I'm delighted to hear that! I'm here if you need any further assistance.