Scheduled Import of Piloterr Serie A Funding Rounds to Google Sheets

Item Lists

Complex Trigger

This n8n workflow automates the scheduled import of recent "Serie A" funding round data. It begins by making an HTTP request to the Piloterr API's Crunchbase endpoint, specifically targeting funding rounds, to fetch the latest information. Once the data is retrieved, the workflow processes the response by splitting the main results array into individual items. A series of Code nodes then perform custom transformations, filtering, and data preparation, ensuring the information is accurately formatted and structured. This processed funding round data is subsequently imported and updated into one or more Google Sheets. The workflow ensures that a designated Google Sheet consistently contains the most up-to-date Serie A funding details, thereby eliminating manual data entry, reducing human error, and providing a reliable, automated source for financial analysis and tracking.