Scrape Crunchbase Recent Funding Rounds to Google Sheets

This n8n workflow scrapes the latest funding rounds (Series A and B announced within the last day) from Crunchbase using the Piloterr API. It retrieves comprehensive data including company name, funding amount, investors, LinkedIn profiles, estimated monthly traffic, employee count, and more, processing results into individual items for easy handling.

The workflow splits the API responses to manage multiple results efficiently, enabling seamless integration with Google Sheets where all data is appended in a structured format. This eliminates manual scraping, API wrangling, or spreadsheet updates, saving hours of research time.

Benefits include building a real-time database of funded startups for targeted outreach, setting up custom alerts via integrations, and gaining competitive intelligence. Use cases: sales teams hunting warm leads, VCs scouting deals, market researchers tracking trends, or BD pros timing pitches perfectly. Full setup guide available via linked Notion page.