selectNsolve API

An MCP server that lets AI agents create Google Sheets™ spreadsheets pre-filled with selectNsolve™ math text. The user opens the sheet, runs the selectNsolve Basic™ add-on, and the equations are solved — inside Google Sheets™, exactly as designed.

Quick Start Get the Add-on

How this works

selectNsolve Basic™ is a Google Workspace™ add-on — it runs entirely inside Google Sheets™. This API creates a spreadsheet and writes your problem as selectNsolve™ math text (constants, variables, equations). You then open the sheet and run the add-on to solve. The API does not solve equations itself; the add-on does.

Creates Google Sheets™

Pre-filled with selectNsolve™ math text

MCP & REST

Works with Claude, GPT-4, any agent

Full syntax support

Constants, variables, equations, derivations

Quick Start

No API key needed. Call the MCP server to create a Google Sheet™ and write your selectNsolve™ problem into it, then open the sheet and run the add-on.

import json, requests

MCP = "https://myengineeringproject.com/api/mcp"

def mcp(method, params, id=1):
    r = requests.post(MCP, json={"jsonrpc":"2.0","id":id,"method":method,"params":params})
    return r.json()["result"]

def call(tool, args):
    return json.loads(mcp("tools/call",{"name":tool,"arguments":args})["content"][0]["text"])

# 1. Handshake
mcp("initialize", {
    "protocolVersion": "2024-11-05",
    "clientInfo": {"name": "my-agent", "version": "1.0"},
    "capabilities": {},
})

# 2. Create a Google Sheet
sheet = call("sheets_create", {"title": "Pipe Flow Analysis"})
print("Sheet URL:", sheet["url"])

# 3. Write selectNsolve math text using the canonical template
call("sheets_apply_template", {
    "spreadsheetId": sheet["spreadsheetId"],
    "sheetName":     "selectNsolve",
    "title":         "Pipe Flow Analysis",
})

# 4. Share the URL — user opens it and runs the selectNsolve add-on
print("Open this sheet and run the selectNsolve Basic™ add-on:")
print(sheet["url"])

End-to-End Workflow

The API handles creating the sheet and writing the math text. The selectNsolve™ add-on handles the solving — inside Google Sheets™.

MCP Integration

selectNsolve™ exposes an MCP server at https://myengineeringproject.com/api/mcp. Any MCP-compatible model can connect and use the Sheets tools to build a selectNsolve worksheet for a user.

Connect Claude Desktop

Add the following to your claude_desktop_config.json (where to find it ↗) to give Claude access.

// claude_desktop_config.json
{
  "mcpServers": {
    "selectNsolve": {
      "url": "https://myengineeringproject.com/api/mcp"
    }
  }
}

Remote MCP server support

Claude Desktop 0.10.0+ supports remote MCP servers over HTTP. Older versions may require a local proxy.

selectNsolve Math Text Syntax

The API writes these five environment characters into cell text. The add-on reads them when it runs inside Google Sheets™.

=Math text

ε = 0.0001 m

Any cell containing '=' is read as math text — constant, variable, derivation, or equation

|Precision

1/sqrt(f) = … | 0.0001

Flags the cell as an equation. Number following is precision (0 < n ≤ 1). Closer to 1 = higher precision; 60-second limit in the add-on.

>Lower bound

f = 0.02 > 1e-10

Lower search bound (≥) on a variable — the add-on searches from this value upward

<Upper bound

f = 0.02 > 1e-10 < 1

Upper search bound (≤) on a variable — the add-on searches up to this value

:GSheets fn

-2*:LOG10(ε/(3.7*D)+…)

Prefix routes that function to the Google Sheets™ formula engine (LOG10, SIN, COS…)

Example — Colebrook-White Equation

The friction factor is implicit — it appears on both sides. The API writes this into the sheet; the add-on solves it.

# CONSTANTS
ε = 0.0001 m
D = 0.1 m
Re = 100000

# VARIABLES
f = 0.02 > 1e-10 < 1

# EQUATIONS
Formulas:LOG10
1/sqrt(f) = -2*:LOG10(ε/(3.7*D) + 2.51/(Re*sqrt(f))) | 0.0001

Three-step AI workflow

sheets_create

Create a Google Sheet. Returns spreadsheetId and URL.

sheets_apply_template

Write the selectNsolve math text: constants, variables, equations, Formulas declaration.

— Return URL to user

User opens the sheet, installs selectNsolve Basic™ from the Google Workspace™ Marketplace, and runs it to solve.

MCP Tool Reference

Tool	Required args	Returns
`sheets_create`	title	spreadsheetId, url
`sheets_read_range`	spreadsheetId, range	values (2-D array)
`sheets_write_range`	spreadsheetId, range, values	updatedCells
`sheets_format_selectnsolve`	spreadsheetId, startCell, entries	updatedCells, formatted[ ]
`sheets_apply_template`	spreadsheetId, sheetName, title	rowsWritten, formatted[ ]

Get selectNsolve Basic™

Install the add-on from the Google Workspace™ Marketplace to solve equations inside your Google Sheets™.

Install from Marketplace Contact Support