Avkash Kakdiya This workflow corresponds to n8n.io template #8584 — we link there as the canonical source.
This workflow follows the Airtable → 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": "28 - Funding Insights Pipeline",
"nodes": [
{
"id": "4e26cbbf-8379-4aae-811a-853970151119",
"name": "\ud83d\udd50 Daily Check",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-60,
200
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "6ddcfc63-0cee-4e3f-9288-6b5f463f7bdb",
"name": "\ud83d\udcc4 Parse Funding Data",
"type": "n8n-nodes-base.code",
"position": [
380,
200
],
"parameters": {
"jsCode": "// Parse and structure the funding data\nconst items = [];\n\nif ($input.first().json.entities) {\n for (const entity of $input.first().json.entities) {\n const properties = entity.properties;\n const fundedOrg = properties.funded_organization_identifier;\n \n // Extract investor names\n let investors = '';\n if (properties.investor_identifiers && properties.investor_identifiers.length > 0) {\n investors = properties.investor_identifiers.map(inv => inv.value).join(', ');\n }\n \n // Extract categories\n let categories = '';\n if (fundedOrg && fundedOrg.categories && fundedOrg.categories.length > 0) {\n categories = fundedOrg.categories.map(cat => cat.value).join(', ');\n }\n \n // Format funding amount\n let fundingAmount = 'N/A';\n if (properties.funding_round_money_raised && properties.funding_round_money_raised.value_usd) {\n fundingAmount = `$${(properties.funding_round_money_raised.value_usd / 1000000).toFixed(2)}M`;\n }\n \n items.push({\n json: {\n company_name: fundedOrg ? fundedOrg.value : 'N/A',\n funding_amount: fundingAmount,\n funding_type: properties.investment_type ? properties.investment_type.value : 'N/A',\n announced_date: properties.announced_on ? properties.announced_on.value : 'N/A',\n description: fundedOrg && fundedOrg.short_description ? fundedOrg.short_description : 'N/A',\n website: fundedOrg && fundedOrg.website ? fundedOrg.website.value : 'N/A',\n industry: categories || 'N/A',\n investors: investors || 'N/A',\n crunchbase_url: fundedOrg ? `https://www.crunchbase.com/organization/${fundedOrg.permalink}` : 'N/A',\n scraped_at: new Date().toISOString().split('T')[0]\n }\n });\n }\n}\n\nreturn items;"
},
"typeVersion": 2
},
{
"id": "de6857e8-7ec0-4433-b36e-50df001acbbb",
"name": "\ud83d\udcca Save to Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
820,
100
],
"parameters": {
"columns": {
"values": {
"Website": "={{$json.website}}",
"Industry": "={{$json.industry}}",
"Investors": "={{$json.investors}}",
"Scraped At": "={{$json.scraped_at}}",
"Description": "={{$json.description}}",
"Company Name": "={{$json.company_name}}",
"Funding Type": "={{$json.funding_type}}",
"Crunchbase URL": "={{$json.crunchbase_url}}",
"Date Announced": "={{$json.announced_date}}",
"Funding Amount": "={{$json.funding_amount}}"
},
"mappingMode": "defineBelow"
},
"options": {
"cellFormat": "USER_ENTERED"
},
"operation": "appendOrUpdate",
"sheetName": "Funding Tracker",
"documentId": {
"__rl": true,
"mode": "id",
"value": "YOUR_GOOGLE_SHEET_ID"
}
},
"typeVersion": 4.4
},
{
"id": "05653b74-d30c-4af6-8b17-f4f9fba3cf38",
"name": "\ud83d\uddc2\ufe0f Save to Airtable",
"type": "n8n-nodes-base.airtable",
"position": [
820,
300
],
"parameters": {
"table": {
"__rl": true,
"mode": "id",
"value": "YOUR_AIRTABLE_TABLE_ID"
},
"options": {},
"operation": "append",
"application": {
"__rl": true,
"mode": "id",
"value": "YOUR_AIRTABLE_APP_ID"
},
"authentication": "airtableOAuth2Api"
},
"typeVersion": 1
},
{
"id": "0fcd4232-c492-4597-8751-874098f23427",
"name": "Workflow Info",
"type": "n8n-nodes-base.stickyNote",
"position": [
-120,
-140
],
"parameters": {
"color": 4,
"width": 420,
"height": 620,
"content": "## 1. Workflow Trigger & Data Fetching (\ud83d\udd50 Daily Check + \ud83d\udcca Fetch Recent Funding)\n\n*The workflow is scheduled to run daily.\n\nIt calls the Crunchbase API (funding_rounds endpoint) to fetch the latest 100 funding rounds, including company details, investors, categories, and funding amounts.\n\nAPI key must be filled in the request URL (user_key={{YOUR_CRUNCHBASE_API_KEY}}).*"
},
"typeVersion": 1
},
{
"id": "31bcef8a-6b0b-40e6-acb8-a3ce53012dea",
"name": "\ud83d\udcc5 Filter Recent (30 days)",
"type": "n8n-nodes-base.filter",
"position": [
600,
200
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "condition-filter",
"operator": {
"type": "dateTime",
"operation": "after",
"rightType": "expression"
},
"leftValue": "={{$json.announced_date}}",
"rightValue": "={{DateTime.now().minus({days: 30}).toFormat('yyyy-MM-dd')}}"
}
]
}
},
"typeVersion": 2
},
{
"id": "8f996c64-c96b-4e20-bb13-469a8e7e69cd",
"name": "\ud83d\udcca Fetch Recent Funding",
"type": "n8n-nodes-base.httpRequest",
"position": [
160,
200
],
"parameters": {
"url": "https://api.crunchbase.com/api/v4/searches/funding_rounds?user_key={{YOUR_CRUNCHBASE_API_KEY}}",
"method": "POST",
"options": {
"response": {
"response": {
"responseFormat": "json"
}
}
},
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "field_ids",
"value": "[\"identifier\",\"funding_round_money_raised\",\"announced_on\",\"funded_organization_identifier\",\"funded_organization_description\",\"funded_organization_website\",\"funded_organization_categories\",\"investor_identifiers\",\"investment_type\"]"
},
{
"name": "order",
"value": "[{\"field_id\":\"announced_on\",\"sort_order\":\"desc\"}]"
},
{
"name": "limit",
"value": "100"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "dcdb1747-d79a-4845-bd63-198580af7ec6",
"name": "Workflow Info1",
"type": "n8n-nodes-base.stickyNote",
"position": [
320,
-140
],
"parameters": {
"width": 420,
"height": 620,
"content": "## 2. Data Processing (\ud83d\udcc4 Parse Funding Data + \ud83d\udcc5 Filter Recent 30 days)\n\n*The raw Crunchbase response is parsed into a clean, structured format with readable fields. Only funding rounds announced in the last 30 days are kept, ensuring the dataset stays fresh and relevant.*"
},
"typeVersion": 1
},
{
"id": "b9049419-7c57-4da7-9d72-0f4b037dc937",
"name": "Workflow Info2",
"type": "n8n-nodes-base.stickyNote",
"position": [
760,
-140
],
"parameters": {
"color": 3,
"width": 340,
"height": 620,
"content": "## 3. Storage Outputs (\ud83d\udcca Save to Google Sheets + \ud83d\uddc2\ufe0f Save to Airtable)\n\n*Filtered funding records are saved into both Google Sheets (for easy sharing and reporting) and Airtable (for database-style management). Both outputs store the same standardized fields, ensuring consistency across tools.*"
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"connections": {
"\ud83d\udd50 Daily Check": {
"main": [
[
{
"node": "\ud83d\udcca Fetch Recent Funding",
"type": "main",
"index": 0
}
]
]
},
"\ud83d\udcc4 Parse Funding Data": {
"main": [
[
{
"node": "\ud83d\udcc5 Filter Recent (30 days)",
"type": "main",
"index": 0
}
]
]
},
"\ud83d\uddc2\ufe0f Save to Airtable": {
"main": [
[]
]
},
"\ud83d\udcca Fetch Recent Funding": {
"main": [
[
{
"node": "\ud83d\udcc4 Parse Funding Data",
"type": "main",
"index": 0
}
]
]
},
"\ud83d\udcca Save to Google Sheets": {
"main": [
[]
]
},
"\ud83d\udcc5 Filter Recent (30 days)": {
"main": [
[
{
"node": "\ud83d\udcca Save to Google Sheets",
"type": "main",
"index": 0
},
{
"node": "\ud83d\uddc2\ufe0f Save to Airtable",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow runs daily to collect the latest funding round data from Crunchbase. It retrieves up to 100 recent funding events, including company, investors, funding amount, and industry details. The data is cleaned and filtered to only include rounds announced in the last 30…
Source: https://n8n.io/workflows/8584/ — 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 tax compliance by aggregating multi-channel revenue data, calculating jurisdiction-specific tax obligations, detecting anomalies, and generating submission-ready reports for ta
This n8n workflow automates the end-to-end client onboarding process: capturing client details, validating emails, assigning tiers, generating welcome packs, creating tasks, notifying teams, archiving
Automate B2B order invoicing by fetching orders from Airtable, validating paid B2B entries, creating Stripe customers and invoices, finalizing invoices, and logging structured invoice data into Google
This workflow automatically collects a list of companies from Google Sheets, searches for their competitors using SerpAPI, extracts up to 10 relevant competitor names with source links, and logs the r
Automates Singapore COE price tracking with AI forecasts and buy/wait recommendations. Weekly scraping collects LTA data, enriches with economic indicators, predicts 6-month trends, and alerts users v