Automated Fundraising Data Collection

This workflow is ideal for:

• Entrepreneurs looking to track recent fundraising events to identify potential investors or partners.
• Startups wanting to monitor funding activities in their industry to stay competitive.
• Investors seeking to discover new investment opportunities based on recent funding rounds.
• Data Analysts who need to aggregate and analyze fundraising data efficiently.
• Marketing Teams aiming to understand market trends and company growth through funding activities.

This workflow automates the process of scraping recent fundraising events from Crunchbase and populating that data into Google Sheets. It eliminates manual data entry, reduces errors, and saves time by providing a streamlined method for tracking investment activities, specifically in the Series A, Series B, and Seed funding categories.

1. Schedule Trigger: The workflow is set to run daily at 8 AM, ensuring that users receive the latest funding data without manual intervention.
2. API Requests: It fetches recent fundraising events from Piloterr using three separate HTTP requests for Series A, Series B, and Seed funding rounds, focusing on events announced within the last 24 hours.
3. Data Splitting: The results from the API are split into individual records for further processing.
4. Data Preparation: Each record is enriched with additional details like company name, funding amount, and event links through a series of transformation nodes.
5. Company Enrichment: The workflow enriches company information by making additional API calls to gather more insights, including LinkedIn URLs and employee counts.
6. Data Merging: All processed data is merged together to create a comprehensive dataset.
7. Google Sheets Integration: Finally, the enriched data is appended or updated in a specified Google Sheets document, allowing users to access and analyze the latest funding data easily.