Extracting Nested Values from hd_insights Output for Analysis

Willy H. · 2025-12-10T03:00:47.096Z

How do I get the two values that are nested in the hd_insights output to a cell as a comma separated value? I want to be able to run an anthropic model to write an email based on what it finds or do an analysis.

Clay Support
APP
·
·
Use Extract Values from Data to get your product names as comma-separated values: [1]
1.
Add a new column and select "Extract Values from Data"
2.
Input your HG Insights column as the data source
3.
Set extraction type to extract product names
4.
This will create a list of the product names
For comma-separated format, use the regex pattern [^,"]+"?[^,"]+ to split the values properly. [2]
Once extracted, you can feed this comma-separated list directly into your Anthropic model for email writing or analysis. [3]
Willy H.
·
·
Okay, yes, but there are 2 providers in this waterfall. How do I make sure we account for all of them?
Clay Support
APP
·
·
To capture data from all providers in your waterfall, use "Extract Values from Data" on each provider column separately, then combine them.
Option 1: Extract from each HG Insights column individually, then use a Formula to merge the results into one comma-separated list. [1]
Option 2: Use AI Formula on the combined data - prompt it to "extract all product names from both providers as a comma-separated list, removing duplicates."
This ensures you get complete coverage from your entire waterfall setup.
Clay Support
APP
·
·
Is that what you were looking for?
Willy H.
·
·
look good?
Clay Support
APP
·
·
Perfect setup! You've correctly selected both waterfall columns as data sources and set it to Custom extraction with regex. [1]
That regex pattern will extract the product names from both providers and combine them into your comma-separated list. [2] Run it and you'll get all products from your entire waterfall in one cell, ready for your Anthropic model.
Clay Support
APP
·
·
Did that answer your question?
Willy H.
·
·
I want all items
Clay Support
APP
·
·
Change the dropdown from "first item" to "all items" or use "Joined Matches" instead. [1] This will extract all products from both waterfall providers as a comma-separated list rather than just the first match.
Clay Support
APP
·
·
Does that help?
Willy H.
·
·
human
Clay Support
APP
·
·
Would you like me to connect you with a human agent? Or if you provide more details about what you need, I can continue to assist you.
Willy H.
·
·
yes
Clay Support
APP
·
·
I’m routing you to our human team now. They’ll be able to assist you further.
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon! We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
image.png(93 kB)

26 comments