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.
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.
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.
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.
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!