MCP servers · Google Sheets · MCP server
Connect VS Code (Copilot) to Google Sheets
One line gives VS Code (Copilot) your Google Sheets account as tools: 8 endpoints, spreadsheets, values, sheets, called with your own connection. No key in the prompt, a receipt for every call, revoke VS Code (Copilot)'s access alone any time.
Three steps
- Create a free 0n3 account and connect Google Sheets. Paste a key or sign in; it lands in your vault, encrypted.
- Install 0n3 into VS Code (Copilot). One-click install link, or .vscode/mcp.json.
- Ask VS Code (Copilot): whoami. Then: "Create a spreadsheet in Google Sheets".
One-click install
The line above carries a placeholder; 0n3.app/install mints a real key named for VS Code (Copilot) and fills it in.
What VS Code (Copilot) can then do in Google Sheets
Spreadsheets · Create and get spreadsheet metadata8
Create a spreadsheet
POST /spreadsheetsGet a spreadsheet
GET /spreadsheets/{spreadsheetId}Get values
GET /spreadsheets/{spreadsheetId}/values/{range}Update values
PUT /spreadsheets/{spreadsheetId}/values/{range}Append values
POST /spreadsheets/{spreadsheetId}/values/{range}:appendClear values
POST /spreadsheets/{spreadsheetId}/values/{range}:clearBatch get
GET /spreadsheets/{spreadsheetId}/values:batchGetBatch update
POST /spreadsheets/{spreadsheetId}/values:batchUpdateValues · Read, write, and append cell values0
Read, write, and append cell values
Sheets · Add and remove sheets within a spreadsheet0
Add and remove sheets within a spreadsheet
Google Sheets in other AI clients
Claude Code + Google SheetsMCP server + skillClaude (desktop & claude.ai) + Google SheetsconnectorChatGPT + Google Sheetsconnector · GPT actionCodex CLI + Google SheetsMCP serverGemini CLI + Google SheetsMCP serverCursor + Google SheetsMCP serverWindsurf + Google SheetsMCP server
