Automated Startup Data Collection and Enrichment

This n8n workflow streamlines the process of collecting, enriching, and storing startup information. Triggered by a simple form submission, it captures a startup’s name or website, then automatically updates an external database via the Extruct API. It continuously checks the status of the data processing, retrieves the enriched details once ready, formats the data, and finally appends it to a designated Google Sheet. This automation is ideal for entrepreneurs, startups, or business analysts who want to compile comprehensive startup profiles effortlessly.

The workflow begins with a form trigger where users submit a company name. The ‘Enrich form input’ node sends this information to Extruct’s API to initiate data enrichment. The process then involves polling the status via the ‘Get status’ node, waiting in a loop until the data is marked as ‘running’, indicating completion. Once processed, the ‘Get data’ node retrieves the enriched data, which is then formatted into a flat structure suitable for spreadsheet input by the ‘Format last input’ node. The final step appends the enriched startup profile into a specified Google Sheets document, facilitating real-time data collection and analysis.

This workflow is highly useful for maintaining an up-to-date startup database without manual input, allowing quick data management and analysis for investors, accelerators, or market researchers.