I have a crunchbase pro account and a list of 1600 companies in clay that I'd like to enrich with funding data. Ideally, I don't use the crunchbase integration within Clay because of credit cost AND I'm already paying for crunchbase pro.
what's the best way to get funding data in Clay, ideally using crunchbase? or a zap or something?
You can use Zenrows scraping to extract Crunchbase funding data without using Clay credits. Here's how: 1. Set up a Zenrows scrape in your Clay table that targets Crunchbase URLs for each company 2. Configure the scrape with: • Auto-parse enabled • JavaScript rendering with Premium Proxy • Anti-bot measures activated First, you'll need to find the Crunchbase links for your companies. You can do this by: 1. Adding a column that runs a Google search to find each company's Crunchbase link 2. Confirming the links are correct 3. Using Zenrows to scrape those links for funding information This approach lets you leverage your existing Crunchbase Pro access while avoiding Clay's Crunchbase integration credit costs. The scraped data can then be refined using Clay's column extraction tools or AI formulas.
hm. given I already pay for crunchbase, I'm wondering if there's a better way to do this.
does anyone have experience using a crunchbase zap to clay on an existing table?
Yes, you can use Zapier to send Crunchbase data to your existing Clay table. Here's how: 1. Set up a Zap with Crunchbase as the trigger and Clay as the action 2. Use the "Clay" action in Zapier and select "Create a new record in a table" 3. Connect your Clay account using your API key (found in Clay under Settings > Account > API key) 4. Configure the Zap to send the Crunchbase funding data to your specified Clay workspace and table Alternatively, you could: 1. Create a column in your Clay table that finds Crunchbase links via Google search 2. Use Zenrows scraping to extract funding data directly from those Crunchbase pages 3. This approach leverages your existing Crunchbase Pro access while avoiding Clay's integration credit costs Both methods allow you to enrich your existing table with funding details like total funding, latest round, investors, and more.
if I were to do the zenrows approach, does that use clay credits to scrape the crunchbase data?
Yes, using Zenrows to scrape Crunchbase data will consume Clay credits. Zenrows is integrated into Clay as a scraping tool that allows you to bypass Crunchbase's anti-scraping measures. While Zenrows offers powerful scraping capabilities at a "remarkably low cost," it still uses credits when run through Clay's interface. However, you do have the option to use your own Zenrows account instead of the Clay-managed one. When setting up the Zenrows integration: 1. Click "Add enrichment" and search for "Zenrows" 2. Select the Zenrows action 3. Choose "+ Add Account" to connect your personal Zenrows account This approach would allow you to leverage your Crunchbase Pro access while potentially managing costs through your own Zenrows account rather than using Clay credits.
you can actually import a list in CB with name and domain, enrich and bring back to clay
how do i do that?
You can efficiently move data between Crunchbase and Clay using this workflow: 1. Export your company list from Clay as a CSV file 2. Import this list into Crunchbase using their bulk import feature (with company names and domains) 3. Enrich the data in Crunchbase using your Pro account 4. Export the enriched data from Crunchbase as a CSV 5. Import this enriched CSV back into your Clay table Alternatively, you could use Clay's Crunchbase integration directly by: 1. Adding enrichment in your Clay table 2. Searching for "Crunchbase" 3. Selecting one of the Crunchbase actions like "Enrich a company's funding details" 4. Using company domains as input This approach uses Clay credits but provides seamless integration without manual CSV handling.
Here's how to move data between Clay and Crunchbase Pro: 1. Export your company list from Clay: • Open your Clay table with the companies • Click Actions > Import > Import Companies From a CSV (this shows the export option too) • Download your table as a CSV 2. Import and enrich in Crunchbase Pro: • Log into your Crunchbase Pro account • Use their bulk import feature with your CSV • Enrich the data using your Pro account features • Export the enriched data as a CSV from Crunchbase 3. Import back to Clay: • Open your Clay table • Click Actions > Import > Import Companies From a CSV • Upload your enriched CSV • Select "Add to current table" to merge with existing data This approach lets you leverage your Crunchbase Pro subscription without using Clay's Crunchbase integration credits.
Here's how to move data between Clay and Crunchbase Pro: 1. Export your Clay table: • Open your table with the companies • Click Actions > Import > Import Companies From a CSV • Download your table as a CSV 2. Import to Crunchbase Pro: • Log into your Crunchbase Pro account • Use their bulk import feature with your CSV (typically includes company names and domains) • Enrich the data using your Pro subscription features • Export the enriched data as a CSV 3. Import back to Clay: • Open your Clay table • Click Actions > Import > Import Companies From a CSV • Upload your enriched CSV • Select "Add to current table" to merge with existing data This approach lets you leverage your Crunchbase Pro subscription without using Clay's Crunchbase integration credits.
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.
.png){kind=logo}
