Latenode
Headless browser
Google sheets

Automatically Sync Crunchbase Funding Data to Google Sheets

This automation workflow is designed to help users easily track and monitor recent funding rounds from Crunchbase.

By leveraging the Piloterr API, the workflow automatically scrapes the latest funding data, enriches it with additional company information such as LinkedIn URLs, website traffic, and employee count, and then saves the consolidated data in a Google Sheets spreadsheet. This enables users to create a custom database of interesting leads, set up custom alerts, and stay up-to-date on the latest funding activities in their industry or market of interest.

Updated Apr 2, 2026Est. run: 21sEst. cost: $0.0013
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. 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 credits work →
Scraping & data collection

Workflow preview

What this template does

  • Extracts recent funding round data from Crunchbase using an API
  • Enriches the funding data with additional company details like LinkedIn URLs, website traffic, and employee count
  • Stores the consolidated funding and company data in a Google Sheets spreadsheet
  • Enables users to create a custom database of interesting leads
  • Allows users to set up custom alerts for new funding activities in their industry

How it works

1
Trigger

Schedule Workflow to Run Daily

This automation workflow is scheduled to run every day, ensuring that the latest funding round data from Crunchbase is regularly fetched and updated in the Google Sheets spreadsheet.

2
Action

Fetch Recent Funding Rounds

The workflow leverages the Piloterr API to automatically scrape the latest funding data, including Series A, Series B, and seed funding rounds.

3
Logic

Organize and Enrich Funding Data

The raw API response data is split into individual items and then transformed into a format suitable for importing into the Google Sheets spreadsheet. Additional company information, such as LinkedIn URLs, website traffic, and employee count, is also fetched and added to the data set.

4
Action

Save Data to Google Sheets

The consolidated and enriched funding data is then appended or updated in the specified Google Sheets spreadsheet, allowing users to create a custom database of interesting leads, set up custom alerts, and stay up-to-date on the latest funding activities in their industry or market of interest.

Setup guide

1

Add Google Sheets credential

1. In the Latenode Credentials panel, add a new Google Sheets credential by connecting your Google account using OAuth. 2. Authorize Latenode to access your Google Sheets data.

2

Configure Piloterr API credential

1. In the Latenode Credentials panel, add a new Piloterr credential by entering your Piloterr API key. 2. Ensure the API key is stored securely in the Latenode Secrets panel.

3

Set up Google Sheets output

1. Add a Google Sheets node to your workflow. 2. In the node settings, select the Google Sheets credential you configured earlier. 3. Specify the Google Sheets document ID and sheet name where you want to save the funding round data.

4

Configure Crunchbase funding round data fetch

1. Add a Piloterr node to your workflow. 2. In the node settings, select the appropriate Piloterr API endpoint to fetch recent funding rounds (e.g., 'Get Recent Fundraise - Serie A'). 3. Map the output data to the Google Sheets node fields.

5

Enrich company data

1. Add another Piloterr node to your workflow. 2. In the node settings, select the 'Enrich company' API endpoint to fetch additional company details. 3. Map the enriched data to the Google Sheets node fields.

Requirements

Connect a Google Sheets workspace to the workflow
Configure the Crunchbase API credentials and access in the workflow
Set up a headless browser session in the Latenode workspace to scrape the Crunchbase website
Enrich the scraped funding data with additional company details such as LinkedIn URLs, website traffic, and employee count

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →
Scraping & data collection

Scrape and export Google Maps business data to Google Sheets

This automation allows users to efficiently scrape business data from Google Maps, including names, contact details, and reviews, and export the structured information into a spreadsheet or database for lead generation and market analysis. The workflow triggers manually or on a scheduled basis, fetching search results from Google Maps using the SerpAPI service, deduplicating the data, and writing it to a Google Sheet. This streamlines the process of gathering valuable business intelligence from Google Maps, empowering users to leverage this data for strategic decision-making and sales prospecting.

11s$0.0007
Scraping & data collection

Scrape Zillow property data and sync to Google Sheets automatically

This Latenode automation extracts real estate listing details from Zillow and automatically populates a Google Sheets spreadsheet with the property data. It leverages the Scrape.do web scraping API to bypass anti-bot protections and fetch the full HTML of Zillow listings, then parses key information like price, address, days on Zillow, and Zestimate, and saves the structured results into a Google Sheet. This solution is designed for real estate professionals, investors, and market analysts who need to collect property data at scale without manual effort, enabling better market research, portfolio tracking, and lead generation.

9s$0.0006
Scraping & data collection

Automate Instagram profile data export to Google Sheets

This automation template allows users to scrape comprehensive Instagram profile data using the Apify platform, and automatically export the results into a Google Sheets spreadsheet for analysis. It is designed to run on a schedule, processing a list of usernames by calling the Apify API, appending the scraped data to a Google Sheet, and marking the usernames as processed. The automation integrates with Google Sheets and the Apify actor, providing a streamlined way to gather and organize Instagram profile information without manual intervention.

15s$0.0009