Quick overview
Quick overview No Crunchbase API key required. This template collects venture capital data from Crunchbase and writes it to Google Sheets: funding totals, rounds, investors, industries, headquarters, employee band, and operating status, one clean row per company, powered by the Crunchbase Company API actor on Apify. How it works Runs manually when you click “Test workflow” in n8n. Loads an array of Crunchbase organization URLs to process. Sends the URLs to Apify (johnvc/crunchbase-company-api actor) to scrape structured Crunchbase company data. Filters the results to keep only items identified as company records. Selects and renames key fields (company name, website, industries, HQ, employee count, funding totals/rounds, investors, and operating status) for tabular output. Appends each company as a new row in a Google Sheets worksheet. Setup Create an Apify account and add your Apify API token in n8n credentials for the Apify node. Connect your Google Sheets account in n8n credentials and select the target spreadsheet and sheet tab in the Google Sheets node. Replace the example Crunchbase organization URLs with your own list in the input step before running the workflow. Requirements An Apify account. The free tier works and Crunchbase collection costs about $0.009 per company. A Google account for Sheets. No Crunchbase API key or enterprise license. Customization Swap Google Sheets for Slack, email, Airtable, or your CRM to send company rows where your team works. Add more Crunchbase organization URLs to the Set node, up to 1000 per run. Additional info No Crunchbase API key required: the official Crunchbase API is aimed at enterprise customers and priced accordingly, while this template gets the same public company data through the Crunchbase Company API actor on Apify, so you only need a free Apify token. Collection costs about $0.009 per company on the actor's free tier, with no subscription. The actor accepts up to 1000 Crunchbase organization URLs per run and returns one row per company, so you can enrich a full target list in one call. Add a Schedule trigger to refresh funding data weekly. Self-hosting n8n? There is also a dedicated community node, n8n-nodes-crunchbase-company-api on npm. Actor. An n8n automation workflow template by JohnVC.
JohnVC
web
free
Others in the same category, ranked by how often they are opened.
