Automated Crunchbase Funding Intelligence to Google Sheets - n8n Workflow

Venture Capital (VC) Analysts and Associates needing market intelligence.
Business Development teams tracking competitor funding.
Market Researchers focused on specific technology sectors (Fintech, Healthtech).
Users looking for advanced examples of an n8n workflow using external APIs and custom data transformation.

Keeping track of new funding rounds across specialized industries like Fintech and Healthtech is crucial but time-consuming. This specialized n8n workflow solves this by operating as an automated market intelligence agent. By utilizing an n8n trigger set to run daily, the system queries the Crunchbase API for the freshest data, filters it by location and industry, and seamlessly deposits the clean results into Google Sheets. This highly efficient n8n automation eliminates manual tracking, providing users with a real-time, customizable database ready for analysis and reporting. Implementing this powerful n8n template will fundamentally change how you approach competitive intelligence.

This automation operates in four distinct phases using various components of the n8n platform:

1. Triggering the Check: The process starts with the Schedule n8n trigger, configured to run daily at 8:00 AM. This ensures the workflow checks for new data at the start of the business day.


2. API Data Fetching: The HTTP Request n8n node contacts the Crunchbase API. It's configured with specific query parameters to filter funding rounds in the 'United States' and focus on 'Fintech' and 'Healthtech' sectors, sorting by the most recently created entries.


3. Data Transformation: The Code n8n node intercepts the complex JSON response from Crunchbase. It executes a JavaScript script to extract critical fields (Company Name, Amount Raised, Investors, Industry, URL) and transforms them into a clean, structured output item ready for logging. This custom n8n node is vital for standardization.


4. Logging to Spreadsheet: Finally, the Google Sheets n8n node takes the standardized data payload and executes the 'Append' operation. It automatically adds a new row for every funding round found in the target Google Sheet, creating a living database of investment activity. This completes the data logging process of the n8n workflow.

To set up this powerful n8n template, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON code and paste it into your n8n instance using the 'New' button and selecting 'Import from JSON'.


2. Crunchbase Credentials: Locate the 'Fetch Crunchbase Funding Rounds' HTTP Request n8n node. You must replace the placeholder YOURAPIKEY in the X-cb-user-key header parameter with your actual Crunchbase API key.


3. Google Sheets Setup: Click on the 'Log to Google Sheets' n8n node. You will need to set up a new Google Sheets OAuth2 API credential if you haven't already. Then, select the specific Google Document ID and the Sheet Name where you want the funding data to be logged. Ensure the sheet headers match the fields defined in the workflow (e.g., 'company name', 'industry').


4. Activation: Once credentials are set, activate the n8n workflow to allow the Schedule n8n trigger to run the automation daily.

Daily Check for New Funding Rounds (Schedule Trigger n8n node):
Function: Serves as the primary n8n trigger, initiating the data collection process.
Key Configuration: Runs on a daily interval, scheduled for 8:00 AM.

Fetch Crunchbase Funding Rounds (HTTP Request n8n node):
Function: Connects to the Crunchbase v4 API to retrieve the list of recent funding rounds.
Key Configuration: Uses Query Parameters to filter by Location ('United States') and Industry ('Fintech, Healthtech'). Requires an API key in the X-cb-user-key header.

Extract & Format Funding Data (Code n8n node):
Function: This custom n8n node performs crucial data mapping and cleaning, converting raw API output into structured fields (e.g., companyname, moneyraised_usd).
Key Configuration: Custom JavaScript code iterates over entities, extracts specific properties, formats investor lists into a single string, and generates the definitive Crunchbase URL.

Log to Google Sheets (Google Sheets n8n node):
Function: Writes the clean, structured output items produced by the Code n8n node into the designated spreadsheet.
Key Configuration: Operation set to Append. Maps the seven output fields (e.g., company name, money raised usd, crunchbase url) directly to corresponding columns in the spreadsheet. This is the final step in this useful n8n workflow.