planeta ai logo
Darmowy szablon automatyzacji

Zbuduj własny serwer CUSTOM API MCP

126
24 dni temu
25
bloków

Opis automatyzacji MCP Server w n8n

Jak to działa

Ten szablon n8n pokazuje, jak szybko zbudować i udostępnić serwer MCP dla klientów lub pracowników w celu zwiększenia produktywności. Przykład wykorzystuje PayCaptain.com do tworzenia serwera MCP, który może wyszukiwać i aktualizować dane pracowników.

W workflow zastosowano trigger MCP Server połączony z 3 niestandardowymi narzędziami:

  • Search Employee
  • Get Employee by ID
  • Update Employee

Każde narzędzie wykonuje zapytania do API PayCaptain, przy czym szczególną uwagę zwrócono na usuwanie wrażliwych danych i ograniczenie udostępnianych informacji. Narzędzie Update Employee dodatkowo zabezpiecza przed modyfikacją pól, które powinny pozostać tylko do odczytu. Całość działań jest logowana w arkuszu Google Sheets w celach audytowych.

Jak używać

Serwer MCP umożliwia kompatybilnym klientom MCP zarządzanie bazą danych pracowników PayCaptain. Wymagane jest konto PayCaptain z kluczem deweloperskim.

Przykładowe zapytania dla klienta MCP:

  • "When did Sarah start here employment at the company?"
  • "Does Jack work Wednesdays or Fridays?"
  • "Please update Tracy's NI number to ABCD123456"

Wymagania

  • Konto PayCaptain z kluczem deweloperskim
  • Google Sheets do logowania działań
  • Klient MCP np. Claude Desktop

Dostosowywanie workflow

  • Modyfikuj atrybuty pracowników zgodnie z potrzebami
  • Zastąp Google Sheets szybszym rozwiązaniem do logowania jeśli wymagana jest większa wydajność
  • Pamiętaj o włączeniu wymagania uwierzytelnienia przed udostępnieniem serwera MCP w środowisku produkcyjnym

Przykłady zastosowań

