Workflow: Manualtrigger Workflow
Integrations: code, googleSheets, htmlExtract, httpRequest, manualTrigger, merge, openAi, splitInBatches, wait

{"meta": {"instanceId": "workflow-2ee9cb34", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:58.257082", "updatedAt": "2025-09-29T07:07:58.257141", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "nodes": [{"id": "04750e9b-6ce3-401b-89e7-f1f17f3a4a28", "name": "When clicking \"Execute Workflow\"", "type": "n8n-nodes-base.manualTrigger", "position": [-180, 300], "parameters": {}, "typeVersion": 1, "notes": "This manualTrigger node performs automated tasks as part of the workflow."}, {"id": "7a8bb997-5a2d-4ee0-a1ca-bebe9fe32bc2", "name": "HTTP Request", "type": "n8n-nodes-base.httpRequest", "position": [640, 460], "parameters": {"url": "{{ $env.BASE_URL }}", "options": {"redirect": {"redirect": {"followRedirects": true}}}}, "typeVersion": 3, "continueOnFail": true, "notes": "This httpRequest node performs automated tasks as part of the workflow."}, {"id": "6409f0c4-bf93-4a1d-a74c-e294fb39895f", "name": "HTML Extract", "type": "n8n-nodes-base.htmlExtract", "position": [820, 460], "parameters": {"options": {"trimValues": false}, "extractionValues": {"values": [{"key": "YOUR_CREDENTIAL_HERE", "cssSelector": "html"}]}}, "typeVersion": 1, "continueOnFail": true, "notes": "This htmlExtract node performs automated tasks as part of the workflow."}, {"id": "f45fcc6a-9ccd-43c9-9eaf-1797768e1e62", "name": "OpenAI", "type": "n8n-nodes-base.openAi", "position": [1140, 460], "parameters": {"prompt": "=This is the content of the website {{ $node[\"Split In Batches\"].json[\"Domain\"] }}:\"{{ $json[\"contentShort\"] }}\"\n\nIn a JSON format:\n\n- Give me the value proposition of the company. In less than 25 words. In English. Casual Tone. Format is: \"[Company Name] helps [target audience] [achieve desired outcome] and [additional benefit]\"\n\n- Give me the industry of the company. (Classify using this industry list: [Agriculture, Arts, Construction, Consumer Goods, Education, Entertainment, Finance, Other, Health Care, Legal, Manufacturing, Media & Communications, Public Administration, Advertisements, Real Estate, Recreation & Travel, Retail, Software, Transportation & Logistics, Wellness & Fitness] if it's ambiguous between Sofware and Consumer Goods, prefer Consumer Goods)\n\n- Guess the target audience of each company.(Classify and choose 1 from this list: [sales teams, marketing teams, HR teams, customer Service teams, consumers, C-levels] Write it in lowercase)\n\n- Tell me if they are B2B or B2C\n\nformat should be:\n{\"value_proposition\": value_proposition,\n\"industry\": industry,\n\"target_audience\": target_audience, \n\"market\": market }\n\nJSON:", "options": {"topP": 1, "maxTokens": "YOUR_TOKEN_HERE", "temperature": 0}}, "credentials": {"openAiApi": {"id": "{{ $credentials.openAiApi.id }}", "name": "Lucas Open AI"}}, "typeVersion": 1, "continueOnFail": true, "notes": "This openAi node performs automated tasks as part of the workflow."}, {"id": "8de6c3d4-316f-4e00-a9f5-a4deefce90b3", "name": "Merge", "type": "n8n-nodes-base.merge", "position": [1600, 320], "parameters": {"mode": "combine", "options": {}, "combinationMode": "mergeByPosition"}, "typeVersion": 2, "notes": "This merge node performs automated tasks as part of the workflow."}, {"id": "669f888e-1416-4291-a854-07ffbbbfcab1", "name": "Clean Content", "type": "n8n-nodes-base.code", "position": [980, 460], "parameters": {"mode": "runOnceForEachItem", "jsCode": "if ($input.item.json.body){\n\n\n\n$input.item.json.content = $input.item.json.body.replaceAll('/^\\s+|\\s+$/g', '').replace('/(\\r\\n|\\n|\\r)/gm', \"\").replace(/\\s+/g, ' ')\n\n\n  $input.item.json.contentShort = $input.item.json.content.slice(0, 10000)\n}\n\n\n\n\nreturn $input.item"}, "executeOnce": false, "typeVersion": 1, "continueOnFail": true, "alwaysOutputData": true, "notes": "This code node performs automated tasks as part of the workflow."}, {"id": "dbd5f866-2f5e-4adf-b1b5-a27b08c0425a", "name": "Update Google Sheets", "type": "n8n-nodes-base.googleSheets", "position": [1840, 320], "parameters": {"options": {}, "fieldsUi": {"values": [{"column": "Market", "fieldValue": "={{ $json[\"market\"] }}"}, {"column": "Industry", "fieldValue": "={{ $json[\"industry\"] }}"}, {"column": "Value Proposition", "fieldValue": "={{ $json[\"value_proposition\"] }}"}, {"column": "Target Audience", "fieldValue": "={{ $json[\"target_audience\"] }}"}]}, "operation": "update", "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\\-_]+)(?:\\/.*|)"}, "valueToMatchOn": "={{ $json[\"Domain\"] }}", "columnToMatchOn": "Domain"}, "credentials": {"googleSheetsOAuth2Api": {"id": "{{ $credentials.googleSheetsOAuth2Api.id }}", "name": "Google Sheets account lucas"}}, "typeVersion": 3, "notes": "This googleSheets node performs automated tasks as part of the workflow."}, {"id": "f8bf8b70-6070-447b-af22-4d4e1ffe3539", "name": "Parse JSON", "type": "n8n-nodes-base.code", "position": [1300, 460], "parameters": {"mode": "runOnceForEachItem", "jsCode": "// Add a new field called 'myNewField' to the\n// JSON of the item\n$input.item.json.value_proposition=JSON.parse($input.item.json.text).value_proposition\n\n$input.item.json.industry=JSON.parse($input.item.json.text).industry\n\n$input.item.json.market=JSON.parse($input.item.json.text).market\n\n$input.item.json.target_audience=JSON.parse($input.item.json.text).target_audience\n\nreturn $input.item;"}, "typeVersion": 1, "notes": "This code node performs automated tasks as part of the workflow."}, {"id": "2754c6e1-9cf6-47d4-ad97-0797ec9155df", "name": "Read Google Sheets", "type": "n8n-nodes-base.googleSheets", "position": [40, 300], "parameters": {"options": {}, "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": 3, "notes": "This googleSheets node performs automated tasks as part of the workflow."}, {"id": "c2b93428-0dcc-4c02-bb81-496c12442284", "name": "Split In Batches", "type": "n8n-nodes-base.splitInBatches", "position": [260, 300], "parameters": {"options": {}}, "typeVersion": 1, "notes": "This splitInBatches node performs automated tasks as part of the workflow."}, {"id": "eccf1dc8-a0bb-40f6-9471-95eac8020b02", "name": "Wait", "type": "n8n-nodes-base.wait", "position": [2060, 560], "webhookId": "d44bc024-1c21-44e0-b2b4-5cff6fb9f402", "parameters": {"unit": "seconds"}, "typeVersion": 1, "notes": "This wait node performs automated tasks as part of the workflow."}], "connections": {"7a8bb997-5a2d-4ee0-a1ca-bebe9fe32bc2": {"main": [[{"node": "error-handler-7a8bb997-5a2d-4ee0-a1ca-bebe9fe32bc2", "type": "main", "index": 0}], [{"node": "error-handler-7a8bb997-5a2d-4ee0-a1ca-bebe9fe32bc2-5fb1cf4d", "type": "main", "index": 0}], [{"node": "error-handler-7a8bb997-5a2d-4ee0-a1ca-bebe9fe32bc2-effa009f", "type": "main", "index": 0}], [{"node": "error-handler-7a8bb997-5a2d-4ee0-a1ca-bebe9fe32bc2-70709f7a", "type": "main", "index": 0}], [{"node": "error-handler-7a8bb997-5a2d-4ee0-a1ca-bebe9fe32bc2-5fc917ae", "type": "main", "index": 0}], [{"node": "error-handler-7a8bb997-5a2d-4ee0-a1ca-bebe9fe32bc2-ff95fe81", "type": "main", "index": 0}], [{"node": "error-handler-7a8bb997-5a2d-4ee0-a1ca-bebe9fe32bc2-af6d23cf", "type": "main", "index": 0}], [{"node": "error-handler-7a8bb997-5a2d-4ee0-a1ca-bebe9fe32bc2-130b9bae", "type": "main", "index": 0}], [{"node": "error-handler-7a8bb997-5a2d-4ee0-a1ca-bebe9fe32bc2-7f06a0fe", "type": "main", "index": 0}]]}, "f45fcc6a-9ccd-43c9-9eaf-1797768e1e62": {"main": [[{"node": "error-handler-f45fcc6a-9ccd-43c9-9eaf-1797768e1e62-13ba9051", "type": "main", "index": 0}]]}, "dbd5f866-2f5e-4adf-b1b5-a27b08c0425a": {"main": [[{"node": "error-handler-dbd5f866-2f5e-4adf-b1b5-a27b08c0425a-fd0ffdd1", "type": "main", "index": 0}]]}, "2754c6e1-9cf6-47d4-ad97-0797ec9155df": {"main": [[{"node": "error-handler-2754c6e1-9cf6-47d4-ad97-0797ec9155df-7a7d5bf7", "type": "main", "index": 0}]]}}, "name": "Manualtrigger Workflow", "description": "Automated workflow: Manualtrigger Workflow. This workflow processes data and performs automated tasks.", "settings": {"executionOrder": "v1", "saveManualExecutions": true, "callerPolicy": "workflowsFromSameOwner", "errorWorkflow": null, "timezone": "UTC", "executionTimeout": 3600, "maxExecutions": 1000, "retryOnFail": true, "retryCount": 3, "retryDelay": 1000}, "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "notes": "Excellent quality workflow: Manualtrigger Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}