Claude
claude.ai and the desktop app
- 1Customize → Connectors → Add custom connector.
- 2Paste https://sheetai.co/api/mcp and choose “Sign in now”.
- 3Approve access on the SheetAI screen, then enable SheetAI from the + menu in a chat.
SheetAI is a remote MCP server. Add it to Claude, ChatGPT, Cursor, VS Code, Claude Code or any MCP-compatible app, sign in once, and that app can list, read, query and edit your SheetAI spreadsheets. Looking for the other direction, connecting Notion or HubSpot into SheetAI? That is Connectors.
https://sheetai.co/api/mcpStreamable HTTP. OAuth 2.1 sign-in is discovered automatically; personal access tokens work as a bearer header.
Every guide below is also in Settings → MCP server, with the URL and commands ready to copy.
claude.ai and the desktop app
developer mode on your plan
terminal
mcp.json
Windsurf, Gemini CLI, Copilot, Goose, Zed, Zapier, n8n, Make, your own agent
Read tools need the read scope. Write tools need the write scope, which you grant separately at sign-in or when creating a token. Your spreadsheets also appear as resources (attach one from the app’s picker), and two ready-made prompts, Summarize a spreadsheet and Answer a question from a sheet, show up as commands in apps that support them.
get_meWho you are: name, plan, credits left, team, spreadsheet counts, links to Settings.list_spreadsheetsEvery spreadsheet you own or can open, with ids, links and paging.get_spreadsheetOne workbook's tabs, sizes, headers and a sample of each.read_rangeThe values in an A1 range, formulas included.query_sheetA SQL query over one tab: filter, aggregate, sort, join in-sheet.get_sheet_csvA whole tab as CSV, ready to hand to another tool.write_rangeWrite values or formulas starting at a cell; the range grows to fit.append_rowsAdd rows under the last used row of a tab.create_spreadsheetStart a new workbook, with optional tabs and starting data.An app connects through OAuth 2.1 with PKCE: it registers itself, sends you to a SheetAI consent screen that names the app and the access it asks for, and gets a short-lived token scoped to exactly that. Refresh tokens rotate on every use, so a leaked old token is useless. Every connected app is listed in Settings → MCP server with a Disconnect button.
Read the full guideAny MCP client library works. To try it by hand, create a personal access token in Settings → MCP server and list the tools:
curl -X POST https://sheetai.co/api/mcp \
-H "Authorization: Bearer sai_pat_..." \
-H "Content-Type: application/json" \
-H "Accept: application/json, text/event-stream" \
-d '{"jsonrpc":"2.0","id":1,"method":"tools/list"}'Discovery: /.well-known/oauth-authorization-server and /.well-known/oauth-protected-resource on sheetai.co. Registration: /api/oauth/register.
One URL, one sign-in, every spreadsheet you own.
Works in your browser and Google Sheets · Setup in 30 seconds