LangChain spreadsheet generator sheet_query
How to: LangChain spreadsheet generator sheet_query
Add spreadsheet generator to LangChain
-
01
Open pip install langchain-mcp-adapters and merge this in. Keep any servers already there.
from langchain_mcp_adapters.client import MultiServerMCPClient
client = MultiServerMCPClient({
"spreadsheet-generator": {
"transport": "streamable_http",
"url": "https://mcp.zovo.one/mcp/spreadsheet-generator",
}
})
tools = await client.get_tools()
-
02
Save the file and restart LangChain.
-
03
Ask for something sheet_query does. LangChain lists the server's tools on connect and calls sheet_query itself — you do not invoke it by name.
-
04
If nothing happens, check the server is running and that spreadsheet generator's identifier in your config matches the one above exactly.
get_tools() returns the server's tools as LangChain tools, ready for an agent. LangChain docs
Set these first
spreadsheet generator will not start until these are set, so sheet_query never becomes available.
-
MCP_LICENSE_KEY
Same tool, other clients
This list was read from the server itself, by connecting to it and calling tools/list on 24 September 2026. It is what
the server actually exposes, not what its listing claims.
Mutating and Read-only are read off each tool's name, not its schema — a hint, not a guarantee. The registry stores tool names only; connect the server for its live schemas.