Yaron Been This workflow corresponds to n8n.io template #4731 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request 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 →
{
"id": "8hRFK0iEjVKmthLq",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "CrunchBase Invester Data",
"tags": [],
"nodes": [
{
"id": "49130296-ad2e-43f6-8ec4-7f72161a3a1b",
"name": "Daily Investor Data Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
0
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 9
}
]
}
},
"typeVersion": 1.2
},
{
"id": "24caa890-abba-435d-a385-18cdef03dfe2",
"name": "Fetch Crunchbase Investor Data",
"type": "n8n-nodes-base.httpRequest",
"position": [
220,
0
],
"parameters": {
"url": "https://api.crunchbase.com/api/v4/searches/organizations",
"method": "POST",
"options": {},
"jsonBody": "{\n \"field_ids\": [\n \"identifier\",\n \"name\",\n \"short_description\",\n \"location_identifiers\",\n \"investment_stage\"\n ],\n \"query\": [\n {\n \"type\": \"predicate\",\n \"field_id\": \"organization_types\",\n \"operator_id\": \"includes\",\n \"values\": [\n \"investor\"\n ]\n }\n ],\n \"limit\": 5\n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer YOUR_TOKEN_HERE"
},
{
"name": "Authorization",
"value": "Bearer YOUR_TOKEN_HERE"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "4de0847b-6e11-457d-b04b-d03b4fb1e3c1",
"name": "Extract Investor Fields",
"type": "n8n-nodes-base.code",
"position": [
540,
0
],
"parameters": {
"jsCode": "const entities = items[0].json.entities;\n\nreturn entities.map(entity => {\n return {\n json: {\n name: entity.name,\n short_description: entity.short_description,\n location_identifiers: entity.location_identifiers,\n investment_stage: entity.investment_stage\n }\n };\n});\n"
},
"typeVersion": 2
},
{
"id": "a7d08f10-1fde-4e99-9127-bf12926d4197",
"name": "Append to Investor Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
780,
0
],
"parameters": {
"columns": {
"value": {
"Name": "={{ $json.name }}",
"Location": "={{ $json.location_identifiers }}",
"Investment Stage": "={{ $json.investment_stage }}",
"Short description": "={{ $json.short_description }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Short description",
"type": "string",
"display": true,
"required": false,
"displayName": "Short description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Investment Stage",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Investment Stage",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XOUvOgrhDdOorEj0-TL4EiVygMd1wpD3cktI2_bm-Ww/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1XOUvOgrhDdOorEj0-TL4EiVygMd1wpD3cktI2_bm-Ww",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XOUvOgrhDdOorEj0-TL4EiVygMd1wpD3cktI2_bm-Ww/edit?usp=drivesdk",
"cachedResultName": "CrunchBase Invester List"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.5
},
{
"id": "45c6eb29-4d24-49a6-b849-938b178b66c9",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-40,
-1700
],
"parameters": {
"color": 5,
"width": 420,
"height": 1900,
"content": "### \ud83d\udd37 **SECTION 1: Getting the Data from Crunchbase**\n\n#### \ud83e\udde9 Nodes:\n\n1. \ud83d\udd52 **Daily Investor Data Trigger**\n2. \ud83c\udf10 **Fetch Crunchbase Investor Data**\n\n---\n\n#### \ud83d\udd0d What Happens in This Section?\n\nThis section is all about **automatically pulling investor data from Crunchbase** on a scheduled basis, without any manual effort.\n\n---\n\n#### \ud83d\udd52 1. **Daily Investor Data Trigger**\n\n> *\"When should the automation run?\"*\n\n* This **Schedule Trigger** node starts your workflow automatically at your chosen time.\n* For example, it could run every day at 8 AM.\n* It removes the need to remember to check Crunchbase manually.\n\n\u2705 *Beginner Benefit:*\n\n> Even if you\u2019re not technical, you just set the schedule and let n8n run this job every day while you sleep \u2615\ud83d\udcca\n\n---\n\n#### \ud83c\udf10 2. **Fetch Crunchbase Investor Data**\n\n> *\"Where do we get the data from?\"*\n\n* This **HTTP Request** node sends a **POST request** to [Crunchbase\u2019s API](https://data.crunchbase.com/docs).\n\n* It includes a **filter** for organization types like `investor` and requests fields like:\n\n * `name`\n * `short_description`\n * `location_identifiers`\n * `investment_stage`\n\n* Crunchbase replies with a **JSON** file full of matching investors.\n\n\u2705 *Beginner Benefit:*\n\n> You don\u2019t need to open a browser or search anything. This step collects live investor data from Crunchbase and brings it into your workflow for you \ud83d\ude80\n\n---\n\n### \u2705 What This Section Gives You:\n\nA **live, up-to-date snapshot** of investor information, **automatically pulled** from Crunchbase, without coding or clicking.\n\n---\n\n"
},
"typeVersion": 1
},
{
"id": "2dd2de36-770c-4833-884b-1525c1411d46",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
-1400
],
"parameters": {
"color": 6,
"width": 460,
"height": 1600,
"content": "### \ud83d\udd37 **SECTION 2: Processing and Saving the Data**\n\n#### \ud83e\udde9 Nodes:\n\n3. \ud83e\uddee **Extract Investor Fields**\n4. \ud83d\udcc4 **Append to Investor Sheet**\n\n---\n\n#### \ud83d\udd0d What Happens in This Section?\n\nNow that we have raw investor data, this section **cleans it up** and **stores it in a Google Sheet** for easy access and analysis.\n\n---\n\n#### \ud83e\uddee 3. **Extract Investor Fields**\n\n> *\"Let\u2019s clean and format the response.\"*\n\n* This **Code** node uses JavaScript to loop through the list of investors and extract just what you care about:\n\n * \u2705 Name\n * \ud83d\udcdd Short description\n * \ud83c\udf0d Location\n * \ud83d\udcb0 Investment stage\n\n* Each investor becomes a **separate row-ready item** for Google Sheets.\n\n\u2705 *Beginner Benefit:*\n\n> You don\u2019t need to look at messy data. This step reshapes it into a clean format automatically \u2728\n\n---\n\n#### \ud83d\udcc4 4. **Append to Investor Sheet**\n\n> *\"Store it somewhere useful.\"*\n\n* This **Google Sheets** node takes the cleaned data and **adds it to a selected sheet**.\n* It works like a magic assistant, typing the investor data into your spreadsheet row-by-row.\n* You now have a **running list** of investors to use for:\n\n * \ud83d\udcc8 Market research\n * \ud83c\udfaf Outreach planning\n * \ud83d\udca1 Competitor benchmarking\n\n"
},
"typeVersion": 1
},
{
"id": "75231f28-c911-4bdc-a6a2-c6255d293eb3",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1820,
-1680
],
"parameters": {
"color": 4,
"width": 1300,
"height": 320,
"content": "=======================================\n WORKFLOW ASSISTANCE\n=======================================\nFor any questions or support, please contact:\n Yaron@nofluff.online\n\nExplore more tips and tutorials here:\n - YouTube: https://www.youtube.com/@YaronBeen/videos\n - LinkedIn: https://www.linkedin.com/in/yaronbeen/\n=======================================\n"
},
"typeVersion": 1
},
{
"id": "c8a8156f-946e-4a50-8789-aff9c66bd9b6",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1820,
-1340
],
"parameters": {
"color": 4,
"width": 1289,
"height": 3278,
"content": "## \u2728 n8n Workflow: Investor Data Automation from Crunchbase to Google Sheets\n\n---\n\n### \ud83d\udd37 **SECTION 1: Getting the Data from Crunchbase**\n\n#### \ud83e\udde9 Nodes:\n\n1. \ud83d\udd52 **Daily Investor Data Trigger**\n2. \ud83c\udf10 **Fetch Crunchbase Investor Data**\n\n---\n\n#### \ud83d\udd0d What Happens in This Section?\n\nThis section is all about **automatically pulling investor data from Crunchbase** on a scheduled basis, without any manual effort.\n\n---\n\n#### \ud83d\udd52 1. **Daily Investor Data Trigger**\n\n> *\"When should the automation run?\"*\n\n* This **Schedule Trigger** node starts your workflow automatically at your chosen time.\n* For example, it could run every day at 8 AM.\n* It removes the need to remember to check Crunchbase manually.\n\n\u2705 *Beginner Benefit:*\n\n> Even if you\u2019re not technical, you just set the schedule and let n8n run this job every day while you sleep \u2615\ud83d\udcca\n\n---\n\n#### \ud83c\udf10 2. **Fetch Crunchbase Investor Data**\n\n> *\"Where do we get the data from?\"*\n\n* This **HTTP Request** node sends a **POST request** to [Crunchbase\u2019s API](https://data.crunchbase.com/docs).\n\n* It includes a **filter** for organization types like `investor` and requests fields like:\n\n * `name`\n * `short_description`\n * `location_identifiers`\n * `investment_stage`\n\n* Crunchbase replies with a **JSON** file full of matching investors.\n\n\u2705 *Beginner Benefit:*\n\n> You don\u2019t need to open a browser or search anything. This step collects live investor data from Crunchbase and brings it into your workflow for you \ud83d\ude80\n\n---\n\n### \u2705 What This Section Gives You:\n\nA **live, up-to-date snapshot** of investor information, **automatically pulled** from Crunchbase, without coding or clicking.\n\n---\n\n<br/>\n\n---\n\n### \ud83d\udd37 **SECTION 2: Processing and Saving the Data**\n\n#### \ud83e\udde9 Nodes:\n\n3. \ud83e\uddee **Extract Investor Fields**\n4. \ud83d\udcc4 **Append to Investor Sheet**\n\n---\n\n#### \ud83d\udd0d What Happens in This Section?\n\nNow that we have raw investor data, this section **cleans it up** and **stores it in a Google Sheet** for easy access and analysis.\n\n---\n\n#### \ud83e\uddee 3. **Extract Investor Fields**\n\n> *\"Let\u2019s clean and format the response.\"*\n\n* This **Code** node uses JavaScript to loop through the list of investors and extract just what you care about:\n\n * \u2705 Name\n * \ud83d\udcdd Short description\n * \ud83c\udf0d Location\n * \ud83d\udcb0 Investment stage\n\n* Each investor becomes a **separate row-ready item** for Google Sheets.\n\n\u2705 *Beginner Benefit:*\n\n> You don\u2019t need to look at messy data. This step reshapes it into a clean format automatically \u2728\n\n---\n\n#### \ud83d\udcc4 4. **Append to Investor Sheet**\n\n> *\"Store it somewhere useful.\"*\n\n* This **Google Sheets** node takes the cleaned data and **adds it to a selected sheet**.\n* It works like a magic assistant, typing the investor data into your spreadsheet row-by-row.\n* You now have a **running list** of investors to use for:\n\n * \ud83d\udcc8 Market research\n * \ud83c\udfaf Outreach planning\n * \ud83d\udca1 Competitor benchmarking\n\n\u2705 *Beginner Benefit:*\n\n> You don\u2019t copy-paste anything \u2014 n8n writes investor data into your sheet for you. It\u2019s like having a personal assistant with no salary \ud83d\udcca\ud83e\udd16\n\n---\n\n### \u2705 What This Section Gives You:\n\nA fully automated process that **cleans up Crunchbase data** and **stores it neatly** in Google Sheets \u2014 ready for analysis, dashboards, or reporting.\n\n---\n\n### \ud83c\udf81 Final Outcome\n\n\u2705 No coding needed\n\u2705 Runs on autopilot\n\u2705 Clean data in your sheet\n\u2705 Use for strategy, marketing, or VC tracking\n\n---\n\n\n"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "daeaf695-d4ae-460d-84b1-b4cdba520d28",
"connections": {
"Extract Investor Fields": {
"main": [
[
{
"node": "Append to Investor Sheet",
"type": "main",
"index": 0
}
]
]
},
"Daily Investor Data Trigger": {
"main": [
[
{
"node": "Fetch Crunchbase Investor Data",
"type": "main",
"index": 0
}
]
]
},
"Fetch Crunchbase Investor Data": {
"main": [
[
{
"node": "Extract Investor Fields",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This cutting-edge n8n automation is a sophisticated investor intelligence tool designed to transform market research into actionable insights. By intelligently connecting CrunchBase, data processing, and Google Sheets, this workflow: Discovers Investor Insights: Automatically…
Source: https://n8n.io/workflows/4731/ — 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.
This workflow automates video distribution to 9 social platforms simultaneously using Blotato's API. It includes both a scheduled publisher (checks Google Sheets for videos marked "Ready") and a subwo
Google Sheets, HTTP Request, Form Trigger +2
YogiAI. Uses googleSheets, googleSheetsTool, httpRequest, stopAndError. Scheduled trigger; 61 nodes.
Google Sheets, Google Sheets Tool, HTTP Request +1
This workflow monitors Google Calendar for events indicating that a customer will visit the company today or the next day, retrieves the required details, and sends reminder notifications to the relev
Google Calendar, Google Sheets, HTTP Request +1
ofn hook v0.24.0 beta. Uses start, httpRequest, functionItem, itemLists. Scheduled trigger; 42 nodes.
Start, HTTP Request, Function Item +3
Security teams, DevOps engineers, vulnerability analysts, and automation builders who want to eliminate repetitive Nessus scan parsing, AI-based risk triage, and manual reporting. Designed for orgs fo
Email Send, HTTP Request, Google Sheets +1