Automated Crunchbase Investor Data to Google Sheets

This n8n workflow automates the process of fetching, processing, and storing investor data from Crunchbase into a Google Sheet, enabling streamlined data collection without manual effort. It is ideal for market research, investor tracking, and strategic analysis. The workflow begins with a scheduled trigger that runs daily, sending a POST request to Crunchbase’s API to retrieve a list of investors with specific fields such as name, description, location, and investment stage. The raw data is then cleaned and formatted using a code node to extract relevant fields, which are subsequently appended to a Google Sheet. This automation helps users maintain up-to-date investor databases effortlessly, making it suitable for venture capitalists, analysts, and business strategists.