This template runs every day, fetches recent seed, Series A, and Series B rounds from Crunchbase through the Piloterr API, and writes company, amount, stage, and LinkedIn URL into Google Sheets. Use a JavaScript node to call the Piloterr API. Put the Piloterr API key in that JavaScript node. Connect Google Sheets and point it at the spreadsheet you keep for outreach.
Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.
Full pricing — how CPU seconds work →Workflow preview
The scenario starts each day at the time you set.
JavaScript calls Piloterr for recent seed, Series A, and Series B rounds and pulls extra company fields. Put the Piloterr API key in that JavaScript node.
An iterator walks each round. JavaScript maps company, amount, stage, traffic, headcount, and LinkedIn URL.
Google Sheets adds a row per round. Keep a Crunchbase id column so later runs can skip rounds you already logged.
Add a schedule. Daily in your timezone is enough for a funding snapshot.
Add a JavaScript node that requests recent fundraise data from Piloterr and enriches each company. Put the Piloterr API key in that JavaScript node.
Add a Google Sheets connection. Use a sheet with columns for company, amount, stage, LinkedIn URL, and Crunchbase id.
Iterate the rounds and add a Google Sheets row for each one. Look up the Crunchbase id first if you want to skip rounds you already stored.
FAQ
More templates
This template runs a local-business Google search with Serper on a schedule, maps name, address, phone, and rating in JavaScript, and appends the batch to Google Sheets. Put the search query and location on the Serper step. Connect Serper and Google Sheets, then put the Serper API key on the Serper connection.
This template starts when a webhook receives a destination, scrapes Booking.com hotel listings with Bright Data, and asks ChatGPT for a short list with title, address, original price, and final price. JavaScript calls Bright Data and maps those fields. Supabase stores the rows. Put the Bright Data API key in that JavaScript node. Connect Supabase. ChatGPT is a Latenode AI step.
This template reads a username list from Google Sheets, runs your Apify Instagram profile actor, and writes cleaned profile fields back to the sheet. A schedule starts each batch. JavaScript maps username, bio, and follower counts, then Google Sheets appends the row and marks the username as done. Connect Apify and Google Sheets. Put the Apify API key on the Apify connection.
