Workflow: Itemlists Workflow
Integrations: code, googleSheets, httpRequest, itemLists, merge, scheduleTrigger, set, stickyNote

{"meta": {"instanceId": "workflow-d0e07a21", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:42.455908", "updatedAt": "2025-09-29T07:07:42.455951", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "nodes": [{"id": "0d901abb-f11b-4fdc-88d0-1bbd906ff332", "name": "Split results", "type": "n8n-nodes-base.itemLists", "position": [1040, 460], "parameters": {"options": {}, "fieldToSplitOut": "results"}, "typeVersion": 1, "notes": "This itemLists node performs automated tasks as part of the workflow."}, {"id": "b522f5bc-480c-4a6a-a44b-55ca68c66ad5", "name": "Piloterr - Get Recent Fundraise - Serie A", "type": "n8n-nodes-base.httpRequest", "position": [740, 460], "parameters": {"url": "{{ $env.API_BASE_URL }}", "options": {}, "sendQuery": true, "authentication": "{{ $credentials.genericCredentialType }}", "genericAuthType": "httpHeaderAuth", "queryParameters": {"parameters": [{"name": "days_since_announcement", "value": "1"}, {"name": "investment_type", "value": "series_a"}]}}, "credentials": {"httpHeaderAuth": {"id": "{{ $credentials.httpHeaderAuth.id }}", "name": "Pilotr"}}, "typeVersion": 3, "notes": "This httpRequest node performs automated tasks as part of the workflow."}, {"id": "5965b7cd-66f4-4c5b-82a2-e9526fb4b366", "name": "Piloterr - Get Recent Fundraise - Serie B", "type": "n8n-nodes-base.httpRequest", "position": [740, 660], "parameters": {"url": "{{ $env.API_BASE_URL }}", "options": {}, "sendQuery": true, "authentication": "{{ $credentials.genericCredentialType }}", "genericAuthType": "httpHeaderAuth", "queryParameters": {"parameters": [{"name": "days_since_announcement", "value": "1"}, {"name": "investment_type", "value": "series_b"}]}}, "credentials": {"httpHeaderAuth": {"id": "{{ $credentials.httpHeaderAuth.id }}", "name": "Pilotr"}}, "typeVersion": 3, "notes": "This httpRequest node performs automated tasks as part of the workflow."}, {"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": "{{ $env.BASE_URL }}", "announced_on": "={{ $json.announced_on }}", "company_name": "={{ $json.company_name }}", "founded_date": "={{ $json.founded_date }}", "linkedin_url": "{{ $env.BASE_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": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Sheet1"}, "documentId": {"__rl": true, "mode": "url", "value": "{{ $env.WEBHOOK_URL }}", "__regex": "https:\\/\\/(?:drive|docs)\\.google\\.com\\/\\w+\\/d\\/([0-9a-zA-Z\\-_]+)(?:\\/.*|)"}}, "credentials": {"googleSheetsOAuth2Api": {"id": "{{ $credentials.googleSheetsOAuth2Api.id }}", "name": "Google Sheets account lucas"}}, "typeVersion": 4, "notes": "This googleSheets node performs automated tasks as part of the workflow."}, {"id": "f88a862c-c413-4248-b061-2a449c6ee0fb", "name": "Piloterr - Get Recent Fundraise - Seed", "type": "n8n-nodes-base.httpRequest", "position": [740, 860], "parameters": {"url": "{{ $env.API_BASE_URL }}", "options": {}, "sendQuery": true, "authentication": "{{ $credentials.genericCredentialType }}", "genericAuthType": "httpHeaderAuth", "queryParameters": {"parameters": [{"name": "days_since_announcement", "value": "1"}, {"name": "investment_type", "value": "seed"}]}}, "credentials": {"httpHeaderAuth": {"id": "{{ $credentials.httpHeaderAuth.id }}", "name": "Pilotr"}}, "typeVersion": 3, "notes": "This httpRequest node performs automated tasks as part of the workflow."}, {"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, "notes": "This set node performs automated tasks as part of the workflow."}, {"id": "8fad9822-dfe3-4106-981f-f2c8163ce8a0", "name": "Piloterr - Enrich company", "type": "n8n-nodes-base.httpRequest", "position": [1520, 580], "parameters": {"url": "{{ $env.API_BASE_URL }}", "options": {"batching": {"batch": {"batchSize": 3}}}, "sendQuery": true, "authentication": "{{ $credentials.genericCredentialType }}", "genericAuthType": "httpHeaderAuth", "queryParameters": {"parameters": [{"name": "query", "value": "={{ $env.WEBHOOK_URL }}{{ $json[\"link\"] }}"}]}}, "credentials": {"httpHeaderAuth": {"id": "{{ $credentials.httpHeaderAuth.id }}", "name": "Pilotr"}}, "typeVersion": 3, "continueOnFail": true, "notes": "This httpRequest node performs automated tasks as part of the workflow."}, {"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, "notes": "This merge node performs automated tasks as part of the workflow."}, {"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: {{ $env.WEBHOOK_URL }}\n"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"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, "notes": "This scheduleTrigger node performs automated tasks as part of the workflow."}, {"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, "notes": "This set node performs automated tasks as part of the workflow."}, {"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, "notes": "This code node performs automated tasks as part of the workflow."}, {"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, "notes": "This stickyNote node performs automated tasks as part of the workflow."}], "pinData": {}, "connections": {"b522f5bc-480c-4a6a-a44b-55ca68c66ad5": {"main": [[{"node": "error-handler-b522f5bc-480c-4a6a-a44b-55ca68c66ad5", "type": "main", "index": 0}], [{"node": "error-handler-b522f5bc-480c-4a6a-a44b-55ca68c66ad5-f8428c06", "type": "main", "index": 0}], [{"node": "error-handler-b522f5bc-480c-4a6a-a44b-55ca68c66ad5-459c969b", "type": "main", "index": 0}], [{"node": "error-handler-b522f5bc-480c-4a6a-a44b-55ca68c66ad5-01bc99a1", "type": "main", "index": 0}], [{"node": "error-handler-b522f5bc-480c-4a6a-a44b-55ca68c66ad5-def136f7", "type": "main", "index": 0}], [{"node": "error-handler-b522f5bc-480c-4a6a-a44b-55ca68c66ad5-46209b76", "type": "main", "index": 0}], [{"node": "error-handler-b522f5bc-480c-4a6a-a44b-55ca68c66ad5-7324e556", "type": "main", "index": 0}], [{"node": "error-handler-b522f5bc-480c-4a6a-a44b-55ca68c66ad5-db0efbf8", "type": "main", "index": 0}], [{"node": "error-handler-b522f5bc-480c-4a6a-a44b-55ca68c66ad5-bf975dea", "type": "main", "index": 0}]]}, "5965b7cd-66f4-4c5b-82a2-e9526fb4b366": {"main": [[{"node": "error-handler-5965b7cd-66f4-4c5b-82a2-e9526fb4b366", "type": "main", "index": 0}], [{"node": "error-handler-5965b7cd-66f4-4c5b-82a2-e9526fb4b366-1186c804", "type": "main", "index": 0}], [{"node": "error-handler-5965b7cd-66f4-4c5b-82a2-e9526fb4b366-46a42a5f", "type": "main", "index": 0}], [{"node": "error-handler-5965b7cd-66f4-4c5b-82a2-e9526fb4b366-2ed38c0a", "type": "main", "index": 0}], [{"node": "error-handler-5965b7cd-66f4-4c5b-82a2-e9526fb4b366-3eeeda57", "type": "main", "index": 0}], [{"node": "error-handler-5965b7cd-66f4-4c5b-82a2-e9526fb4b366-4bb7505f", "type": "main", "index": 0}], [{"node": "error-handler-5965b7cd-66f4-4c5b-82a2-e9526fb4b366-35f72dda", "type": "main", "index": 0}], [{"node": "error-handler-5965b7cd-66f4-4c5b-82a2-e9526fb4b366-2806132e", "type": "main", "index": 0}], [{"node": "error-handler-5965b7cd-66f4-4c5b-82a2-e9526fb4b366-80e3a48e", "type": "main", "index": 0}]]}, "f88a862c-c413-4248-b061-2a449c6ee0fb": {"main": [[{"node": "error-handler-f88a862c-c413-4248-b061-2a449c6ee0fb", "type": "main", "index": 0}], [{"node": "error-handler-f88a862c-c413-4248-b061-2a449c6ee0fb-691bee90", "type": "main", "index": 0}], [{"node": "error-handler-f88a862c-c413-4248-b061-2a449c6ee0fb-35e78625", "type": "main", "index": 0}], [{"node": "error-handler-f88a862c-c413-4248-b061-2a449c6ee0fb-30cd6153", "type": "main", "index": 0}], [{"node": "error-handler-f88a862c-c413-4248-b061-2a449c6ee0fb-0120ffbe", "type": "main", "index": 0}], [{"node": "error-handler-f88a862c-c413-4248-b061-2a449c6ee0fb-4bfa328a", "type": "main", "index": 0}], [{"node": "error-handler-f88a862c-c413-4248-b061-2a449c6ee0fb-1224d898", "type": "main", "index": 0}], [{"node": "error-handler-f88a862c-c413-4248-b061-2a449c6ee0fb-1b3cfbd3", "type": "main", "index": 0}], [{"node": "error-handler-f88a862c-c413-4248-b061-2a449c6ee0fb-b99fcad9", "type": "main", "index": 0}]]}, "8fad9822-dfe3-4106-981f-f2c8163ce8a0": {"main": [[{"node": "error-handler-8fad9822-dfe3-4106-981f-f2c8163ce8a0", "type": "main", "index": 0}], [{"node": "error-handler-8fad9822-dfe3-4106-981f-f2c8163ce8a0-c861c405", "type": "main", "index": 0}], [{"node": "error-handler-8fad9822-dfe3-4106-981f-f2c8163ce8a0-b78d9540", "type": "main", "index": 0}], [{"node": "error-handler-8fad9822-dfe3-4106-981f-f2c8163ce8a0-313174a3", "type": "main", "index": 0}], [{"node": "error-handler-8fad9822-dfe3-4106-981f-f2c8163ce8a0-41c0af46", "type": "main", "index": 0}], [{"node": "error-handler-8fad9822-dfe3-4106-981f-f2c8163ce8a0-852ba984", "type": "main", "index": 0}], [{"node": "error-handler-8fad9822-dfe3-4106-981f-f2c8163ce8a0-31fa3060", "type": "main", "index": 0}], [{"node": "error-handler-8fad9822-dfe3-4106-981f-f2c8163ce8a0-05fea20e", "type": "main", "index": 0}], [{"node": "error-handler-8fad9822-dfe3-4106-981f-f2c8163ce8a0-da8cbb8f", "type": "main", "index": 0}]]}, "04ab7fe9-6422-45c3-b165-139577a0e27f": {"main": [[{"node": "error-handler-04ab7fe9-6422-45c3-b165-139577a0e27f-c53557cd", "type": "main", "index": 0}]]}}, "name": "Itemlists Workflow", "settings": {"executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000}, "description": "Automated workflow: Itemlists Workflow. This workflow integrates 9 different services: itemLists, httpRequest, stickyNote, code, scheduleTrigger. It contains 22 nodes and follows best practices for error handling and security.", "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "notes": "Excellent quality workflow: Itemlists Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}