How to Split Portfolio Companies into Rows with Clayagent

Gintas Dirse · 2024-12-05 12:16:39.290841+00

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.

How to Split Portfolio Companies into Rows with Clayagent | Clay

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 Dirse
·
·
Tanvi (Clay)
·
·
Hey there, thanks for reaching out! Happy to take a look here for you
👋1
Gintas Dirse
·
·
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 Dawance
·
·
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 (Clay)
·
·
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 (Clay)
·
·
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 Dirse
·
·
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 (Clay)
·
·
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 Dirse
·
·
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 Dawance
·
·
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 Dawance
·
·
AI agent are not ideal for web scrapping (even if they work well)
Tanvi (Clay)
·
·
Got it, yes a webscraper would work better here compared to Claygent Neon when pulling lists from the website.
Tanvi (Clay)
·
·
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

17 comments