Connect AI Assistants with MCP
The Model Context Protocol (MCP) is a standard way for AI assistants to use external tools. Sheet Best provides a remote MCP server so a compatible assistant can discover your Google Sheet connections, inspect their permissions, and work with rows using the access rules you already configured in Sheet Best.
MCP is intended for Personal plans and above. As an introductory offer, it is also available on Tiny for at least the first six months after launch. This release does not enforce plan-level MCP access yet.
What your assistant can do
After you connect an MCP-compatible client, it can:
- list your Sheet Best connections and their API URLs;
- create a connection from a Google Sheet URL;
- check whether a sheet can be read or edited;
- list, filter, and query rows;
- add, update, replace, or delete rows when you explicitly request it;
- check your plan and remaining request allowance.
MCP complements the Sheet Best REST API. Use MCP when an AI assistant should choose and call tools for you. Use the REST API quickstart when you are building an application that sends HTTP requests directly.
One default server, with an optional direct URL
For most clients, configure only the Account endpoint shown in account settings. The token identifies your account, and the assistant passes a connection ID when it uses a sheet tool.
| Endpoint | Scope | When to use it |
|---|---|---|
| Account endpoint | All MCP-enabled connections in your account | Default. List or create connections and use sheet tools from one configured server. |
| Direct connection endpoint | One Sheet Best connection | Optional. Use when you want a client configuration focused on one sheet. |
Each connection page shows its optional Direct MCP endpoint. Both endpoint types use the same MCP token and enforce the same connection settings.
What you need
- A Sheet Best account with MCP access available.
- A Google Sheet with a valid header row. See Prepare your Sheet.
- A remote MCP client that can send a bearer token securely.
- Google edit access and enabled write methods if the assistant needs to change rows.
How access is controlled
MCP follows the same connection rules as the REST API:
- Your account and the individual connection must allow MCP access.
- The account and direct endpoints accept your Sheet Best MCP token.
- Connection ownership, allowed methods, plan features, Google Sheet permissions, quota, origin rules, and IP rules still apply.
- Tools that a connection cannot use are left out of its tool list.
- Successful row and sheet-info operations consume the same monthly request allowance as their REST equivalents. Permission, limit, and account tools do not.