Workflow: ProspectLens company research
Integrations: filter, googleSheets, httpRequest, manualTrigger, splitInBatches, stickyNote

{"id": "wwvUsosYUyMfpGbB", "meta": {"instanceId": "workflow-82c3e5fd", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:44.906539", "updatedAt": "2025-09-29T07:07:44.906560", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "name": "ProspectLens company research", "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "nodes": [{"id": "fd68acdf-ed1e-4f69-a046-fcdaa626acca", "name": "When clicking \u2018Test workflow\u2019", "type": "n8n-nodes-base.manualTrigger", "position": [720, 400], "parameters": {}, "typeVersion": 1, "notes": "This manualTrigger node performs automated tasks as part of the workflow."}, {"id": "d4e4875a-e41f-4248-937a-a4658c23eb5e", "name": "Filter", "type": "n8n-nodes-base.filter", "notes": "Only process rows which have empty processed_at field", "position": [1160, 400], "parameters": {"options": {"looseTypeValidation": true}, "conditions": {"options": {"leftValue": "", "caseSensitive": true, "typeValidation": "loose"}, "combinator": "and", "conditions": [{"id": "5aca0836-4797-41d3-8094-f3a170e5a3c9", "operator": {"type": "string", "operation": "empty", "singleValue": true}, "leftValue": "={{ $json.processed_at }}", "rightValue": ""}]}}, "notesInFlow": true, "typeVersion": 2}, {"id": "e12c1846-dd38-414c-8e2e-8d0834ad8668", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [880, 20], "parameters": {"width": 725, "height": 316.25, "content": "## Company research via Google Sheets and ProspectLens\n\nGet your API key:\n{{ $env.API_BASE_URL }}\n\nCopy Google Sheet template:\n{{ $env.WEBHOOK_URL }}"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "b0385041-92c4-41a4-b0e8-9f2a7cc6fd56", "name": "Save company data into Sheets", "type": "n8n-nodes-base.googleSheets", "position": [2000, 380], "parameters": {"columns": {"value": {"data": "={{ JSON.stringify($json.data).substr(0, 2000) }}", "name": "={{ $json.data.properties.title }}", "funds": "={{ $json.data.info.funding_rounds_summary.funding_total.value }}", "domain": "={{ $('Filter').item.json.domain }}", "traffic": "={{ $json.data.info.semrush_summary.semrush_visits_latest_month }}", "location": "={{ $json.data.info.semrush_location_list[0].location_identifiers[0].value }}", "description": "={{ $json.data.properties.short_description }}", "domain_name": "={{ $json.data.info.company_about_fields.website.hostname }}", "processed_at": "={{ (new Date).toISOString()  }}", "year_founded": "={{ $json.data.info.overview_fields_extended.founded_on.value }}", "funding_round": "={{ $json.data.info.funding_rounds_summary.last_funding_type }}", "last_funding_at": "={{ $json.data.info.funding_rounds_summary.last_funding_at }}"}, "schema": [{"id": "domain", "type": "string", "display": true, "removed": false, "required": false, "displayName": "domain", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "name", "type": "string", "display": true, "removed": false, "required": false, "displayName": "name", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "description", "type": "string", "display": true, "removed": false, "required": false, "displayName": "description", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "processed_at", "type": "string", "display": true, "required": false, "displayName": "processed_at", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "data", "type": "string", "display": true, "required": false, "displayName": "data", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "domain_name", "type": "string", "display": true, "required": false, "displayName": "domain_name", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "traffic", "type": "string", "display": true, "required": false, "displayName": "traffic", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "location", "type": "string", "display": true, "removed": false, "required": false, "displayName": "location", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "funds", "type": "string", "display": true, "removed": false, "required": false, "displayName": "funds", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "year_founded", "type": "string", "display": true, "removed": false, "required": false, "displayName": "year_founded", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "funding_round", "type": "string", "display": true, "removed": false, "required": false, "displayName": "funding_round", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "last_funding_at", "type": "string", "display": true, "removed": false, "required": false, "displayName": "last_funding_at", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "row_number", "type": "string", "display": true, "removed": true, "readOnly": true, "required": false, "displayName": "row_number", "defaultMatch": false, "canBeUsedToMatch": true}], "mappingMode": "defineBelow", "matchingColumns": ["domain"]}, "options": {}, "operation": "update", "sheetName": {"__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Sheet1"}, "documentId": {"__rl": true, "mode": "list", "value": "1X2hKT8cD6fTQUdALg91EwQDCM58YNY4pHe-7rmESzlk", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "n8n_prospectlens"}}, "credentials": {"googleSheetsOAuth2Api": {"id": "vowsrhMIxy2PRDbH", "name": "Google Sheets account"}}, "typeVersion": 4.4, "notes": "This googleSheets node performs automated tasks as part of the workflow."}, {"id": "e048f8d0-57c2-43ac-bedf-1a517b203df3", "name": "Loop Over Items", "type": "n8n-nodes-base.splitInBatches", "notes": "Used to keep low concurrency (1 thread)", "position": [1400, 380], "parameters": {"options": {}}, "notesInFlow": true, "typeVersion": 3}, {"id": "b6898b5e-dba5-425d-8f9b-d996dcb6cff2", "name": "ProspectLens API call", "type": "n8n-nodes-base.httpRequest", "notes": "ProspectLens API", "onError": "continueErrorOutput", "maxTries": 2, "position": [1680, 380], "parameters": {"url": "{{ $env.BASE_URL }}", "options": {"response": {"response": {}}}, "authentication": "{{ $credentials.genericCredentialType }}", "genericAuthType": "httpHeaderAuth"}, "credentials": {"httpHeaderAuth": {"id": "tcCkO83Qn399Hizf", "name": "APIRoad auth"}}, "notesInFlow": true, "retryOnFail": true, "typeVersion": 4.2}, {"id": "4c625e34-728c-49ae-8e22-4b4a343354cb", "name": "Get all rows from Sheets", "type": "n8n-nodes-base.googleSheets", "position": [940, 400], "parameters": {"options": {}, "sheetName": {"__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Sheet1"}, "documentId": {"__rl": true, "mode": "list", "value": "1X2hKT8cD6fTQUdALg91EwQDCM58YNY4pHe-7rmESzlk", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "n8n_prospectlens"}}, "credentials": {"googleSheetsOAuth2Api": {"id": "vowsrhMIxy2PRDbH", "name": "Google Sheets account"}}, "typeVersion": 4.4, "notes": "This googleSheets node performs automated tasks as part of the workflow."}], "active": false, "pinData": {}, "settings": {"executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000}, "versionId": "ea844f9f-c06e-4a0c-98db-a670709c2025", "connections": {"b6898b5e-dba5-425d-8f9b-d996dcb6cff2": {"main": [[{"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2", "type": "main", "index": 0}], [{"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2-edc74dae", "type": "main", "index": 0}], [{"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2-e874db6c", "type": "main", "index": 0}], [{"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2-5eec2d3f", "type": "main", "index": 0}], [{"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2-dfec4d35", "type": "main", "index": 0}], [{"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2-9289e9e2", "type": "main", "index": 0}], [{"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2-356250dd", "type": "main", "index": 0}], [{"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2-d6ded6ce", "type": "main", "index": 0}], [{"node": "error-handler-b6898b5e-dba5-425d-8f9b-d996dcb6cff2-c3fb2266", "type": "main", "index": 0}]]}, "b0385041-92c4-41a4-b0e8-9f2a7cc6fd56": {"main": [[{"node": "error-handler-b0385041-92c4-41a4-b0e8-9f2a7cc6fd56-a85c0966", "type": "main", "index": 0}]]}, "4c625e34-728c-49ae-8e22-4b4a343354cb": {"main": [[{"node": "error-handler-4c625e34-728c-49ae-8e22-4b4a343354cb-73f6ff08", "type": "main", "index": 0}]]}}, "description": "Automated workflow: ProspectLens company research. This workflow integrates 7 different services: filter, stickyNote, httpRequest, stopAndError, manualTrigger. It contains 11 nodes and follows best practices for error handling and security.", "notes": "Excellent quality workflow: ProspectLens company research. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}