Yaron Been This workflow corresponds to n8n.io template #4730 — 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": "guoSdgPOMDBnq6GW",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Crunchbase funding rounds",
"tags": [],
"nodes": [
{
"id": "b2bee19f-4033-4473-a78c-3463b4b56e79",
"name": "Daily Check for New Funding Rounds",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-100,
0
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 8
}
]
}
},
"typeVersion": 1.2
},
{
"id": "bfeff292-40aa-4a3b-81bf-bd237463abe9",
"name": "Fetch Crunchbase Funding Rounds",
"type": "n8n-nodes-base.httpRequest",
"position": [
120,
0
],
"parameters": {
"url": "https://api.crunchbase.com/api/v4/entities/funding_rounds",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "locations",
"value": "United States"
},
{
"name": "industry",
"value": "Fintech,Healthtech"
},
{
"name": "sort_order",
"value": "created_at DESC"
},
{
"name": "page",
"value": "1"
},
{
"name": "items_per_page",
"value": "25"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "X-cb-user-key",
"value": "YOUR_API_KEY"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "aaf02cbe-e85d-4575-b570-2758289cbcb9",
"name": "Extract & Format Funding Data",
"type": "n8n-nodes-base.code",
"position": [
440,
0
],
"parameters": {
"jsCode": "const baseUrl = \"https://www.crunchbase.com/funding-round/\";\n\nconst output = [];\n\nfor (const item of items[0].json.data.entities) {\n const props = item.properties;\n const id = item.identifier;\n\n const companyName = props.funded_organization_identifier?.value || \"N/A\";\n const industry = props.industry_group_identifiers?.map(ind => ind.value).join(\", \") || \"N/A\";\n const fundingType = props.funding_type || \"N/A\";\n const date = props.announced_on || \"N/A\";\n const amount = props.money_raised_usd || 0;\n const investors = props.investor_identifiers?.map(inv => inv.value).join(\", \") || \"N/A\";\n const url = baseUrl + id.permalink;\n\n output.push({\n json: {\n company_name: companyName,\n industry: industry,\n funding_round_type: fundingType,\n announced_date: date,\n money_raised_usd: amount,\n investors: investors,\n crunchbase_url: url\n }\n });\n}\n\nreturn output;\n"
},
"typeVersion": 2
},
{
"id": "a2bd1e77-c88c-4d0f-b66b-1d83cb756831",
"name": "Log to Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
660,
0
],
"parameters": {
"columns": {
"value": {
"industry": "={{ $json.industry }}",
"investors": "={{ $json.investors }}",
"company name": "={{ $json.company_name }}",
"announced date": "={{ $json.announced_date }}",
"crunchbase url": "={{ $json.crunchbase_url }}",
"money raised usd": "={{ $json.money_raised_usd }}",
"funding round type": "={{ $json.funding_round_type }}"
},
"schema": [
{
"id": "company name",
"type": "string",
"display": true,
"required": false,
"displayName": "company name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "industry",
"type": "string",
"display": true,
"required": false,
"displayName": "industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "funding round type",
"type": "string",
"display": true,
"required": false,
"displayName": "funding round type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "announced date",
"type": "string",
"display": true,
"required": false,
"displayName": "announced date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "money raised usd",
"type": "string",
"display": true,
"required": false,
"displayName": "money raised usd",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "investors",
"type": "string",
"display": true,
"required": false,
"displayName": "investors",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "crunchbase url",
"type": "string",
"display": true,
"required": false,
"displayName": "crunchbase url",
"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/11bGAwfhLtR1FZwEZUAi-pddixpJintqFXAT1eWp_QQ0/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "11bGAwfhLtR1FZwEZUAi-pddixpJintqFXAT1eWp_QQ0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/11bGAwfhLtR1FZwEZUAi-pddixpJintqFXAT1eWp_QQ0/edit?usp=drivesdk",
"cachedResultName": "Crunchbase funding rounds"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4.5
},
{
"id": "b821dc48-3503-4688-b3f1-3eb9744cb0dc",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-1660
],
"parameters": {
"color": 3,
"width": 440,
"height": 1860,
"content": "## \ud83d\udd36 **SECTION ONE: Data Fetching & Triggering**\n\n### \ud83d\udd52 + \ud83c\udf10 `Daily Check for New Funding Rounds` + `Fetch Crunchbase Funding Rounds`\n\n---\n\n### 1\ufe0f\u20e3 \ud83d\udd52 **Schedule Trigger**\n\n**Node Name:** `Daily Check for New Funding Rounds`\n\ud83d\udccc **Purpose:** This is the **heartbeat** of your workflow. It tells n8n **when** to run the process.\n\n\ud83d\udee0 **How it works:**\n\n* Set to run **daily** (or on weekdays) at a fixed time like 08:00 AM.\n* Uses a native `Cron` schedule \u2014 no coding needed.\n\n\ud83c\udfaf **Why it's powerful:**\n\n* Works on autopilot\u2014no manual effort.\n* Keeps your Google Sheet up to date with fresh funding data.\n\n\ud83d\udca1 **Pro Tip for Beginners:**\n\n* You can adjust the frequency (e.g., hourly, weekly) from the **Schedule Trigger** node settings in n8n\u2019s UI.\n\n---\n\n### 2\ufe0f\u20e3 \ud83c\udf10 **HTTP Request**\n\n**Node Name:** `Fetch Crunchbase Funding Rounds`\n\ud83d\udccc **Purpose:** This node **pulls fresh funding round data** from Crunchbase via API.\n\n\ud83d\udee0 **How it works:**\n\n* Sends a `GET` request to Crunchbase\u2019s API endpoint.\n* Filters data based on:\n\n * \ud83d\udccd **Location**: e.g., United States\n * \ud83c\udfe2 **Industries**: e.g., Fintech, Healthtech\n * \ud83d\udcc5 Sorted by `created_at DESC` (most recent first)\n\n\ud83d\udd11 **Authentication:**\n\n* Requires a **Crunchbase API key** (`X-cb-user-key`) which is free or paid depending on your plan.\n\n\ud83d\udcc4 **Data Returned:**\n\n* Company name\n* Funding round type\n* Amount raised\n* Date announced\n* Investors\n* Crunchbase permalink\n\n\ud83c\udfaf **Why it's powerful:**\n\n* Gives you **real-time intelligence** on who\u2019s raising money in your industry.\n* Eliminates the need to visit Crunchbase manually.\n\n\ud83d\udca1 **Pro Tip for Beginners:**\n\n* You can customize the API request in this node using query parameters to focus on:\n\n * Only seed or Series A rounds\n * Specific countries\n * Particular timeframes\n\n---\n\n"
},
"typeVersion": 1
},
{
"id": "bf867540-540e-484a-bebc-d2df5d24c273",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
360,
-1240
],
"parameters": {
"color": 5,
"width": 460,
"height": 1440,
"content": "## \ud83d\udd37 **SECTION TWO: Processing & Logging**\n\n### \ud83e\uddee + \ud83d\udcc4 `Extract & Format Funding Data` + `Log to Google Sheets`\n\n---\n\n### 3\ufe0f\u20e3 \ud83e\uddee **Function Code**\n\n**Node Name:** `Extract & Format Funding Data`\n\ud83d\udccc **Purpose:** This node **cleans up** the Crunchbase response and **reformats** it into something easy to read and store.\n\n\ud83d\udee0 **How it works:**\n\n* Pulls out only the relevant fields:\n\n * `company_name`\n * `industry`\n * `funding_round_type`\n * `announced_date`\n * `money_raised_usd`\n * `investors`\n * `crunchbase_url`\n* Formats investors as a comma-separated string.\n* Constructs a clickable Crunchbase URL.\n\n\ud83c\udfaf **Why it's powerful:**\n\n* Converts a complex API response into a **clean row of data**.\n* Makes your data Google Sheets\u2013ready.\n\n\ud83d\udca1 **Pro Tip for Beginners:**\n\n* You don\u2019t need to write the code! Just copy-paste the provided script.\n* You can even add more fields if needed by editing the Function node.\n\n---\n\n### 4\ufe0f\u20e3 \ud83d\udcc4 **Google Sheets (Append)**\n\n**Node Name:** `Log to Google Sheets`\n\ud83d\udccc **Purpose:** This final step **writes the funding data** to your connected Google Sheet.\n\n\ud83d\udee0 **How it works:**\n\n* Authenticates via your Google Account.\n* Selects your target spreadsheet and sheet.\n* Automatically appends a **new row** for each funding round found.\n\n"
},
"typeVersion": 1
},
{
"id": "24591384-2b6a-4e7d-9061-62b97a2216b0",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1720,
-1660
],
"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": "543f43e7-8fc7-4b67-8b75-7948d07a331e",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1720,
-1320
],
"parameters": {
"color": 4,
"width": 1289,
"height": 3318,
"content": "# \ud83e\udde9\u2728 Your Automated Crunchbase Monitoring Workflow (Explained Step-by-Step)\n\nThis workflow helps you **automatically monitor Crunchbase for new funding rounds** in specific industries (like Fintech or Healthtech) and **log that data into Google Sheets** for reporting, trend analysis, or alerting investors.\n\n---\n\n## \ud83d\udd36 **SECTION ONE: Data Fetching & Triggering**\n\n### \ud83d\udd52 + \ud83c\udf10 `Daily Check for New Funding Rounds` + `Fetch Crunchbase Funding Rounds`\n\n---\n\n### 1\ufe0f\u20e3 \ud83d\udd52 **Schedule Trigger**\n\n**Node Name:** `Daily Check for New Funding Rounds`\n\ud83d\udccc **Purpose:** This is the **heartbeat** of your workflow. It tells n8n **when** to run the process.\n\n\ud83d\udee0 **How it works:**\n\n* Set to run **daily** (or on weekdays) at a fixed time like 08:00 AM.\n* Uses a native `Cron` schedule \u2014 no coding needed.\n\n\ud83c\udfaf **Why it's powerful:**\n\n* Works on autopilot\u2014no manual effort.\n* Keeps your Google Sheet up to date with fresh funding data.\n\n\ud83d\udca1 **Pro Tip for Beginners:**\n\n* You can adjust the frequency (e.g., hourly, weekly) from the **Schedule Trigger** node settings in n8n\u2019s UI.\n\n---\n\n### 2\ufe0f\u20e3 \ud83c\udf10 **HTTP Request**\n\n**Node Name:** `Fetch Crunchbase Funding Rounds`\n\ud83d\udccc **Purpose:** This node **pulls fresh funding round data** from Crunchbase via API.\n\n\ud83d\udee0 **How it works:**\n\n* Sends a `GET` request to Crunchbase\u2019s API endpoint.\n* Filters data based on:\n\n * \ud83d\udccd **Location**: e.g., United States\n * \ud83c\udfe2 **Industries**: e.g., Fintech, Healthtech\n * \ud83d\udcc5 Sorted by `created_at DESC` (most recent first)\n\n\ud83d\udd11 **Authentication:**\n\n* Requires a **Crunchbase API key** (`X-cb-user-key`) which is free or paid depending on your plan.\n\n\ud83d\udcc4 **Data Returned:**\n\n* Company name\n* Funding round type\n* Amount raised\n* Date announced\n* Investors\n* Crunchbase permalink\n\n\ud83c\udfaf **Why it's powerful:**\n\n* Gives you **real-time intelligence** on who\u2019s raising money in your industry.\n* Eliminates the need to visit Crunchbase manually.\n\n\ud83d\udca1 **Pro Tip for Beginners:**\n\n* You can customize the API request in this node using query parameters to focus on:\n\n * Only seed or Series A rounds\n * Specific countries\n * Particular timeframes\n\n---\n\n## \ud83d\udd37 **SECTION TWO: Processing & Logging**\n\n### \ud83e\uddee + \ud83d\udcc4 `Extract & Format Funding Data` + `Log to Google Sheets`\n\n---\n\n### 3\ufe0f\u20e3 \ud83e\uddee **Function Code**\n\n**Node Name:** `Extract & Format Funding Data`\n\ud83d\udccc **Purpose:** This node **cleans up** the Crunchbase response and **reformats** it into something easy to read and store.\n\n\ud83d\udee0 **How it works:**\n\n* Pulls out only the relevant fields:\n\n * `company_name`\n * `industry`\n * `funding_round_type`\n * `announced_date`\n * `money_raised_usd`\n * `investors`\n * `crunchbase_url`\n* Formats investors as a comma-separated string.\n* Constructs a clickable Crunchbase URL.\n\n\ud83c\udfaf **Why it's powerful:**\n\n* Converts a complex API response into a **clean row of data**.\n* Makes your data Google Sheets\u2013ready.\n\n\ud83d\udca1 **Pro Tip for Beginners:**\n\n* You don\u2019t need to write the code! Just copy-paste the provided script.\n* You can even add more fields if needed by editing the Function node.\n\n---\n\n### 4\ufe0f\u20e3 \ud83d\udcc4 **Google Sheets (Append)**\n\n**Node Name:** `Log to Google Sheets`\n\ud83d\udccc **Purpose:** This final step **writes the funding data** to your connected Google Sheet.\n\n\ud83d\udee0 **How it works:**\n\n* Authenticates via your Google Account.\n* Selects your target spreadsheet and sheet.\n* Automatically appends a **new row** for each funding round found.\n\n\ud83c\udfaf **Why it's powerful:**\n\n* Creates a **live funding database** you can filter, share, or analyze.\n* Perfect for:\n\n * Startup scouts\n * VC analysts\n * Market researchers\n\n\ud83d\udca1 **Pro Tip for Beginners:**\n\n* You can create graphs and dashboards in Google Sheets based on this data.\n* Add conditional formatting to highlight large funding rounds or specific investors.\n\n---\n\n## \u2705 Final Thoughts: Why This Workflow Rocks \ud83d\udca5\n\n* \ud83e\udde0 **Smart Automation**: Set once, learn daily.\n* \ud83d\udcca **Investor-Grade Intelligence**: Build a database that rivals paid tools.\n* \ud83d\udd27 **Customizable**: Change industries, countries, or even add Slack notifications.\n* \ud83c\udd93 **No Code Needed**: Powered by drag-and-drop logic in n8n.\n\n---\n\n\n"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "519faa6a-5105-4743-9661-75b5bf1aade3",
"connections": {
"Extract & Format Funding Data": {
"main": [
[
{
"node": "Log to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Fetch Crunchbase Funding Rounds": {
"main": [
[
{
"node": "Extract & Format Funding Data",
"type": "main",
"index": 0
}
]
]
},
"Daily Check for New Funding Rounds": {
"main": [
[
{
"node": "Fetch Crunchbase Funding Rounds",
"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 startup funding intelligence tool designed to transform market research into actionable insights. By intelligently connecting CrunchBase, data processing, and Google Sheets, this workflow: Discovers Funding Opportunities:…
Source: https://n8n.io/workflows/4730/ — 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