Automate Crunchbase Investor Data Collection
detail.loadingPreview
Effortlessly gather daily investor data from Crunchbase and automatically populate your Google Sheets. This workflow automates data extraction and organization, saving you valuable time.
About This Workflow
This n8n workflow streamlines the process of acquiring critical investor intelligence from Crunchbase. It begins by scheduling a daily trigger to initiate data collection. The workflow then leverages the Crunchbase API to fetch detailed information on organizations identified as investors, including their name, description, location, and investment stage. Subsequently, a code node precisely extracts the desired fields, ensuring only relevant data is processed. Finally, this curated investor data is seamlessly appended to a designated Google Sheet, providing a continuously updated and easily accessible database for your investment research and outreach efforts. Eliminate manual data entry and gain a competitive edge with automated insights.
Key Features
- Scheduled Data Collection: Automatically fetch new investor data daily at your preferred time.
- Targeted Investor Filtering: Specifically retrieve data for organizations classified as investors.
- Key Data Extraction: Collect essential investor details like name, description, location, and investment stage.
- Seamless Google Sheets Integration: Automatically append new investor information to a pre-defined Google Sheet.
- No-Code Automation: Built with n8n, requiring no coding expertise to set up and run.
How To Use
- Set the Schedule: Configure the "Daily Investor Data Trigger" node to define the time of day you want the workflow to run (e.g., 9 AM daily).
- Configure Crunchbase API Access: In the "Fetch Crunchbase Investor Data" node, replace
YOUR_CRUNCHBASE_API_KEYwith your actual Crunchbase API key in the Authorization header. - Define Data Fields: Review the
field_idsandqueryparameters in the "Fetch Crunchbase Investor Data" node to customize the type of investor data you wish to retrieve. - Verify Data Extraction: The "Extract Investor Fields" node is pre-configured to extract common investor details. Adjust the
jsCodeif you need to extract additional or different fields. - Connect Google Sheets: In the "Append to Investor Sheet" node:
a. Specify Google Sheet: Enter your Google Sheet's
documentIdand ensure thesheetNameis correctly configured. b. Map Columns: Map the extracted investor fields ($json.name,$json.short_description, etc.) to the corresponding column headers in your Google Sheet. c. Authorize Access: Ensure your Google Sheets credentials are properly set up and authorized within n8n.
Apps Used
Workflow JSON
{
"id": "13058496-4c4d-4379-8782-6c30d0ff5cc8",
"name": "Automate Crunchbase Investor Data Collection",
"nodes": 26,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 13058496-4c4d...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.