Give AI agents live access to your spreadsheet

The sheet2api MCP server lets Claude, ChatGPT, Cursor and any other MCP client read and write the rows of your Google Sheet or Excel Online workbook.

Get started for free Read the MCP docs

link One server URL

Every sheet2api account uses the same MCP server address. Add it to your assistant and sign in with the Google or Microsoft account you already use here.

Transport is JSON-RPC 2.0 over HTTP POST. Protocol version 2025-03-26. Authentication is OAuth 2.1 with PKCE and Dynamic Client Registration, so there are no API keys to copy around.

bolt How it works

1

Connect a spreadsheet

Paste the link to your Google Sheet or Excel Online workbook and sheet2api turns it into a Spreadsheet API. Create one now.

2

Turn MCP on or off per API

MCP is on by default for each Spreadsheet API. Switch it off for any workbook an assistant should not reach, and leave the rest available.

3

Add the server to your assistant

Paste the server URL into your MCP client and approve the sign in prompt. Your enabled spreadsheets appear as tools.

Clients that do not yet support remote MCP servers can bridge to it over stdio.

{
  "mcpServers": {
    "sheet2api": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-remote",
        "https://sheet2api.com/mcp/"
      ]
    }
  }
}

build What the assistant can do

The server exposes a small set of tools. An assistant calls them the same way it calls any other tool, and the results come straight from your spreadsheet.

List worksheets list_worksheets Read Read only
List the worksheets of a Spreadsheet API together with the column names of each worksheet.
List rows list_rows Read Read only
Read rows from a worksheet as JSON objects keyed by column name, optionally filtered and limited.
Get cell values get_cell_values Read Read only
Read the values of specific cells, given as a comma separated list of cell references such as A1,B2,C3.
Create row create_row Create
Append a single new row to a worksheet. Keys of the row object must match the worksheet column names.
Replace rows update_rows Update Destructive
Replace every column of the rows matching the filters with the given row. Columns missing from the row are emptied. update_rows_partial leaves omitted columns unchanged.
Update rows update_rows_partial Update Destructive
Update only the given columns of the rows matching the filters, leaving every other column untouched.
Delete rows delete_rows Delete Destructive
Permanently delete the rows matching the filters. Filters are required so that a whole worksheet cannot be emptied by accident.

verified_user You stay in control

  • toggle_on MCP is enabled per Spreadsheet API by its owner. A spreadsheet no assistant should see stays off.
  • rule The same read, create, update and delete toggles that govern your REST API govern MCP. Turn off delete and no assistant can delete a row.
  • lock Access is granted through OAuth, not a shared key. You sign in with the account you already use and approve the assistant yourself.
  • vpn_key Revoke any connected assistant at any time and review recent MCP activity from your MCP dashboard.
  • equalizer Tool calls draw on the same monthly request allowance as your REST API. There is no separate MCP quota. See the pricing plans.

link Useful Links

Ready to get started?

Create your first spreadsheet API in less than 60 seconds. No credit card required.

Create Your First API
check_circle No credit card required
check_circle Cancel anytime
Or view our pricing plans