Mindket
English
English简体中文
Sign inSign up
StoreMCPSkillsCalculatorLearnPriceBlog
Discover
Research311Writing59Business95Legal13Finance & accounting33Marketing & SEO175Developer1,420Productivity390Education81Companions14
Help and support
Language
English简体中文

Spreadsheet formula set and checked through an MCP server

by Mindketn8n workflowDeveloper
Newversion 1 · updated
Nodes3Apps1Like

Overview

  1. Manual Trigger
  2. Bilig MCP: write formula and verify
  3. Extract formula proof
Spreadsheet formula set and checked through an MCP server, picture 1
‹2 / 2›

A small n8n workflow that calls a public MCP server over plain HTTP. It writes a formula into a demo workbook, then checks the calculated value and the server’s proof that the restored cell matches.

Spreadsheet formula set and checked through an MCP server is an n8n workflow in the Developer category, listed by Mindket. It is free. This is version 1, last updated on . Download it on this page or copy its JSON, then import it into an n8n canvas. Nothing runs until you activate it in n8n.

At a glance

Runs in
  • n8n Cloud: import the file into a new workflow there
  • Your own n8n server: the same file and steps
  • Another MCP server: change the address, the tool name and the arguments in the HTTP node
  • A server with a key: add a header that uses an n8n credential

Platform

n8nWorkflow automation, in n8n’s cloud or on your own server
Connects 1 app

How it works

Trigger

Manual start

It starts when you click Test workflow in n8n, and it sends one fixed call:

  • The formula =B2*B3
  • Cell C2 of the sheet Inputs in the server’s demo workbook

Actions

  1. An HTTP request posts a JSON-RPC tools/call message to the MCP server
  2. The server writes the formula into the cell and calculates it
  3. The reply carries the cell before, after and restored, with a check that they match
  4. A Code node stops with an error if the formula, the value 5 or the proof is wrong
  5. It returns a short summary and the whole proof

Result

A summary line, the edited cell, the formula, the calculated value and the server’s proof, or an error that says which check failed

Integrations

What you need before you start.

Bilig WorkPaper MCP

Spreadsheet engine

Receives the tool call over HTTP, writes the formula into its demo workbook, calculates it and returns the readback.

NeedsNothing, the endpoint is public and takes no key

Workflow check

Checked by Mindket on 13 Nov 2026

Steps
3 steps, starting by hand
AI
No step calls an AI model
Sign-ins
No sign-in
API keys
No API key is left in the file
Step types
Mindket’s checker reads all 3 of its step types

Read from the workflow’s file, not from a run.

About

What it is

This n8n workflow calls a public MCP server and checks the answer. An MCP server offers tools to software and AI agents. This one offers a spreadsheet engine. The workflow sends one HTTP request that asks it to write the formula =B2*B3 into cell C2 of the sheet Inputs in a demo workbook. The reply carries the cell before and after, the calculated value and a check that the restored cell matches. A Code node reads that reply and stops with an error when the formula, the value 5 or the proof is wrong. Three nodes do the work, beside one sticky note.

Who it suits

Developers who want to see how n8n can call an MCP server without the MCP Client node, and people who need a template for any tool call over HTTP. Skip it if you want to edit your own spreadsheets. The workbook belongs to the server.

Who uses it, and how
IndustryWho uses itHow they use itExample
Softwaren8n buildersLearn the shape of an MCP tool call sent over HTTPA builder changes the tool name and arguments to call another MCP server.
SoftwareDevelopers who test serversSend one fixed call and compare the reply with what is expectedA developer checks that a server still returns the same value after an upgrade.
FinanceAnalysts who like formulasSee a spreadsheet engine calculate a formula outside any spreadsheet programAn analyst reads the calculated value and the before and after cell in the output.
EducationTeachers of automationShow a call, a reply and a check in three nodesA teacher runs it live and opens each node in turn.

You need almost no n8n: import a file and click one button. No credential is needed. The workflow’s own sticky note gives no setup time.

Where to use it

Any n8n that can reach https://bilig.proompteng.ai/mcp will run it.

  • n8n Cloud: import the file into a new workflow there
  • Your own n8n server: the same file and steps
  • Another MCP server: change the address, the tool name and the arguments in the HTTP node
  • A server with a key: add a header that uses an n8n credential

Setup

Download saves a zip with workflow.json and Mindket’s setup notes in your downloads folder. No account is needed.

What you need first
NeedDetail
n8nOn n8n Cloud or on a server of your own
NetworkA route from n8n to https://bilig.proompteng.ai/mcp
  1. In n8n, create a workflow, open its menu and choose Import from File. Pick workflow.json.
  2. Click Test workflow.
  3. Open Extract formula proof. The output holds summary, editedCell, formula, displayValue, restoredMatchesAfter and proof.
  4. A good run says the formula calculated as 5 and the restored readback was proved. Open Bilig MCP: write formula and verify to see the raw reply.

How to use it

Click Test workflow and read the output of the last node. The HTTP node posts a JSON-RPC message with the method tools/call and a 30 second timeout. The server writes the formula, calculates it and returns the cell before, after and restored. The Code node turns that into a short summary plus the whole proof.

What to change for a different result
To changeWhere
The serverThe address in Bilig MCP: write formula and verify
The tool and its argumentsThe jsonBody of the same node
What counts as a passThe checks in Extract formula proof
The reply you keepThe fields returned by Extract formula proof

Example

You click Test workflow. The server reports that cell C2 was empty before, holds =B2*B3 after, and shows 5.

The output reads that the formula was calculated as 5 and the restored readback was proved. The server also reports that it did not keep the edit.

For newcomers and experts

