JohnVC This workflow corresponds to n8n.io template #17353 — we link there as the canonical source.
This workflow follows the Apifyn8N Nodes Apify → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"name": "Collect venture capital data from Crunchbase to Google Sheets",
"nodes": [
{
"id": "9a1f0f5e-0001-4a01-a001-000000000001",
"name": "When clicking 'Test workflow'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
460
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9a1f0f5e-0003-4a03-a003-000000000003",
"name": "Set your company URLs",
"type": "n8n-nodes-base.set",
"position": [
260,
460
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "b2c3d4e5-0002-4a02-a+1234567890",
"name": "companyUrls",
"type": "array",
"value": "[\"https://www.crunchbase.com/organization/openai\", \"https://www.crunchbase.com/organization/anthropic\", \"https://www.crunchbase.com/organization/stripe\"]"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "9a1f0f5e-0004-4a04-a004-000000000004",
"name": "Scrape Crunchbase companies",
"type": "@apify/n8n-nodes-apify.apify",
"position": [
520,
460
],
"parameters": {
"memory": 1024,
"actorId": "johnvc~crunchbase-company-api",
"resource": "Actors",
"operation": "Run actor and get dataset",
"customBody": "={{ JSON.stringify({ companyUrls: $json.companyUrls }) }}"
},
"typeVersion": 1
},
{
"id": "9a1f0f5e-0017-4a17-a017-000000000017",
"name": "Keep only companies",
"type": "n8n-nodes-base.filter",
"position": [
780,
460
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d1+1234567890a16-a016-+1234567890",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.result_type }}",
"rightValue": "company"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "9a1f0f5e-000e-4a0e-a00e-00000000000e",
"name": "Pick fields for the sheet",
"type": "n8n-nodes-base.set",
"position": [
1040,
460
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "c1+1234567890a05-a+1234567890",
"name": "Company",
"type": "string",
"value": "={{ $json.name }}"
},
{
"id": "c1+1234567890a06-a+1234567890",
"name": "Website",
"type": "string",
"value": "={{ $json.website }}"
},
{
"id": "c1+1234567890a07-a+1234567890",
"name": "Industries",
"type": "string",
"value": "={{ $json.industries }}"
},
{
"id": "c1+1234567890a08-a+1234567890",
"name": "Headquarters",
"type": "string",
"value": "={{ $json.hqLocation }}"
},
{
"id": "c1+1234567890a09-a+1234567890",
"name": "Employees",
"type": "string",
"value": "={{ $json.employeeCount }}"
},
{
"id": "c1+1234567890a-4a0a-a00a-+1234567890a",
"name": "Total funding",
"type": "string",
"value": "={{ $json.totalFunding }}"
},
{
"id": "c1+1234567890b-4a0b-a00b-+1234567890b",
"name": "Funding rounds",
"type": "string",
"value": "={{ $json.numFundingRounds }}"
},
{
"id": "c1+1234567890c-4a0c-a00c-+1234567890c",
"name": "Investors",
"type": "string",
"value": "={{ $json.investors }}"
},
{
"id": "c1+1234567890d-4a0d-a00d-+1234567890d",
"name": "Status",
"type": "string",
"value": "={{ $json.operatingStatus }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "9a1f0f5e-000f-4a0f-a00f-00000000000f",
"name": "Append companies to sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
1300,
460
],
"parameters": {
"columns": {
"value": {},
"mappingMode": "autoMapInputData",
"matchingColumns": []
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": ""
},
"documentId": {
"__rl": true,
"mode": "list",
"value": ""
}
},
"typeVersion": 4.5
},
{
"id": "9a1f0f5e-0010-4a10-a010-000000000010",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-580,
40
],
"parameters": {
"width": 500,
"height": 1020,
"content": "## Collect venture capital data from Crunchbase to Google Sheets\n\nNo Crunchbase API key required. Turn a list of Crunchbase organization URLs into a venture capital dataset in Google Sheets: funding totals, rounds, investors, industries, headquarters, employee band, and operating status, one row per company.\n\n**Who's it for**\nVC and PE analysts building target lists, founders researching competitors, and sales teams enriching accounts with funding data.\n\n**How it works**\n1. Add your Crunchbase organization URLs in the Set node\n2. The Apify node runs the Crunchbase Company API and returns one structured row per company\n3. A filter drops any URL the source could not return, so only real companies reach your sheet\n4. The fields you care about are appended to your Google Sheet\n\n**Setup**\n1. Create a free Apify account and add your API token to the Apify credential\n2. Connect your Google account in the Sheets node and pick a spreadsheet\n3. Replace the example URLs with your companies, then run\n\n**Good to know**\nNo Crunchbase API key needed. Collection costs about $0.009 per company on the actor's free tier.\nActor: https://apify.com/johnvc/crunchbase-company-api?fpr=9n7kx3&fp_sid=n8n"
},
"typeVersion": 1
},
{
"id": "9a1f0f5e-0011-4a11-a011-000000000011",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
220,
60
],
"parameters": {
"color": 7,
"width": 240,
"height": 240,
"content": "### 1. Your input\nAdd your Crunchbase organization URLs here. This is the only node you edit."
},
"typeVersion": 1
},
{
"id": "9a1f0f5e-0012-4a12-a012-000000000012",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
500,
60
],
"parameters": {
"color": 7,
"width": 240,
"height": 240,
"content": "### 2. Scrape\nRuns the Crunchbase Company API actor. Add your Apify credential here."
},
"typeVersion": 1
},
{
"id": "9a1f0f5e-0018-4a18-a018-000000000018",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
760,
60
],
"parameters": {
"color": 7,
"width": 240,
"height": 240,
"content": "### 3. Clean\nKeeps only real company rows. Any URL that fails is skipped."
},
"typeVersion": 1
},
{
"id": "9a1f0f5e-0013-4a13-a013-000000000013",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1020,
60
],
"parameters": {
"color": 7,
"width": 240,
"height": 240,
"content": "### 4. Shape\nChoose which company fields become your sheet columns."
},
"typeVersion": 1
},
{
"id": "9a1f0f5e-0014-4a14-a014-000000000014",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
60
],
"parameters": {
"color": 7,
"width": 240,
"height": 240,
"content": "### 5. Deliver\nPick your spreadsheet and tab. Columns map automatically."
},
"typeVersion": 1
},
{
"id": "9a1f0f5e-0015-4a15-a015-000000000015",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
220,
720
],
"parameters": {
"color": 7,
"width": 360,
"height": 200,
"content": "### Self-hosting n8n?\nThere is also a dedicated community node for this actor: `n8n-nodes-crunchbase-company-api` on npm."
},
"typeVersion": 1
}
],
"settings": {
"executionOrder": "v1"
},
"connections": {
"Keep only companies": {
"main": [
[
{
"node": "Pick fields for the sheet",
"type": "main",
"index": 0
}
]
]
},
"Set your company URLs": {
"main": [
[
{
"node": "Scrape Crunchbase companies",
"type": "main",
"index": 0
}
]
]
},
"Pick fields for the sheet": {
"main": [
[
{
"node": "Append companies to sheet",
"type": "main",
"index": 0
}
]
]
},
"Scrape Crunchbase companies": {
"main": [
[
{
"node": "Keep only companies",
"type": "main",
"index": 0
}
]
]
},
"When clicking 'Test workflow'": {
"main": [
[
{
"node": "Set your company URLs",
"type": "main",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
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…
Source: https://n8n.io/workflows/17353/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Ultimate Extract by RoboNuggets (R46). Uses @apify/n8n-nodes-apify, googleSheets, formTrigger. Event-driven trigger; 42 nodes.
@Apify/N8N Nodes Apify, Google Sheets, Form Trigger
Try It Out!
@Apify/N8N Nodes Apify, Google Sheets
Turn image URLs into clean, structured text and log it to Google Sheets automatically. No OCR library, no setup, powered by Apify Google Lens. Runs manually when you click Test workflow. Sets the targ
@Apify/N8N Nodes Apify, Google Sheets
APIFY-Gmaps. Uses googleSheets, @apify/n8n-nodes-apify, formTrigger. Event-driven trigger; 5 nodes.
Google Sheets, @Apify/N8N Nodes Apify, Form Trigger
Community nodes are used, and template can only be used on self-hosted n8n instances.
@Apify/N8N Nodes Apify, Google Sheets