Ten szablon automatyzacji znajdzie zastosowanie w wielu scenariuszach związanych z zarządzaniem danymi pracowników:

  • Szybkie wyszukiwanie informacji o pracownikach przez dział HR
  • Aktualizacja danych pracowniczych bez konieczności logowania się do systemu PayCaptain
  • Automatyzacja onboardingu nowych pracowników
  • Integracja z czatbotami wspierającymi pracowników
  • Generowanie raportów o zatrudnieniu na żądanie
  • Weryfikacja dostępności pracowników w określonych dniach
  • Automatyczne uzupełnianie systemów kadrowo-płacowych
   Skopiuj kod szablonu   
{"meta":{"instanceId":"408f9fb9940c3cb18ffdef0e0150fe342d6e655c3a9fac21f0f644e8bedabcd9","templateCredsSetupCompleted":true},"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},{"id":"74bdcff0-0615-4d81-82ff-ff8340939399","name":"Operation","type":"n8n-nodes-base.switch","position":[1040,260],"parameters":{"rules":{"values":[{"outputKey":"searchEmployee","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":"getEmployeeById","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":"updateEmployee","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},{"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 Triggern[Read more about the MCP Server Trigger](https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-langchain.mcptrigger)"},"typeVersion":1},{"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 APIsn[Read more about the HTTP Request Node](https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.httprequest)nnN8N 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.nnWith 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},{"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},{"id":"27163110-36d7-46f3-92fc-dce7d000655e","name":"Paycaptain MCP Server","type":"@n8n/n8n-nodes-langchain.mcpTrigger","position":[80,40],"webhookId":"5f6728df-d3e8-48bb-9a38-0f2e54c7962c","parameters":{"path":"5f6728df-d3e8-48bb-9a38-0f2e54c7962c"},"typeVersion":1},{"id":"13a69580-de33-489a-85c8-582877efbfe0","name":"Update Employee","type":"@n8n/n8n-nodes-langchain.toolWorkflow","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},{"id":"68c066f0-657c-46cb-a9fe-b31e9850c512","name":"Get Employee","type":"@n8n/n8n-nodes-langchain.toolWorkflow","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},{"id":"87661e95-b618-4701-b0f3-9f0532d5fc75","name":"Get Employees","type":"n8n-nodes-base.httpRequest","position":[1380,60],"parameters":{"url":"https://api.paycaptain.com/employees","options":{"pagination":{"pagination":{"parameters":{"parameters":[{"name":"page","value":"={{ $request.qs.page + 1 }}"}]},"maxRequests":3,"requestInterval":1000,"limitPagesFetched":true}}},"sendQuery":true,"authentication":"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},{"id":"866868e2-e0b0-4d8d-bf3c-57d68fea8b86","name":"Search Employees","type":"@n8n/n8n-nodes-langchain.toolWorkflow","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},{"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":"https://docs.google.com/spreadsheets/d/1Ls_3pmzIafl1NUAzzflkJgyq1smPW6vfGjbVuVzdkac/edit#gid=0","cachedResultName":"Sheet1"},"documentId":{"__rl":true,"mode":"list","value":"1Ls_3pmzIafl1NUAzzflkJgyq1smPW6vfGjbVuVzdkac","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1Ls_3pmzIafl1NUAzzflkJgyq1smPW6vfGjbVuVzdkac/edit?usp=drivesdk","cachedResultName":"98. MCP Audit"}},"credentials":{"googleSheetsOAuth2Api":{"id":"XHvC7jIRR8A2TlUl","name":"Google Sheets account"}},"typeVersion":4.5},{"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.teamn]n .join(' ')n .toLowerCase()n}}","rightValue":"={{ $('When Executed by Another Workflow').first().json.query.toLowerCase() }}"}]}},"typeVersion":2.2},{"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},{"id":"45076cec-f554-44ae-b314-e43ba080abb5","name":"Get Employees1","type":"n8n-nodes-base.httpRequest","position":[1380,260],"parameters":{"url":"https://api.paycaptain.com/employees","options":{"pagination":{"pagination":{"parameters":{"parameters":[{"name":"page","value":"={{ $request.qs.page + 1 }}"}]},"maxRequests":3,"requestInterval":1000,"limitPagesFetched":true}}},"sendQuery":true,"authentication":"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},{"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},{"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},{"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},{"id":"86f73b12-afc8-4694-a79d-45c908cc88dd","name":"Update Employee1","type":"n8n-nodes-base.httpRequest","position":[1800,460],"parameters":{"url":"https://api.paycaptain.com/employee","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":"genericCredentialType","genericAuthType":"httpHeaderAuth"},"credentials":{"httpHeaderAuth":{"id":"sPolCkoJ1zhzWabJ","name":"JWT TOKEN"}},"typeVersion":4.2},{"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] ?? undefinedn }), {}))n}}"}]}},"typeVersion":3.4},{"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},{"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},{"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},{"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},{"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":"![](https://cdn.prod.website-files.com/6628137b611845ebff95551f/6628137b611845ebff9556e7_paycaptain-logo.svg#full-width)n**Website**: https://paycaptain.comn**DeveloperHub**: https://developer.paycaptain.comnn**Good to know:** PayCaptain also sponsors the n8n London Meetups - Definitely check them out!"},"typeVersion":1},{"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.nnThis MCP example uses PayCaptain.com as an example and shows how to create an MCP server which can search for and update employee data.nn### How it worksn* 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.nn### How to usen* 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 - https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-langchain.mcptrigger/#integrating-with-claude-desktopn* 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"nn### Requirementsn* 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 - https://claude.ai/downloadnn### Customising this workflown* 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}],"pinData":{},"connections":{"Log Call":{"main":[[{"node":"Operation","type":"main","index":0}]]},"Operation":{"main":[[{"node":"Get Employees","type":"main","index":0}],[{"node":"Get Employees1","type":"main","index":0}],[{"node":"Valid Fields Only","type":"main","index":0}]]},"Get Employee":{"ai_tool":[[{"node":"Paycaptain MCP Server","type":"ai_tool","index":0}]]},"Get Employees":{"main":[[{"node":"Filter Matches","type":"main","index":0}]]},"Filter Matches":{"main":[[{"node":"Strip Sensitive Fields","type":"main","index":0}]]},"Get Employees1":{"main":[[{"node":"Filter Matching ID","type":"main","index":0}]]},"Update Employee":{"ai_tool":[[{"node":"Paycaptain MCP Server","type":"ai_tool","index":0}]]},"Search Employees":{"ai_tool":[[{"node":"Paycaptain MCP Server","type":"ai_tool","index":0}]]},"Update Employee1":{"main":[[{"node":"Get Success Response","type":"main","index":0}]]},"Valid Fields Only":{"main":[[{"node":"Has Valid Request?","type":"main","index":0}]]},"Filter Matching ID":{"main":[[{"node":"Strip Sensitive Fields1","type":"main","index":0}]]},"Has Valid Request?":{"main":[[{"node":"Update Employee1","type":"main","index":0}],[{"node":"Get Error Response","type":"main","index":0}]]},"Strip Sensitive Fields":{"main":[[{"node":"Aggregate Search Results","type":"main","index":0}]]},"Strip Sensitive Fields1":{"main":[[{"node":"Aggregate Get Response","type":"main","index":0}]]},"When Executed by Another Workflow":{"main":[[{"node":"Log Call","type":"main","index":0}]]}}}
  • CSV
  • Sheet
  • Spreadsheet
  • GS
  • API
  • Request
  • URL
  • Build
  • cURL
Planeta AI 2025 
magic-wandmenu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram