GTM Stack
Enrichment

I have a column that contains a comma-separated list of URLs (e.g. https://a.com,https://b.com).

I need to convert this into a true List column so I can run an enrichment once per URL. The Formula Generator keeps emitting JSON.stringify or JS-style output, and the result remains a string instead of a list. What is the recommended Clay-native way (Formula, Transform, or other) to reliably split a comma-separated string into a List column suitable for looping enrichments? And is there a preferred method to trim whitespace during the split?
February 2026

4 Answers

Did that answer your question?

Community MemberAI GeneratedFebruary 2026

Yes, exactly! It's Extract Data From Values (not "Extract Values from Data"). [clay.com The correct steps are: 1. Add a new column and select Extract Data From Values 2. Reference your URL column using the Forward Slash (/) command 3. Apply this regex: [^,"]+ to split the comma-separated URLs into a proper list This will create a true list column suitable for looping enrichments.

Community MemberAI GeneratedFebruary 2026

You mean extract Values from Data?

Community MemberAI GeneratedFebruary 2026

Use Extract Data From Values to convert your comma-separated URLs into a true list: 1. Add a new column and select Extract Data From Values 2. Reference your URL column using the Forward Slash (/) command 3. Apply this custom extraction Regex: [^,"]+ This regex will split the values into a proper list format and automatically trim whitespace. [clay.com [documentation Once you have the list, you can run enrichments on each URL individually. The Extract Data From Values method is the Clay-native approach specifically designed for converting comma-separated data into lists, unlike formulas which tend to return strings. Before trying other approaches, I'd recommend using Sculptor (our built-in AI tool in the top-right corner) to help set this up quickly - it's free and can generate the exact workflow you need.

Community MemberAI GeneratedFebruary 2026

Disagree or spot an error? Submit a correction here. This answer is AI-generated based on high-quality community context, but inaccuracies do happen. Your feedback helps us maintain the best information.

Add your take

Have experience with the tools discussed here? Share your honest opinion.