How to Split Portfolio Companies into Rows with Clayagent

Hello - Clay newbie here. I have a table set up where i'm using the clayagent Portfolio website researcher to find VC portfolio companies. The table outputs the list of companies in a single cell separated by comma. Im now trying to create a row for every portfolio company in this list. My understanding is that I need to Write to Other Table to do so. When I create a column using the function Write to Other Table and I source the Portfolio Companies Response Text Column the system is saying "Please add a valid list here". Any help here would be most appreciative.

18 comments

Channeled
APP
·
·
You can use the Write to Table function to break down your comma-separated list of portfolio companies into individual rows. Here's how to do it:1. First, select your Clay account (you'll need your API key if you haven't set up the integration yet). 2. Choose your destination table where you want the individual portfolio companies to appear. 3. Select the column that contains your comma-separated list of portfolio companies. 4. Map the list data to the appropriate columns in your new table. Each item in your list will become a separate row. 5. Optional: You can enable auto-update to automatically process new rows as they're added, and set conditions for when the function should run. Source: Write to Table - Clay University
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Gintas D.
·
·
Tanvi R.
·
·
Hey there, thanks for reaching out! Happy to take a look here for you
👋1
Gintas D.
·
·
Using the template Web Research Claygent for finding portfolio companies from a VC website. Its outputing as a comma-separated list but the write to other table is not recognizing as a list.
Morgann D.
·
·
That's because your response is in text. ask claygen to give a result in Json format, that will create a list you can then write to another table
Tanvi R.
·
·
Got it, thanks for clarifying! Morgann, is right - your response is currently not a list! You can see a list contains an icon with 3 lines as shown below. https://downloads.intercomcdn.com/i/o/w28k1kwz/1277725416/1b031e7dfee7577bdce08ea9f93b/CleanShot+2024-12-05+at+18_02_28%402x.png?expires=1733406300&signature=e1e4e1fb04a5cea276159bfb72a9aa75a539c1912d82af4f6bfa6464371d1808&req=dSIgEc58mIVeX%2FMW1HO4zcRzg5SQzVlrZBYGTY73h8lBJtHemEoWPSIMPfre%0AhvPZ%0A To create this list with your output, you will need to use the JSON Schema output format to return your result as JSON. This will create a list of array values that contain your outputs!
Tanvi R.
·
·
Here's a tutorial explaining how JSON Schema with AI columns work in Clay: https://www.loom.com/share/4f7b6e6ecba44811af419a1ae0932d1b?sid=d40537a0-ea03-4803-9add-567829078b14
Gintas D.
·
·
Okay I got it working. Follow up related to the template clayagent web researcher. I checked the VC website and noticed that the clayagent did not ouput all companies on the website. Do you have any suggestions on how I can get the entire list. I used the following prompt template:
Tanvi R.
·
·
Hey there, it looks like the prompt itself specifies to only return the names of 2-3 companies in the portfolio. If you'd like to pull all of the company names on this website, you can modify this in your prompt and use theAI metaprompter to optimize this!
Gintas D.
·
·
I did modify for all companies and it only returned 22. Should have been closer to 50. Is there a waterfall method I could do that would include Website scraper?
Morgann D.
·
·
If you have a source with 50 companies you want to use into clay, the best way is indeed to use a webscraper to create the list, then import it into Clay
Morgann D.
·
·
AI agent are not ideal for web scrapping (even if they work well)
Tanvi R.
·
·
Got it, yes a webscraper would work better here compared to Claygent Neon when pulling lists from the website.
Tanvi R.
·
·
Could you share an example of one of the websites you want to scrape? I'd recommend using the Zenrows enrichment to scrape a list from these websites programatically. Here's a tutorial on how to use Zenrows for web scraping: https://www.clay.com/university/lesson/deep-dive-zenrows-scraping-limitless-research
Channeled
APP
·
·
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
Gintas D.
·
·
no this good. Thanks for the help
Channeled
APP
·
·
Hi Gintas D.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: