Latenode
JavaScript
Google sheets

Automatically sync Crunchbase funding rounds to Google Sheets

This automation workflow is designed to help businesses and marketers stay on top of the latest funding activity in their industry. It automatically scrapes recent funding rounds from Crunchbase, a leading platform for tracking startup investments, and then appends the data to a Google Sheets spreadsheet.

The workflow collects over 10 data points for each funding round, including the company's LinkedIn URL, monthly website traffic, employee count, and more. This gives users a comprehensive database they can use for outreach, sales and marketing activities, and staying informed on industry trends. The workflow runs on a daily schedule, ensuring the data is always up-to-date. It leverages the Piloterr API to fetch the Crunchbase data and the Google Sheets integration to store the information in a structured format.

Updated May 8, 2026Est. run: 15sEst. cost: $0.0009
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 the Piloterr API.
  • Normalizes and enhances the funding data with additional company details.
  • Stores the comprehensive funding data in a Google Sheets spreadsheet.
  • Runs daily to ensure the funding data is always up-to-date.
  • Provides a structured database for outreach, sales, and industry research.

How it works

1
Trigger

Run Daily

The workflow is triggered every day at 8 AM to automatically fetch the latest funding round data from Crunchbase.

2
Action

Get Recent Fundraise - Series A

The workflow uses the Piloterr integration to fetch recent Series A funding rounds from the Crunchbase platform.

3
Action

Get Recent Fundraise - Series B

The workflow also fetches recent Series B funding rounds from Crunchbase using the Piloterr integration.

4
Action

Get Recent Fundraise - Seed

In addition, the workflow retrieves recent seed funding rounds from Crunchbase via the Piloterr integration.

5
Logic

Process Funding Rounds

The workflow then iterates through the funding round data fetched from the previous steps, processing each round individually.

6
Action

Prepare Data

The JavaScript integration is used to extract key fields from the Crunchbase funding data, such as the company name, amount raised, and investment stage.

7
Action

Enrich Company

Additional company details like the LinkedIn URL, monthly website traffic, and employee count are fetched from Crunchbase using the Piloterr integration to further enrich the funding round data.

8
Action

Get LinkedIn URL

The workflow then extracts the LinkedIn URL for the company from the social networks data using a JavaScript integration.

9
Action

Format for Google Sheets

The data is prepared for import into the Google Sheets spreadsheet by formatting it appropriately using a JavaScript integration.

10
Action

Append to Spreadsheet

Finally, the enriched funding round data is appended to the Google Sheets spreadsheet using the Google Sheets integration.

Setup guide

1

Add Piloterr credential

Go to the Latenode Credentials panel and add a new credential for Piloterr. Enter your Piloterr API key.

2

Configure Crunchbase data fetch

Add a Piloterr 'Get Recent Fundraise' node to your workflow. Set the 'Type' input to fetch the desired funding round data (Series A, Series B, Seed).

3

Enrich company data

Add another Piloterr 'Enrich company' node to your workflow. This will fetch additional details about the companies, including website, monthly traffic, funding total, LinkedIn URL, employee count, country, and founded date.

4

Connect Google Sheets

Add a Google Sheets node to your workflow. Configure the spreadsheet ID and sheet name where you want to save the funding rounds data.

5

Map fields to Google Sheets

In the Google Sheets node settings, map the funding rounds data fields (company name, website, type, money_raised, LinkedIn URL, etc.) to the corresponding Google Sheets columns.

Requirements

Create a Piloterr API account and obtain an API key to access the Crunchbase funding data
Connect your Google Sheets account and grant permission to the Google Sheets integration to write data to a spreadsheet
Identify the Google Sheets spreadsheet you want to use and note the sheet name and cell range to store the funding data
Ensure you have access to the Crunchbase data through the Piloterr API and that your API key has the necessary permissions
For providers without a native connector in Latenode, use the JavaScript step with that service's API credentials (stored in Latenode Keys / Secrets).

FAQ

Common questions about this template

This automation workflow is designed to help businesses and marketers stay on top of the latest funding activity in their industry. It automatically scrapes recent funding rounds from Crunchbase, a leading platform for tracking startup investments, and then appends the data to a Google Sheets spreadsheet. The workflow collects over 10 data points for each funding round, including the company's LinkedIn URL, monthly website traffic, employee count, and more. This gives users a comprehensive database they can use for outreach, sales and marketing activities, and staying informed on industry trends.
Contact support →

More templates

You might also like

Browse all templates →
Scraping & data collection

Automatically Sync Google Maps Business Data to a Spreadsheet

This automation workflow 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. The workflow uses the SerpAPI service to retrieve Google Maps search results, which are then transformed and appended to a Google Sheet. This enables users to generate leads, conduct market analysis, and gain valuable insights from the collected data in a cost-effective and scalable manner.

10s$0.0006
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

Automatically scrape and store Booking.com hotel data

This workflow automates the search and extraction of hotel data from Booking.com, triggered by a chat message. It uses a combination of web scraping with Bright Data's Web Scraper and AI-powered data processing with OpenRouter to deliver a concise, human-friendly list of hotels, including the title, address, original price, and final price. The final output is a clean and formatted report, making it a valuable tool for travelers, event planners, and business professionals who need to quickly find accommodation.

12s$0.0007