Workflow: Executeworkflowtrigger Workflow
Integrations: aggregate, executeWorkflowTrigger, filter, googleSheets, httpRequest, if, noOp, set, stickyNote, switch

{"meta": {"instanceId": "workflow-ff0d32c8", "versionId": "1.0.0", "createdAt": "2025-09-29T07:07:44.842661", "updatedAt": "2025-09-29T07:07:44.842670", "owner": "n8n-user", "license": "MIT", "category": "automation", "status": "active", "priority": "high", "environment": "production"}, "nodes": [{"id": "4bdd4360-b518-4b46-81fa-0d3183ce642d", "name": "When Executed by Another Workflow", "type": "n8n-nodes-base.executeWorkflowTrigger", "position": [680, 260], "parameters": {"workflowInputs": {"values": [{"name": "operation"}, {"name": "query"}, {"name": "employeeId"}, {"name": "values", "type": "object"}]}}, "typeVersion": 1.1, "notes": "This executeWorkflowTrigger node performs automated tasks as part of the workflow."}, {"id": "74bdcff0-0615-4d81-82ff-ff8340939399", "name": "Operation", "type": "n8n-nodes-base.switch", "position": [1040, 260], "parameters": {"rules": {"values": [{"outputKey": "YOUR_CREDENTIAL_HERE", "conditions": {"options": {"version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict"}, "combinator": "and", "conditions": [{"id": "81b134bc-d671-4493-b3ad-8df9be3f49a6", "operator": {"type": "string", "operation": "equals"}, "leftValue": "={{ $('When Executed by Another Workflow').first().json.operation }}", "rightValue": "searchEmployees"}]}, "renameOutput": true}, {"outputKey": "YOUR_CREDENTIAL_HERE", "conditions": {"options": {"version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict"}, "combinator": "and", "conditions": [{"id": "8d57914f-6587-4fb3-88e0-aa1de6ba56c1", "operator": {"name": "filter.operator.equals", "type": "string", "operation": "equals"}, "leftValue": "={{ $('When Executed by Another Workflow').first().json.operation }}", "rightValue": "getEmployeeById"}]}, "renameOutput": true}, {"outputKey": "YOUR_CREDENTIAL_HERE", "conditions": {"options": {"version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict"}, "combinator": "and", "conditions": [{"id": "7c38f238-213a-46ec-aefe-22e0bcb8dffc", "operator": {"name": "filter.operator.equals", "type": "string", "operation": "equals"}, "leftValue": "={{ $('When Executed by Another Workflow').first().json.operation }}", "rightValue": "updateEmployee"}]}, "renameOutput": true}]}, "options": {}}, "typeVersion": 3.2, "notes": "This switch node performs automated tasks as part of the workflow."}, {"id": "8850cd57-9bc1-43b7-9366-7d91afc7bc42", "name": "Sticky Note", "type": "n8n-nodes-base.stickyNote", "position": [-80, -120], "parameters": {"color": 7, "width": 680, "height": 660, "content": "## 1. Set up an MCP Server Trigger\n[Read more about the MCP Server Trigger]({{ $env.WEBHOOK_URL }}"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "ad541df3-44ed-4ef4-af91-841dc9986b4c", "name": "Sticky Note1", "type": "n8n-nodes-base.stickyNote", "position": [620, -120], "parameters": {"color": 7, "width": 600, "height": 260, "content": "## 2. Build Your MCP Server from Existing APIs\n[Read more about the HTTP Request Node]({{ $env.WEBHOOK_URL }}\n\nN8N allows any organisation to quickly build and host their own MCP server by leveraging existing APIs. Here's a quick example for PayCaptain.com - a cloud-based payroll software for modern companies.\n\nWith this set of tools, Paycaptain customers can simplify employee management from within their favourite MCP client such as Claude Desktop. Better yet, n8n also handles distribution so this MCP server can serve entire departments as well."}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "962cb379-8916-4a9f-8a7b-5aa9d31d5d88", "name": "Sticky Note3", "type": "n8n-nodes-base.stickyNote", "position": [-80, -240], "parameters": {"color": 5, "width": 380, "height": 100, "content": "### Always Authenticate Your Server!\nBefore going to production, it's always advised to enable authentication on your MCP server trigger."}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "27163110-36d7-46f3-92fc-dce7d000655e", "name": "Paycaptain MCP Server", "type": "n8n-nodes-base.noOp", "position": [80, 40], "webhookId": "5f6728df-d3e8-48bb-9a38-0f2e54c7962c", "parameters": {"path": "5f6728df-d3e8-48bb-9a38-0f2e54c7962c"}, "typeVersion": 1, "notes": "This mcpTrigger node performs automated tasks as part of the workflow."}, {"id": "13a69580-de33-489a-85c8-582877efbfe0", "name": "Update Employee", "type": "n8n-nodes-base.noOp", "position": [380, 260], "parameters": {"name": "updateEmployee", "workflowId": {"__rl": true, "mode": "id", "value": "={{ $workflow.id }}"}, "description": "Updates an employee's details.", "workflowInputs": {"value": {"query": "null", "values": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('values', ``, 'string') }}", "operation": "updateEmployee", "employeeId": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('employeeId', ``, 'string') }}"}, "schema": [{"id": "operation", "type": "string", "display": true, "required": false, "displayName": "operation", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "query", "type": "string", "display": true, "removed": false, "required": false, "displayName": "query", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "employeeId", "type": "string", "display": true, "removed": false, "required": false, "displayName": "employeeId", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "values", "type": "object", "display": true, "required": false, "displayName": "values", "defaultMatch": false, "canBeUsedToMatch": true}], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false}}, "typeVersion": 2.1, "notes": "This toolWorkflow node performs automated tasks as part of the workflow."}, {"id": "68c066f0-657c-46cb-a9fe-b31e9850c512", "name": "Get Employee", "type": "n8n-nodes-base.noOp", "position": [240, 360], "parameters": {"name": "getEmployeeById", "workflowId": {"__rl": true, "mode": "id", "value": "={{ $workflow.id }}"}, "description": "Returns an employee's details by employee ID.", "workflowInputs": {"value": {"query": "null", "values": "null", "operation": "getEmployeeById", "employeeId": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('employeeId', ``, 'string') }}"}, "schema": [{"id": "operation", "type": "string", "display": true, "removed": false, "required": false, "displayName": "operation", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "query", "type": "string", "display": true, "removed": false, "required": false, "displayName": "query", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "employeeId", "type": "string", "display": true, "removed": false, "required": false, "displayName": "employeeId", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "values", "type": "object", "display": true, "removed": false, "required": false, "displayName": "values", "defaultMatch": false, "canBeUsedToMatch": true}], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false}}, "typeVersion": 2.1, "notes": "This toolWorkflow node performs automated tasks as part of the workflow."}, {"id": "87661e95-b618-4701-b0f3-9f0532d5fc75", "name": "Get Employees", "type": "n8n-nodes-base.httpRequest", "position": [1380, 60], "parameters": {"url": "{{ $env.API_BASE_URL }}", "options": {"pagination": {"pagination": {"parameters": {"parameters": [{"name": "page", "value": "={{ $request.qs.page + 1 }}"}]}, "maxRequests": 3, "requestInterval": 1000, "limitPagesFetched": true}}}, "sendQuery": true, "authentication": "{{ $credentials.genericCredentialType }}", "genericAuthType": "httpHeaderAuth", "queryParameters": {"parameters": [{"name": "company", "value": "paycaptain"}, {"name": "page", "value": "={{ $json.page ?? 1 }}"}]}}, "credentials": {"httpHeaderAuth": {"id": "sPolCkoJ1zhzWabJ", "name": "JWT TOKEN"}}, "typeVersion": 4.2, "notes": "This httpRequest node performs automated tasks as part of the workflow."}, {"id": "866868e2-e0b0-4d8d-bf3c-57d68fea8b86", "name": "Search Employees", "type": "n8n-nodes-base.noOp", "position": [100, 260], "parameters": {"name": "searchEmployees", "workflowId": {"__rl": true, "mode": "id", "value": "={{ $workflow.id }}"}, "description": "Searches for and returns an employee's details.", "workflowInputs": {"value": {"query": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('query', ``, 'string') }}", "values": "null", "operation": "searchEmployees", "employeeId": "null"}, "schema": [{"id": "operation", "type": "string", "display": true, "removed": false, "required": false, "displayName": "operation", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "query", "type": "string", "display": true, "removed": false, "required": false, "displayName": "query", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "employeeId", "type": "string", "display": true, "removed": false, "required": false, "displayName": "employeeId", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "values", "type": "object", "display": true, "removed": false, "required": false, "displayName": "values", "defaultMatch": false, "canBeUsedToMatch": true}], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false}}, "typeVersion": 2.1, "notes": "This toolWorkflow node performs automated tasks as part of the workflow."}, {"id": "679a2413-448f-43d8-98fc-7fd8b83775e7", "name": "Log Call", "type": "n8n-nodes-base.googleSheets", "position": [860, 260], "parameters": {"columns": {"value": {"query": "={{ $json.query }}", "values": "={{ $json.values.toJsonString() }}", "operation": "={{ $json.operation }}", "timestamp": "={{ $now.toISO() }}", "employeeId": "={{ $json.employeeId }}"}, "schema": [{"id": "timestamp", "type": "string", "display": true, "removed": false, "required": false, "displayName": "timestamp", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "operation", "type": "string", "display": true, "removed": false, "required": false, "displayName": "operation", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "query", "type": "string", "display": true, "removed": false, "required": false, "displayName": "query", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "employeeId", "type": "string", "display": true, "removed": false, "required": false, "displayName": "employeeId", "defaultMatch": false, "canBeUsedToMatch": true}, {"id": "values", "type": "string", "display": true, "removed": false, "required": false, "displayName": "values", "defaultMatch": false, "canBeUsedToMatch": true}], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false}, "options": {"useAppend": true}, "operation": "append", "sheetName": {"__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "Sheet1"}, "documentId": {"__rl": true, "mode": "list", "value": "1Ls_3pmzIafl1NUAzzflkJgyq1smPW6vfGjbVuVzdkac", "cachedResultUrl": "{{ $env.WEBHOOK_URL }}", "cachedResultName": "98. MCP Audit"}}, "credentials": {"googleSheetsOAuth2Api": {"id": "XHvC7jIRR8A2TlUl", "name": "Google Sheets account"}}, "typeVersion": 4.5, "notes": "This googleSheets node performs automated tasks as part of the workflow."}, {"id": "7723947c-94a3-4bf1-b6c8-b595027a33dc", "name": "Filter Matches", "type": "n8n-nodes-base.filter", "position": [1580, 60], "parameters": {"options": {}, "conditions": {"options": {"version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict"}, "combinator": "and", "conditions": [{"id": "baa681eb-d6d9-450b-99ab-58d33e81cef4", "operator": {"name": "filter.operator.equals", "type": "string", "operation": "equals"}, "leftValue": "={{\n[\n  $json.hrEmployeeId,\n  $json.payrollCode,\n  $json.firstName + ' ' + $json.lastName,\n  $json.email,\n  $json.niNumber,\n  $json.mailingCity,\n  $json.jobTitle,\n  $json.jobGrade,\n  $json.department,\n  $json.team\n]\n  .join(' ')\n  .toLowerCase()\n}}", "rightValue": "={{ $('When Executed by Another Workflow').first().json.query.toLowerCase() }}"}]}}, "typeVersion": 2.2, "notes": "This filter node performs automated tasks as part of the workflow."}, {"id": "f4d1ddd9-dde7-437f-9aa2-969ea0832f71", "name": "Aggregate Search Results", "type": "n8n-nodes-base.aggregate", "position": [2020, 60], "parameters": {"options": {}, "aggregate": "aggregateAllItemData", "destinationFieldName": "response"}, "typeVersion": 1, "notes": "This aggregate node performs automated tasks as part of the workflow."}, {"id": "45076cec-f554-44ae-b314-e43ba080abb5", "name": "Get Employees1", "type": "n8n-nodes-base.httpRequest", "position": [1380, 260], "parameters": {"url": "{{ $env.API_BASE_URL }}", "options": {"pagination": {"pagination": {"parameters": {"parameters": [{"name": "page", "value": "={{ $request.qs.page + 1 }}"}]}, "maxRequests": 3, "requestInterval": 1000, "limitPagesFetched": true}}}, "sendQuery": true, "authentication": "{{ $credentials.genericCredentialType }}", "genericAuthType": "httpHeaderAuth", "queryParameters": {"parameters": [{"name": "company", "value": "paycaptain"}, {"name": "page", "value": "={{ $json.page ?? 1 }}"}]}}, "credentials": {"httpHeaderAuth": {"id": "sPolCkoJ1zhzWabJ", "name": "JWT TOKEN"}}, "typeVersion": 4.2, "notes": "This httpRequest node performs automated tasks as part of the workflow."}, {"id": "b6f3a56f-5cd2-4f4d-904b-49e82ec591b8", "name": "Filter Matching ID", "type": "n8n-nodes-base.filter", "position": [1580, 260], "parameters": {"options": {}, "conditions": {"options": {"version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict"}, "combinator": "and", "conditions": [{"id": "cfb2ba5b-14c0-4867-be4d-180306c896ae", "operator": {"name": "filter.operator.equals", "type": "string", "operation": "equals"}, "leftValue": "={{ $json.hrEmployeeId }}", "rightValue": "={{ $('When Executed by Another Workflow').first().json.employeeId }}"}]}}, "typeVersion": 2.2, "notes": "This filter node performs automated tasks as part of the workflow."}, {"id": "ecc2d8d5-4a23-4bfd-840b-63c28980462f", "name": "Strip Sensitive Fields1", "type": "n8n-nodes-base.set", "position": [1800, 260], "parameters": {"options": {}, "assignments": {"assignments": [{"id": "e20217cf-7c70-4907-9da6-a114104a099e", "name": "company", "type": "string", "value": "={{ $json.company }}"}, {"id": "2dfe8342-c442-4ac3-90bd-92fe7d38d407", "name": "hrEmployeeId", "type": "string", "value": "={{ $json.hrEmployeeId }}"}, {"id": "57fe4519-246b-44aa-a0c9-22e1e865041c", "name": "payrollCode", "type": "string", "value": "={{ $json.payrollCode }}"}, {"id": "d296021c-09b2-43b2-8b8e-ebb5d7d9d14d", "name": "firstName", "type": "string", "value": "={{ $json.firstName }}"}, {"id": "661e0049-d28f-4f78-83fc-7a1b21f742c2", "name": "lastName", "type": "string", "value": "={{ $json.lastName }}"}, {"id": "59f7fd87-ba84-426a-ad61-c682cf8227bf", "name": "email", "type": "string", "value": "={{ $json.email }}"}, {"id": "9769c078-c5f5-4d56-b467-765dd73444f9", "name": "phone", "type": "string", "value": "={{ $json.phone }}"}, {"id": "e387bc11-dccf-4baf-b87f-a2abb5f61b5d", "name": "mailingStreet", "type": "string", "value": "={{ $json.mailingStreet }}"}, {"id": "415451c5-c3c1-42d4-9f5b-829277bfb7f3", "name": "mailingStateProvince", "type": "string", "value": "={{ $json.mailingStateProvince }}"}, {"id": "cf2a83f4-28a8-44bd-9d06-780db1406f8f", "name": "mailingPostalCode", "type": "string", "value": "={{ $json.mailingPostalCode }}"}, {"id": "94ee2e05-9969-43f2-a732-57356f8b4dfe", "name": "mailingCountry", "type": "string", "value": "={{ $json.mailingCountry }}"}, {"id": "b01a56c9-fc42-4bff-9443-27075699986f", "name": "location", "type": "string", "value": "={{ $json.location }}"}, {"id": "b9175d72-6976-4765-b773-f4521668d130", "name": "department", "type": "string", "value": "={{ $json.department }}"}, {"id": "d784e800-e13b-4d43-907c-11aaaf4ee24f", "name": "team", "type": "string", "value": "={{ $json.team }}"}, {"id": "1ff68eb6-35f9-4a2d-9a37-14b3a6f6e0ee", "name": "jobGrade", "type": "string", "value": "={{ $json.jobGrade }}"}, {"id": "5628bbf8-872d-4e3a-bf37-c36f13c0f4b1", "name": "jobTitle", "type": "string", "value": "={{ $json.jobTitle }}"}, {"id": "34f26d59-43b3-4f2c-955b-f6d5ab22a083", "name": "jobEffectiveDate", "type": "string", "value": "={{ $json.jobEffectiveDate }}"}, {"id": "e3023e94-fbc8-4e9b-b106-687ea533e3f8", "name": "contractType", "type": "string", "value": "={{ $json.contractType }}"}, {"id": "d3dcf24c-5e9b-40e5-9f54-fca930ab1528", "name": "normalWeeklyHours", "type": "number", "value": "={{ $json.normalWeeklyHours }}"}, {"id": "65ed75a6-1ec1-456f-b19b-4492e31f5c18", "name": "daysWorkedPerWeek", "type": "number", "value": "={{ $json.daysWorkedPerWeek }}"}]}}, "typeVersion": 3.4, "notes": "This set node performs automated tasks as part of the workflow."}, {"id": "77a71a55-f0cf-4f76-b697-b31dba447f30", "name": "Strip Sensitive Fields", "type": "n8n-nodes-base.set", "position": [1800, 60], "parameters": {"options": {}, "assignments": {"assignments": [{"id": "e20217cf-7c70-4907-9da6-a114104a099e", "name": "company", "type": "string", "value": "={{ $json.company }}"}, {"id": "2dfe8342-c442-4ac3-90bd-92fe7d38d407", "name": "hrEmployeeId", "type": "string", "value": "={{ $json.hrEmployeeId }}"}, {"id": "57fe4519-246b-44aa-a0c9-22e1e865041c", "name": "payrollCode", "type": "string", "value": "={{ $json.payrollCode }}"}, {"id": "d296021c-09b2-43b2-8b8e-ebb5d7d9d14d", "name": "firstName", "type": "string", "value": "={{ $json.firstName }}"}, {"id": "661e0049-d28f-4f78-83fc-7a1b21f742c2", "name": "lastName", "type": "string", "value": "={{ $json.lastName }}"}, {"id": "59f7fd87-ba84-426a-ad61-c682cf8227bf", "name": "email", "type": "string", "value": "={{ $json.email }}"}, {"id": "9769c078-c5f5-4d56-b467-765dd73444f9", "name": "phone", "type": "string", "value": "={{ $json.phone }}"}, {"id": "e387bc11-dccf-4baf-b87f-a2abb5f61b5d", "name": "mailingStreet", "type": "string", "value": "={{ $json.mailingStreet }}"}, {"id": "415451c5-c3c1-42d4-9f5b-829277bfb7f3", "name": "mailingStateProvince", "type": "string", "value": "={{ $json.mailingStateProvince }}"}, {"id": "cf2a83f4-28a8-44bd-9d06-780db1406f8f", "name": "mailingPostalCode", "type": "string", "value": "={{ $json.mailingPostalCode }}"}, {"id": "94ee2e05-9969-43f2-a732-57356f8b4dfe", "name": "mailingCountry", "type": "string", "value": "={{ $json.mailingCountry }}"}, {"id": "b01a56c9-fc42-4bff-9443-27075699986f", "name": "location", "type": "string", "value": "={{ $json.location }}"}, {"id": "b9175d72-6976-4765-b773-f4521668d130", "name": "department", "type": "string", "value": "={{ $json.department }}"}, {"id": "d784e800-e13b-4d43-907c-11aaaf4ee24f", "name": "team", "type": "string", "value": "={{ $json.team }}"}, {"id": "1ff68eb6-35f9-4a2d-9a37-14b3a6f6e0ee", "name": "jobGrade", "type": "string", "value": "={{ $json.jobGrade }}"}, {"id": "5628bbf8-872d-4e3a-bf37-c36f13c0f4b1", "name": "jobTitle", "type": "string", "value": "={{ $json.jobTitle }}"}, {"id": "34f26d59-43b3-4f2c-955b-f6d5ab22a083", "name": "jobEffectiveDate", "type": "string", "value": "={{ $json.jobEffectiveDate }}"}, {"id": "e3023e94-fbc8-4e9b-b106-687ea533e3f8", "name": "contractType", "type": "string", "value": "={{ $json.contractType }}"}, {"id": "d3dcf24c-5e9b-40e5-9f54-fca930ab1528", "name": "normalWeeklyHours", "type": "number", "value": "={{ $json.normalWeeklyHours }}"}, {"id": "65ed75a6-1ec1-456f-b19b-4492e31f5c18", "name": "daysWorkedPerWeek", "type": "number", "value": "={{ $json.daysWorkedPerWeek }}"}]}}, "typeVersion": 3.4, "notes": "This set node performs automated tasks as part of the workflow."}, {"id": "86f73b12-afc8-4694-a79d-45c908cc88dd", "name": "Update Employee1", "type": "n8n-nodes-base.httpRequest", "position": [1800, 460], "parameters": {"url": "{{ $env.API_BASE_URL }}", "method": "POST", "options": {"pagination": {"pagination": {"parameters": {"parameters": [{"name": "page", "value": "={{ $request.qs.page + 1 }}"}]}, "maxRequests": 3, "requestInterval": 1000, "limitPagesFetched": true}}}, "jsonBody": "={{\n{\n  hrEmployeeId: $('When Executed by Another Workflow').item.json.employeeId,\n  ..\n}\n}}", "sendBody": true, "specifyBody": "json", "authentication": "{{ $credentials.genericCredentialType }}", "genericAuthType": "httpHeaderAuth"}, "credentials": {"httpHeaderAuth": {"id": "sPolCkoJ1zhzWabJ", "name": "JWT TOKEN"}}, "typeVersion": 4.2, "notes": "This httpRequest node performs automated tasks as part of the workflow."}, {"id": "122fe6f7-3bcd-4f29-a95c-c727a799e1fd", "name": "Valid Fields Only", "type": "n8n-nodes-base.set", "position": [1380, 460], "parameters": {"options": {}, "assignments": {"assignments": [{"id": "4f3d0703-21f3-4ca1-bf7a-9c80d9efc936", "name": "values", "type": "object", "value": "={{\n([\n  \"firstname\",\n  \"middlename\",\n  \"lastname\",\n  \"mailingStreet\",\n  \"mailingCity\",\n  \"mailingStateProvince\",\n  \"mailingPostalCode\",\n  \"mailingCountry\",\n  \"email\",\n  \"phone\",\n  \"niNumber\",\n  \"location\",\n  \"department\",\n  \"team\",\n  \"jobGrade\",\n  \"jobTitle\",\n]\n  .reduce((acc, key) => ({\n    ...acc,\n    [key]: $('When Executed by Another Workflow').item.json.values[key] ?? undefined\n  }), {}))\n}}"}]}}, "typeVersion": 3.4, "notes": "This set node performs automated tasks as part of the workflow."}, {"id": "13e5f143-1abf-444c-b86c-ae51fe839894", "name": "Has Valid Request?", "type": "n8n-nodes-base.if", "position": [1580, 460], "parameters": {"options": {}, "conditions": {"options": {"version": 2, "leftValue": "", "caseSensitive": true, "typeValidation": "strict"}, "combinator": "and", "conditions": [{"id": "54d35a49-e698-427d-9fca-280b83f2827d", "operator": {"type": "object", "operation": "notEmpty", "singleValue": true}, "leftValue": "={{ $json.values }}", "rightValue": ""}]}}, "typeVersion": 2.2, "notes": "This if node performs automated tasks as part of the workflow."}, {"id": "b98f1d73-a994-4040-b421-75e626ec4ce6", "name": "Get Error Response", "type": "n8n-nodes-base.set", "position": [1800, 640], "parameters": {"options": {}, "assignments": {"assignments": [{"id": "b33ebf1d-d0e8-4dda-90e7-b53c21b2a410", "name": "response", "type": "string", "value": "=Request included fields which cannot be updated. Editable fields are: {{ [\n  \"firstname\",\n  \"middlename\",\n  \"lastname\",\n  \"mailingStreet\",\n  \"mailingCity\",\n  \"mailingStateProvince\",\n  \"mailingPostalCode\",\n  \"mailingCountry\",\n  \"email\",\n  \"phone\",\n  \"niNumber\",\n  \"location\",\n  \"department\",\n  \"team\",\n  \"jobGrade\",\n  \"jobTitle\",\n].join(', ')}}"}]}}, "typeVersion": 3.4, "notes": "This set node performs automated tasks as part of the workflow."}, {"id": "cb140f3f-571c-49a4-a24d-dcee11c5b7e1", "name": "Get Success Response", "type": "n8n-nodes-base.set", "position": [2020, 460], "parameters": {"options": {}, "assignments": {"assignments": [{"id": "a1d245c9-b1e5-4cec-a901-4a6ecc9bd98d", "name": "response", "type": "string", "value": "ok"}]}}, "typeVersion": 3.4, "notes": "This set node performs automated tasks as part of the workflow."}, {"id": "39cd1188-5f2e-45ce-8bbc-0586812491ec", "name": "Aggregate Get Response", "type": "n8n-nodes-base.aggregate", "position": [2020, 260], "parameters": {"options": {}, "aggregate": "aggregateAllItemData", "destinationFieldName": "response"}, "typeVersion": 1, "notes": "This aggregate node performs automated tasks as part of the workflow."}, {"id": "d9c1ed21-29e4-41a6-9855-36f1568f7944", "name": "Sticky Note2", "type": "n8n-nodes-base.stickyNote", "position": [620, -360], "parameters": {"color": 7, "width": 400, "height": 220, "content": "![]({{ $env.WEBHOOK_URL }}\n**Website**: {{ $env.WEBHOOK_URL }}\n**DeveloperHub**: {{ $env.WEBHOOK_URL }}\n\n**Good to know:** PayCaptain also sponsors the n8n London Meetups - Definitely check them out!"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}, {"id": "efc7ab35-202d-4a1f-98ce-7ae310c22250", "name": "Sticky Note4", "type": "n8n-nodes-base.stickyNote", "position": [-540, -640], "parameters": {"width": 440, "height": 1180, "content": "## Try It Out!\n### This n8n demonstrates how any organisation can quickly and easily build and offer MCP servers to their customers or internal staff to improve productivity.\n\nThis MCP example uses PayCaptain.com as an example and shows how to create an MCP server which can search for and update employee data.\n\n### How it works\n* A MCP server trigger is used and connected to 3 custom workflow tools: Search Employee, Get Employee by ID and Update Employee.\n* Each tool makes calls to the PayCaptain API to perform their respective tasks. Extra care  is performed to strip out sensitive data and ensure we're not sharing too much.\n* The Update Employee too also guards against updating fields which would preferably remain readonly. When you control the MCP server, you can determine behaviour of the tool.\n* Finally, a Google Sheet node is used to log all operations for later audit. This will add a tiny bit of latency but recommended if sensitive data is being accessed.\n\n### How to use\n* This MCP server allows any compatible MCP client to manage their PayCaptain employee database. You will need to have a PayCaptain account and developer key to use it.\n* Connect your MCP client by following the n8n guidelines here - {{ $env.WEBHOOK_URL }}\n* Try the following queries in your MCP client:\n  * \"When did Sarah start here employment at the company?\"\n  * \"Does Jack work Wednesdays or Fridays?\"\n  * \"Please update Tracy's NI number to ABCD123456\"\n\n### Requirements\n* PayCaptain Account and Developer Key.\n* Google Sheets to log actions for later audit.\n* MCP Client or Agent for usage such as Claude Desktop - {{ $env.WEBHOOK_URL }}\n\n### Customising this workflow\n* Add or remove employee attributes as required for your user case.\n* If Google Sheets is too slow, consider an API call to a faster service to log calls to the MCP server.\n* Remember to set the MCP server to require credentials before going to production and sharing this MCP server with others!"}, "typeVersion": 1, "notes": "This stickyNote node performs automated tasks as part of the workflow."}], "pinData": {}, "connections": {"87661e95-b618-4701-b0f3-9f0532d5fc75": {"main": [[{"node": "error-handler-87661e95-b618-4701-b0f3-9f0532d5fc75", "type": "main", "index": 0}], [{"node": "error-handler-87661e95-b618-4701-b0f3-9f0532d5fc75-ca685d4b", "type": "main", "index": 0}], [{"node": "error-handler-87661e95-b618-4701-b0f3-9f0532d5fc75-89d14bba", "type": "main", "index": 0}], [{"node": "error-handler-87661e95-b618-4701-b0f3-9f0532d5fc75-0ac95ee3", "type": "main", "index": 0}], [{"node": "error-handler-87661e95-b618-4701-b0f3-9f0532d5fc75-9cbde46d", "type": "main", "index": 0}], [{"node": "error-handler-87661e95-b618-4701-b0f3-9f0532d5fc75-80d22115", "type": "main", "index": 0}], [{"node": "error-handler-87661e95-b618-4701-b0f3-9f0532d5fc75-d8b6359a", "type": "main", "index": 0}], [{"node": "error-handler-87661e95-b618-4701-b0f3-9f0532d5fc75-9bb341ac", "type": "main", "index": 0}], [{"node": "error-handler-87661e95-b618-4701-b0f3-9f0532d5fc75-75d4ab7a", "type": "main", "index": 0}]]}, "45076cec-f554-44ae-b314-e43ba080abb5": {"main": [[{"node": "error-handler-45076cec-f554-44ae-b314-e43ba080abb5", "type": "main", "index": 0}], [{"node": "error-handler-45076cec-f554-44ae-b314-e43ba080abb5-f1f27cfb", "type": "main", "index": 0}], [{"node": "error-handler-45076cec-f554-44ae-b314-e43ba080abb5-fc9fa1d7", "type": "main", "index": 0}], [{"node": "error-handler-45076cec-f554-44ae-b314-e43ba080abb5-d2c26420", "type": "main", "index": 0}], [{"node": "error-handler-45076cec-f554-44ae-b314-e43ba080abb5-4abb86a7", "type": "main", "index": 0}], [{"node": "error-handler-45076cec-f554-44ae-b314-e43ba080abb5-fd9e9fc7", "type": "main", "index": 0}], [{"node": "error-handler-45076cec-f554-44ae-b314-e43ba080abb5-0183beee", "type": "main", "index": 0}], [{"node": "error-handler-45076cec-f554-44ae-b314-e43ba080abb5-cbb1e747", "type": "main", "index": 0}], [{"node": "error-handler-45076cec-f554-44ae-b314-e43ba080abb5-a2c00ac0", "type": "main", "index": 0}]]}, "86f73b12-afc8-4694-a79d-45c908cc88dd": {"main": [[{"node": "error-handler-86f73b12-afc8-4694-a79d-45c908cc88dd", "type": "main", "index": 0}], [{"node": "error-handler-86f73b12-afc8-4694-a79d-45c908cc88dd-b09c7528", "type": "main", "index": 0}], [{"node": "error-handler-86f73b12-afc8-4694-a79d-45c908cc88dd-f987bf2c", "type": "main", "index": 0}], [{"node": "error-handler-86f73b12-afc8-4694-a79d-45c908cc88dd-c557113c", "type": "main", "index": 0}], [{"node": "error-handler-86f73b12-afc8-4694-a79d-45c908cc88dd-fc56fdea", "type": "main", "index": 0}], [{"node": "error-handler-86f73b12-afc8-4694-a79d-45c908cc88dd-da87788a", "type": "main", "index": 0}], [{"node": "error-handler-86f73b12-afc8-4694-a79d-45c908cc88dd-8a1f1eaa", "type": "main", "index": 0}], [{"node": "error-handler-86f73b12-afc8-4694-a79d-45c908cc88dd-e6663273", "type": "main", "index": 0}], [{"node": "error-handler-86f73b12-afc8-4694-a79d-45c908cc88dd-577ada8f", "type": "main", "index": 0}]]}, "679a2413-448f-43d8-98fc-7fd8b83775e7": {"main": [[{"node": "error-handler-679a2413-448f-43d8-98fc-7fd8b83775e7-3e4ccd02", "type": "main", "index": 0}]]}}, "name": "Executeworkflowtrigger 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: Executeworkflowtrigger Workflow. This workflow integrates 12 different services: stickyNote, httpRequest, filter, switch, set. It contains 32 nodes and follows best practices for error handling and security.", "tags": ["automation", "n8n", "production-ready", "excellent", "optimized"], "notes": "Excellent quality workflow: Executeworkflowtrigger Workflow. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}