Yaron Been This workflow corresponds to n8n.io template #4796 — 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": "i7gyrJ5t5sp9Pfd1",
"name": "15. Track US Fintech & Healthtech Funding Rounds: Crunchbase to Google Sheets",
"tags": [],
"nodes": [
{
"id": "7ebfa8fe-9d81-446e-9e67-004d9f8e25b8",
"name": "Daily Check for New Funding Rounds",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-464,
-416
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 8
}
]
}
},
"typeVersion": 1.2
},
{
"id": "425b2288-ccbd-422b-9eb5-f0c0f7c2dea3",
"name": "Fetch Crunchbase Funding Rounds",
"type": "n8n-nodes-base.httpRequest",
"position": [
-256,
-416
],
"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": "d1911a79-bd6d-427d-9618-cea041844959",
"name": "Extract & Format Funding Data",
"type": "n8n-nodes-base.code",
"position": [
80,
-416
],
"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": "76af1187-696a-41d0-bfb8-8666a82d0006",
"name": "Save to Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
400,
-416
],
"parameters": {
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_GOOGLE_SHEET_ID"
}
},
"typeVersion": 3
},
{
"id": "638678b6-34e6-45d7-8807-90ec9c67b4a8",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2464,
-1424
],
"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": "423fdd70-85ad-466e-8cbd-84ff6e35c47d",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2464,
-1088
],
"parameters": {
"color": 4,
"width": 1289,
"height": 2046,
"content": "# Track US Fintech & Healthtech Funding Rounds: Crunchbase to Google Sheets\n\n### \ud83c\udf0d **Overview**\n\nThis workflow fetches the **latest funding rounds from Crunchbase** (filtered by industry + location), formats the results, and saves them neatly into **Google Sheets** every day.\n\nYou end up with a **live deal flow tracker** that updates itself!\n\n---\n\n## \ud83d\udfe2 Section 1: Schedule & Data Fetch\n\n\ud83d\udd17 **Nodes:**\n1\ufe0f\u20e3 **Daily Check for New Funding Rounds (Schedule Trigger)**\n\u23f0 Runs automatically **every morning at 8 AM**.\n\n* Why it\u2019s useful: You don\u2019t need to run it manually.\n\n2\ufe0f\u20e3 **Fetch Crunchbase Funding Rounds (HTTP Request)**\n\ud83c\udf10 Pulls funding rounds from Crunchbase\u2019s API.\n\n* Filters:\n\n * \ud83d\udccd Location \u2192 *United States*\n * \ud83c\udfed Industry \u2192 *Fintech, Healthtech*\n * \u23f3 Sorted \u2192 newest first\n * \ud83d\udcc4 Limit \u2192 25 per run\n\n\ud83d\udca1 **Beginner Benefit**:\n\u2705 No coding required to hit Crunchbase API\n\u2705 Automated \u2014 always fetches fresh funding data\n\n---\n\n## \ud83d\udd35 Section 2: Extract & Format\n\n\ud83d\udd17 **Nodes:**\n3\ufe0f\u20e3 **Extract & Format Funding Data (Code)**\n\ud83d\udcd1 Converts Crunchbase API JSON into **clean, readable rows** with:\n\n* \ud83c\udfe2 Company Name\n* \ud83c\udfed Industry\n* \ud83d\udcb5 Money Raised (USD)\n* \ud83d\udcc5 Announced Date\n* \ud83c\udff7\ufe0f Funding Round Type\n* \ud83d\udc65 Investors\n* \ud83d\udd17 Crunchbase URL\n\n\ud83d\udca1 **Beginner Benefit**:\n\u2705 No messy JSON \u2192 clean structured output\n\u2705 Auto-creates a link to each funding round\n\n---\n\n## \ud83d\udfe3 Section 3: Save to Sheets\n\n\ud83d\udd17 **Nodes:**\n4\ufe0f\u20e3 **Save to Google Sheets**\n\ud83d\udcca Appends the formatted funding round data into your Google Sheet.\n\n* Columns: Company, Industry, Investors, Amount, Date, URL, etc.\n\n\ud83d\udca1 **Beginner Benefit**:\n\u2705 Data goes directly into Google Sheets \u2192 no copy-paste\n\u2705 You can filter, chart, or connect Sheets to dashboards\n\n---\n\n## \ud83d\udcca Final Overview\n\n| Section | What Happens | Why It\u2019s Useful |\n| --------- | --------------------- | ----------------------------------------------- |\n| \ud83d\udfe2 Fetch | Scheduler + API fetch | Always pulls new Crunchbase deals automatically |\n| \ud83d\udd35 Format | Extract + clean JSON | Turns raw API data into readable rows |\n| \ud83d\udfe3 Save | Google Sheets | Creates your own funding tracker sheet |\n\n---\n\n## \ud83d\ude80 Why This Workflow is a Game-Changer\n\n* \u23f1\ufe0f **Zero manual work** \u2192 Wake up to fresh funding data daily\n* \ud83d\udcca **Deal flow in Sheets** \u2192 Perfect for VCs, founders, analysts\n* \ud83d\udd0d **Customizable filters** \u2192 Change location, industry, or # of results\n* \ud83d\udd17 **Action-ready** \u2192 Use Sheets to track trends, outreach investors, or monitor competitors\n\n---\n\n\u2728 With this workflow, you\u2019ve basically built your **own Crunchbase alerts dashboard** \u2014 no coding required!\n\n---"
},
"typeVersion": 1
},
{
"id": "b610c896-49c3-4076-90ab-d5c3b3f75674",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-496,
-1104
],
"parameters": {
"color": 3,
"width": 384,
"height": 880,
"content": "## \ud83d\udfe2 Section 1: Schedule & Data Fetch\n\n\ud83d\udd17 **Nodes:**\n1\ufe0f\u20e3 **Daily Check for New Funding Rounds (Schedule Trigger)**\n\u23f0 Runs automatically **every morning at 8 AM**.\n\n* Why it\u2019s useful: You don\u2019t need to run it manually.\n\n2\ufe0f\u20e3 **Fetch Crunchbase Funding Rounds (HTTP Request)**\n\ud83c\udf10 Pulls funding rounds from Crunchbase\u2019s API.\n\n* Filters:\n\n * \ud83d\udccd Location \u2192 *United States*\n * \ud83c\udfed Industry \u2192 *Fintech, Healthtech*\n * \u23f3 Sorted \u2192 newest first\n * \ud83d\udcc4 Limit \u2192 25 per run\n\n\ud83d\udca1 **Beginner Benefit**:\n\u2705 No coding required to hit Crunchbase API\n\u2705 Automated \u2014 always fetches fresh funding data\n\n---\n\n"
},
"typeVersion": 1
},
{
"id": "fcf0c602-5c25-44f2-a51e-bf13afa9eac6",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
16,
-1056
],
"parameters": {
"color": 6,
"height": 832,
"content": "## \ud83d\udd35 Section 2: Extract & Format\n\n\ud83d\udd17 **Nodes:**\n3\ufe0f\u20e3 **Extract & Format Funding Data (Code)**\n\ud83d\udcd1 Converts Crunchbase API JSON into **clean, readable rows** with:\n\n* \ud83c\udfe2 Company Name\n* \ud83c\udfed Industry\n* \ud83d\udcb5 Money Raised (USD)\n* \ud83d\udcc5 Announced Date\n* \ud83c\udff7\ufe0f Funding Round Type\n* \ud83d\udc65 Investors\n* \ud83d\udd17 Crunchbase URL\n\n\ud83d\udca1 **Beginner Benefit**:\n\u2705 No messy JSON \u2192 clean structured output\n\u2705 Auto-creates a link to each funding round\n\n---\n\n"
},
"typeVersion": 1
},
{
"id": "1d5cb1aa-8813-403d-bf7d-c66b6981149e",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
336,
-1504
],
"parameters": {
"color": 5,
"height": 1280,
"content": "## \ud83d\udd35 Section 2: Extract & Format\n\n\ud83d\udd17 **Nodes:**\n3\ufe0f\u20e3 **Extract & Format Funding Data (Code)**\n\ud83d\udcd1 Converts Crunchbase API JSON into **clean, readable rows** with:\n\n* \ud83c\udfe2 Company Name\n* \ud83c\udfed Industry\n* \ud83d\udcb5 Money Raised (USD)\n* \ud83d\udcc5 Announced Date\n* \ud83c\udff7\ufe0f Funding Round Type\n* \ud83d\udc65 Investors\n* \ud83d\udd17 Crunchbase URL\n\n\ud83d\udca1 **Beginner Benefit**:\n\u2705 No messy JSON \u2192 clean structured output\n\u2705 Auto-creates a link to each funding round\n\n---\n\n## \ud83d\udfe3 Section 3: Save to Sheets\n\n\ud83d\udd17 **Nodes:**\n4\ufe0f\u20e3 **Save to Google Sheets**\n\ud83d\udcca Appends the formatted funding round data into your Google Sheet.\n\n* Columns: Company, Industry, Investors, Amount, Date, URL, etc.\n\n\ud83d\udca1 **Beginner Benefit**:\n\u2705 Data goes directly into Google Sheets \u2192 no copy-paste\n\u2705 You can filter, chart, or connect Sheets to dashboards\n\n---\n\n"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "2aa57dde-1319-48ee-88eb-91b028059630",
"connections": {
"Extract & Format Funding Data": {
"main": [
[
{
"node": "Save 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
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow fetches the latest funding rounds from Crunchbase (filtered by industry + location), formats the results, and saves them neatly into Google Sheets every day.
Source: https://n8n.io/workflows/4796/ — 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