AutomationMart
Home/Browse/Build your own CUSTOM API MCP server
n8n

Build your own CUSTOM API MCP server

n8nn8n20 modulesv1.0
Google Sheets

This n8n demonstrates how any organisation can quickly and easily build and offer MCP servers to their customers or internal staff to improve productivity. This MCP example uses PayCaptain.com as an example and shows how to create an MCP server which can search for and update employee data. How it works A MCP server trigger is used and connected to 3 custom workflow tools: Search Employee, Get Employee by ID and Update Employee. Each tool makes calls to the PayCaptain API to perfor

At a glance

Build your own CUSTOM API MCP server is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets
Modules
20
Price
Free
Version
v1.0
Build your own CUSTOM API MCP server workflow diagram

About this workflow

This n8n demonstrates how any organisation can quickly and easily build and offer MCP servers to their customers or internal staff to improve productivity. This MCP example uses PayCaptain.com as an example and shows how to create an MCP server which can search for and update employee data. How it works A MCP server trigger is used and connected to 3 custom workflow tools: Search Employee, Get Employee by ID and Update Employee. 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. 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. 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. How to use 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. Connect your MCP client by following the n8n guidelines here - Try the following queries in your MCP client: "When did Sarah start here employment at the company?" "Does Jack work Wednesdays or Fridays?" "Please update Tracy's NI number to ABCD123456" Requirements PayCaptain Account and Developer Key. Google Sheets to log actions for later audit. MCP Client or Agent for usage such as Claude Desktop - Customising this workflow Add or remove employee attributes as required for your user case. If Google Sheets is too slow, consider an API call to a faster service to log calls to the MCP server. Remember to set the MCP server to require credentials before going to production and sharing this MCP server with others!

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

BrowserAct Smart Site Evaluation Pipeline

This automation uses BrowserAct and Google Gemini to perform a full website analysis and save structured insights into Google Sheets. Simply enter one or more website URLs in your input sheet, and the workflow will: Open each site using BrowserAct Extract visual, structural, and content information Send the data to Gemini for evaluation Identify specific problems on the page Generate clear, actionable recommendations Write results into the “Problems” sheet in a clean JSON → table format P

Free

Add a new row to a Google Sheets spreadsheet and send a new notification to Slack from a won opportunity in SugarCRM

Every time a new won opportunity is captured in SugarCRM, a new row will be instantly created in a Google Sheets spreadsheet and a notification will be sent to Slack.

Free

Create SEO blog drafts in WordPress from trending topics with Perplexity and HuggingFace

Automatically discover trending developer and security topics, generate SEO-optimized blog posts, and publish them to WordPress as drafts — complete with AI-generated featured images. How it works 1. Discover trends — Perplexity AI identifies the hottest topic from the last 24-48 hours 2. Queue topics — Topics are saved to Google Sheets for tracking and management 3. Generate content — Perplexity creates complete blog posts with titles, sections, keywords, and meta descriptions

Free

Sync ActiveCampaign analytics to Google Sheets

Automatically sync your ActiveCampaign analytics to Google Sheets to enhance your marketing campaigns. This template transfers key performance metrics every Friday, allowing you to access fresh insights at the start of each week. Optimize your strategies with up-to-date data, reduce manual tasks, and improve decision-making efficiency. Ideal for teams looking for a streamlined approach to campaign tracking and analysis. The scenario runs every Friday (feel free to change the schedule if needed).

Free

Sync Facebook Ads data to Google Sheets

Simplify your marketing analytics workflow with our automated solution that transfers your Facebook Ads data to Google Sheets daily. Gain a consolidated view of your campaigns' performance and budget allocations every morning at 8:00 AM, using the previous day's data. Customizable scheduling is available to fit your reporting routine—adjust the time settings in the first module with a click.

Free

Save Relatel Calls to a Google Sheets spreadsheet

Every time a new call is received in Relatel, Make will automatically add that message to your Google Sheets spreadsheet as a new row. The template uses [this example spreadsheet.](https://docs.google.com/spreadsheets/d/1rZxmW0-pVxScq-NLHNun3EVb2VdhTE16EOCUoWKDo6o/edit?usp=sharing)

Free

Automate ASMR video creation and distribution with FalAI and social media integration

Create Unlimited Viral ASMR Videos — Fully Automated! Tired of spending hours brainstorming viral content, writing prompts, and juggling video uploads? This powerful n8n workflow automates your entire short-form ASMR video creation process, turning you into a content powerhouse — without burnout or repetitive manual work. ✅ No coding required ✅ Connects with cutting-edge AI video generation (FalAI) ✅ Publishes videos to TikTok, Instagram, YouTube, and more ✅ Trac

Free

Automate browser tasks with Airtop & GPT-4 - Reddit posting example

Overview This n8n workflow creates an intelligent AI agent that automates browser interactions through Airtop's browser automation platform. The agent can control real browser sessions, navigate websites, interact with web elements, and maintain detailed session records - all while providing live viewing capabilities for real-time monitoring. Youtube Tutorial: What This Workflow Does The AI agent acts as your virtual assistant in the browser, capable of: - Session Management: Creates, monitors,

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free