Skip to main content

MCP Quickstart

This guide takes you from account settings to a successful connection list.

Before you start​

You need:

  • a Sheet Best account where the AI assistants · MCP card is available;
  • an existing Sheet Best connection. If needed, create a connection before continuing;
  • an MCP-compatible client that supports remote servers and bearer-token authentication.

1. Enable MCP support​

Open your Sheet Best account settings. In AI assistants · MCP, turn MCP support on.

MCP account settings card with MCP support turned off.

The card displays your environment-specific Account endpoint and a Generate token action.

Enabled MCP account settings card showing the account endpoint and Generate token action.

2. Generate and store your token​

Select Generate token. In Your MCP token is ready, copy the token or select Download credentials.

One-time MCP token dialog with the token masked and Download credentials available.

Store the token now

The raw token is shown only once. Do not put it in a screenshot, URL, issue, or source file. If you give the downloaded credential file to a trusted agent in the next step, tell it not to display or log the token. If you lose the token, replace it from account settings.

After saving the credential securely, select I've stored it.

3. Ask your agent to configure Sheet Best​

If your agent can update its own MCP configuration, give it the downloaded sheetbest-mcp-credentials.txt file and ask:

Configure Sheet Best as a remote Streamable HTTP MCP server using this credential file. Keep the token in the authorization header, and do not display or log it.

Only give the credential file to an agent and MCP client you trust.

If your client cannot configure itself, enter these values manually in its remote MCP server settings:

SettingValue
Server URLThe Account endpoint copied from Sheet Best
AuthenticationBearer token
TokenThe value beginning with sbmcp_ that you stored in step 2

This is a client-neutral description, not a configuration file. Labels and formats differ between MCP clients; follow your client's current instructions for adding a remote Streamable HTTP server.

Keep the token out of the URL

Send the token as an authorization credential. Never append it as a query parameter.

4. Work through your AI assistant​

You can now ask your AI assistant to manage your Sheet Best connections. For example:

List my Sheet Best connections.

Or give it a Google Sheet URL and ask:

Create a Sheet Best connection for this Google Sheet.

Your assistant can choose the appropriate Sheet Best tool from your request. For example, listing connections returns each connection's name, enabled methods, MCP status, REST API URL, and Direct MCP URL.

MCP Inspector showing Sheet Best connection names, IDs, API URLs, and optional direct MCP URLs.

If your assistant cannot complete a request, see MCP troubleshooting.

Limit your AI assistant to one connection

The main MCP endpoint lets your AI assistant work with all your MCP-enabled connections. To limit it to one connection, configure the assistant with that connection's Direct MCP URL instead.

Copy the URL from the Sheet Best connection page and authenticate it with the same MCP token. Learn how direct connection endpoints work.

Example Direct MCP URL on a Sheet Best connection page.

Success looks like​

  • Your AI assistant can list or create Sheet Best connections.
  • sheetbest_list_connections returns apiUrl and directMcpUrl for each connection.
  • An optional direct server exposes only the tools allowed by its connection.

If a server does not connect or a tool is missing, see MCP troubleshooting.

Next step​

Review the connection and tool reference before allowing an assistant to write to your sheet.