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 →
{
"nodes": [
{
"id": "0d901abb-f11b-4fdc-88d0-1bbd906ff332",
"name": "Split results",
"type": "n8n-nodes-base.itemLists",
"position": [
1040,
460
],
"parameters": {
"options": {},
"fieldToSplitOut": "results"
},
"typeVersion": 1
},
{
"id": "b522f5bc-480c-4a6a-a44b-55ca68c66ad5",
"name": "Piloterr - Get Recent Fundraise - Serie A",
"type": "n8n-nodes-base.httpRequest",
"position": [
740,
460
],
"parameters": {
"url": "https://piloterr.com/api/v2/crunchbase/funding_rounds",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "days_since_announcement",
"value": "1"
},
{
"name": "investment_type",
"value": "series_a"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"typeVersion": 3
},
{
"id": "5965b7cd-66f4-4c5b-82a2-e9526fb4b366",
"name": "Piloterr - Get Recent Fundraise - Serie B",
"type": "n8n-nodes-base.httpRequest",
"position": [
740,
660
],
"parameters": {
"url": "https://piloterr.com/api/v2/crunchbase/funding_rounds",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "days_since_announcement",
"value": "1"
},
{
"name": "investment_type",
"value": "series_b"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"typeVersion": 3
},
{
"id": "04ab7fe9-6422-45c3-b165-139577a0e27f",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
2360,
480
],
"parameters": {
"columns": {
"value": {
"link": "={{ $json.link }}",
"type": "={{ $json.type }}",
"country": "={{ $json.country }}",
"event_link": "={{ $json.event_link }}",
"website_url": "={{ $json.website_url }}",
"announced_on": "={{ $json.announced_on }}",
"company_name": "={{ $json.company_name }}",
"founded_date": "={{ $json.founded_date }}",
"linkedin_url": "={{ $json.linkedin_url }}",
"money_raised": "={{ $json.money_raised }}",
"funding_total": "={{ $json.funding_total }}",
"employee_count": "={{ $json.employee_count }}",
"investment_type": "={{ $json.investment_type }}",
"monthly_traffic_semrush": "={{ $json.monthly_traffic_semrush }}"
},
"schema": [
{
"id": "company_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "website_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "website_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "money_raised",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "money_raised",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "announced_on",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "announced_on",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "funding_total",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "funding_total",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "link",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "monthly_traffic_semrush",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "monthly_traffic_semrush",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "event_link",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "event_link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "employee_count",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "employee_count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "founded_date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "founded_date",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"event_link"
]
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1IZ7BJUtBdezesDS5oBDzFeW-btiH7qB4gdIcwcC01xs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "https://docs.google.com/spreadsheets/d/1IZ7BJUtBdezesDS5oBDzFeW-btiH7qB4gdIcwcC01xs/edit#gid=0",
"__regex": "https:\\/\\/(?:drive|docs)\\.google\\.com\\/\\w+\\/d\\/([0-9a-zA-Z\\-_]+)(?:\\/.*|)"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 4
},
{
"id": "f88a862c-c413-4248-b061-2a449c6ee0fb",
"name": "Piloterr - Get Recent Fundraise - Seed",
"type": "n8n-nodes-base.httpRequest",
"position": [
740,
860
],
"parameters": {
"url": "https://piloterr.com/api/v2/crunchbase/funding_rounds",
"options": {},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "days_since_announcement",
"value": "1"
},
{
"name": "investment_type",
"value": "seed"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"typeVersion": 3
},
{
"id": "38521229-d315-4bb3-bece-72ff64f602e8",
"name": "Prepare data",
"type": "n8n-nodes-base.set",
"position": [
1280,
460
],
"parameters": {
"values": {
"string": [
{
"name": "type",
"value": "={{ $json.investment_type }}"
},
{
"name": "money_raised",
"value": "={{ $json.money_raised.value_usd }}"
},
{
"name": "announced_on",
"value": "={{ $json.announced_on }}"
},
{
"name": "company_name",
"value": "={{ $json.funded_organization_identifier.value }}"
},
{
"name": "link",
"value": "={{ $json.funded_organization_identifier.permalink }}"
},
{
"name": "event_link",
"value": "={{ $json.identifier.permalink }}"
}
]
},
"options": {},
"keepOnlySet": true
},
"typeVersion": 2
},
{
"id": "8fad9822-dfe3-4106-981f-f2c8163ce8a0",
"name": "Piloterr - Enrich company",
"type": "n8n-nodes-base.httpRequest",
"position": [
1520,
580
],
"parameters": {
"url": "https://piloterr.com/api/v2/crunchbase/company/info",
"options": {
"batching": {
"batch": {
"batchSize": 3
}
}
},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "query",
"value": "=https://www.crunchbase.com/organization/{{ $json[\"link\"] }}"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"name": "<your credential>"
}
},
"typeVersion": 3,
"continueOnFail": true
},
{
"id": "78289f0d-5721-4615-a883-38a1e48ebb34",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"position": [
2100,
480
],
"parameters": {
"mode": "combine",
"options": {},
"combinationMode": "mergeByPosition"
},
"typeVersion": 2.1
},
{
"id": "d5e659d7-28ba-4cd7-a6bf-ea7b48d5f34c",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
280
],
"parameters": {
"width": 318.8857938718665,
"height": 287.01949860724255,
"content": "## Read me\n\nThis workflow will scrape recent fundraising events from Crunchbase, and add them in Google Sheets.\n\nFull guide here: https://lempire.notion.site/Get-recent-fundraising-in-Google-Sheets-dafbbda2635544b4925c4fb04abac8f5?pvs=74\n"
},
"typeVersion": 1
},
{
"id": "888f5bf2-4a7f-4f84-95c8-4173fa8d8f83",
"name": "Schedule Trigger - Run Workflow Every Day",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
460,
460
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 8
}
]
}
},
"typeVersion": 1
},
{
"id": "84f02477-b19c-405f-abde-3e32280208e9",
"name": "Prepare data before importing to Gsheets",
"type": "n8n-nodes-base.set",
"position": [
1860,
580
],
"parameters": {
"values": {
"string": [
{
"name": "website_url",
"value": "={{ $json.website.match(/https?:\\/\\/(?:www\\.)?([^\\/]+)/)[1] }}"
},
{
"name": "monthly_traffic_semrush",
"value": "={{ $json.semrush_summary.semrush_visits_latest_month }}"
},
{
"name": "funding_total",
"value": "={{ $json.funding_rounds_headline.funding_total.value }}"
},
{
"name": "linkedin_url",
"value": "={{ $json.linkedin_url }}"
},
{
"name": "employee_count",
"value": "={{ $json.employee_count }}"
},
{
"name": "country",
"value": "={{ $json.location[2].name }}"
},
{
"name": "founded_date",
"value": "={{ $json.founded }}"
}
]
},
"options": {},
"keepOnlySet": true
},
"typeVersion": 2
},
{
"id": "b4952b2f-7202-4b6a-81ec-7251b0d6c308",
"name": "Get Linkedin URL from object",
"type": "n8n-nodes-base.code",
"position": [
1680,
580
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "// Find the LinkedIn object\nlet linkedinObject = $json.social_networks.find(e => e.name === 'linkedin');\n\n// If the LinkedIn object exists, get the URL; otherwise, set to null or handle error\n$input.item.json.linkedin_url = linkedinObject ? linkedinObject.url : null;\n\n// Check if the URL was set\nif (!$input.item.json.linkedin_url) {\n console.error('No LinkedIn URL found!');\n // Handle the error as required for your application\n}\n\nreturn $input.item;"
},
"typeVersion": 1
},
{
"id": "9e98198d-b9f1-42e4-b703-153f98ffce7c",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
680,
254.26329864271463
],
"parameters": {
"height": 818.134682564936,
"content": "Create an account at piloterr.com to get your API key\n\nFeel free to delete the node that are not useful to you. For instance \"Serie B\" and \"Seed\" if you want only to scrape Serie A events"
},
"typeVersion": 1
}
],
"connections": {
"Merge": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Prepare data": {
"main": [
[
{
"node": "Piloterr - Enrich company",
"type": "main",
"index": 0
},
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Split results": {
"main": [
[
{
"node": "Prepare data",
"type": "main",
"index": 0
}
]
]
},
"Piloterr - Enrich company": {
"main": [
[
{
"node": "Get Linkedin URL from object",
"type": "main",
"index": 0
}
]
]
},
"Get Linkedin URL from object": {
"main": [
[
{
"node": "Prepare data before importing to Gsheets",
"type": "main",
"index": 0
}
]
]
},
"Piloterr - Get Recent Fundraise - Seed": {
"main": [
[
{
"node": "Split results",
"type": "main",
"index": 0
}
]
]
},
"Prepare data before importing to Gsheets": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Piloterr - Get Recent Fundraise - Serie A": {
"main": [
[
{
"node": "Split results",
"type": "main",
"index": 0
}
]
]
},
"Piloterr - Get Recent Fundraise - Serie B": {
"main": [
[
{
"node": "Split results",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger - Run Workflow Every Day": {
"main": [
[
{
"node": "Piloterr - Get Recent Fundraise - Serie A",
"type": "main",
"index": 0
},
{
"node": "Piloterr - Get Recent Fundraise - Serie B",
"type": "main",
"index": 0
},
{
"node": "Piloterr - Get Recent Fundraise - Seed",
"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.
googleSheetsOAuth2ApihttpHeaderAuth
About this workflow
Code Schedule. Uses itemLists, httpRequest, googleSheets, stickyNote. Scheduled trigger; 13 nodes.
Source: https://github.com/Zie619/n8n-workflows — original creator credit. Request a take-down →