If you are new. n8n draws a workflow as boxes joined by lines, and each box, a node, does one job. This one has three boxes in a row. The first starts it, the second sends the request and the third checks the reply. Open each node after a run to see what went in and out.

For experts. The call skips the MCP initialize step and sends tools/call straight away.

Where to look closer
NodeWhat it doesWhat to know
Bilig MCP: write formula and verifyHTTP Request, version 4.2, POST with a JSON bodySets mcp-protocol-version to 2025-11-25 and accepts JSON or an event stream
Extract formula proofCode node, version 2Parses the first text part of the reply and throws when the formula, the value or the proof is wrong

Good to know

The server is a third party’s public demo, and the checks match its sample data.

  • Server: Mindket does not run it. On 12 November 2026 it answered with the expected result and said it did not persist the edit. Mindket cannot say how long it stays up or free
  • Your data: the sheet name, the cell address and the formula go to that server, so send nothing private
  • Demo values: the checks expect the sheet to hold values whose product is 5, so a change to the demo workbook makes the Code node stop
  • No handshake: a server that needs an initialize step or a session id will refuse the call
  • Credentials: the JSON holds none

README and files

README

Spreadsheet formula set and checked through an MCP server

An n8n workflow that calls a public MCP server over plain HTTP. It asks the server to write the formula =B2*B3 into cell C2
of the sheet Inputs in a demo workbook. Then it checks the readback: the formula, the calculated value and the server's own
proof that the restored cell matches. It needs no credential and no spreadsheet program.

What is inside

  • workflow.json: the workflow as n8n exports it, three nodes and one sticky note. It holds no credential.
  • README.md: these notes.

What we changed from the original copy

  • The sticky note was rewritten. It named a code repository and said the demo needs nothing, and the new text says what the
    workflow sends and that the server belongs to a third party.
  • The Extract formula proof node returned three fixed links to the service's own pages next to its result. They are gone. The
    checks and the other fields are as they were.
  • The saved template flag was removed. Nothing else changed.

Before you start

  • An n8n instance, on n8n Cloud or your own server. It must be able to reach https://bilig.proompteng.ai/mcp.
  • Nothing else. The endpoint is public and takes no key.

Set it up

  1. In n8n, create a workflow, open its menu and choose Import from File. Pick workflow.json.
  2. Click Test workflow.
  3. Open Extract formula proof. The output holds summary, editedCell, formula, displayValue, restoredMatchesAfter and
    proof. A good run reads: calculated =B2*B3 as 5 and proved restored readback.
  4. To read the whole answer, open Bilig MCP: write formula and verify. Its output is a JSON-RPC reply whose text is the proof.

How a run goes

  1. Manual Trigger starts the run.
  2. Bilig MCP: write formula and verify posts one JSON-RPC message with the method tools/call. It asks for the tool
    set_cell_contents with the sheet Inputs, the address C2 and the value =B2*B3. The headers set content-type to
    JSON, accept to JSON or an event stream, and mcp-protocol-version to 2025-11-25. The timeout is 30 seconds.
  3. Extract formula proof reads the first text part of the reply and parses it as JSON. It stops with an error when the formula
    read back is not =B2*B3, when the calculated value is not 5 or when checks.restoredMatchesAfter is not true. Otherwise it
    returns the summary and the whole proof.

Use another MCP server

The call is a standard MCP request, so the pattern carries over. Change the address, the tool name and its arguments in
jsonBody, and the checks in Extract formula proof. For a server that needs a key, add a header with an n8n credential. n8n
also has an MCP Client Tool node that gives the tools of a server to an AI agent. This workflow uses plain HTTP instead.

Good to know

  • The server is a third party's public demo, not something Mindket runs. On 12 November 2026 it answered the call with the
    expected result and a persisted flag of false, which means the server did not keep the edit. Mindket cannot say how long it
    stays up or free.
  • The workflow sends the sheet name, the cell address and the formula to that server. Send nothing private.
  • The checks expect the demo sheet to hold values whose product is 5, so =B2*B3 reads back as 5. If the server changes its demo
    workbook, the node stops with Unexpected calculated value. Edit the checks then.
  • No handshake comes first. The workflow sends tools/call straight away, so a server that wants an initialize step or a session
    id will refuse it.
  • This is a demonstration of one call, not a way to edit your own spreadsheets.
Files
NOTICE.md  648 B
README.md  4 KB
workflow.json  4 KB

3 files, 8 KB, downloaded as a zip.

What’s new

  • Version 1 · 2026-11-12

Reviews

No ratings yet

Write a review

No reviews yet.

More from Mindket

See all from Mindket

Huashu Design

alchaincyf · Skill

Turns a one-line request in your AI agent into a finished design: a launch animation, a clickable app prototype, an editable slide deck, an infographic or a se…

New29.4k

Guizang PPT Skill

op7418 · Skill

Skill that makes single-file HTML slide decks, slide illustrations and platform covers in two visual styles, with a presenter mode for rehearsal. For speakers…

New29.8k

Claude Code Skills & Plugins

alirezarezvani · Skill

Adds 411 ready-made skills for Claude Code and other coding agents, grouped by role from engineering and product to marketing, finance and compliance. Installs…

New29.8k

Similar in Developer

See all in Developer

buzz

block · Kit

Self-hostable workspace where people and AI agents share the same rooms, built on a Nostr relay that logs every action as a signed event. For teams that want t…

New37.3k

plannotator

backnotprop · Kit

Opens your AI coding agent's plans, specs and code changes in a browser so you can annotate or comment on them and send the feedback straight back to the agent.

New10.5k

open-code-review

alibaba · Kit

Reviews Git changes with an AI agent that reads files and searches the codebase, then writes comments tied to exact lines. It suits developers who want automat…

New50.7k