0n3
MCP servers · Google Sheets · connector · GPT action

Connect ChatGPT to Google Sheets

One line gives ChatGPT 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 ChatGPT's access alone any time.

Get the line for ChatGPTConnect Google Sheets first

Three steps

  1. Create a free 0n3 account and connect Google Sheets. Paste a key or sign in; it lands in your vault, encrypted.
  2. Install 0n3 into ChatGPT. A custom connector in Developer mode, or an Action on a custom GPT from the OpenAPI spec.
  3. Ask ChatGPT: whoami. Then: "Create a spreadsheet in Google Sheets".
Custom connector (needs Developer mode)
  1. Settings → Connectors (or Apps) → Advanced → Developer mode on
  2. Create → name 0n3 · MCP server URL https://0n3.app/mcp · Authentication: OAuth
  3. Finish the sign-in with your 0n account
  4. Enable the connector in a chat and ask: "whoami"

ChatGPT connectors cannot send a static header, so 0n3 signs you in through its OAuth door (dynamic client registration is on).

The line above carries a placeholder; 0n3.app/install mints a real key named for ChatGPT and fills it in.

What ChatGPT can then do in Google Sheets

Spreadsheets · Create and get spreadsheet metadata8
Create a spreadsheetPOST /spreadsheets
Get a spreadsheetGET /spreadsheets/{spreadsheetId}
Get valuesGET /spreadsheets/{spreadsheetId}/values/{range}
Update valuesPUT /spreadsheets/{spreadsheetId}/values/{range}
Append valuesPOST /spreadsheets/{spreadsheetId}/values/{range}:append
Clear valuesPOST /spreadsheets/{spreadsheetId}/values/{range}:clear
Batch getGET /spreadsheets/{spreadsheetId}/values:batchGet
Batch updatePOST /spreadsheets/{spreadsheetId}/values:batchUpdate
Values · 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 SheetsconnectorCodex CLI + Google SheetsMCP serverGemini CLI + Google SheetsMCP serverCursor + Google SheetsMCP serverVS Code (Copilot) + Google SheetsMCP serverWindsurf + Google SheetsMCP server

ChatGPT with other apps

Hostinger363 endpointsTelegram132 endpointsPipedrive95 endpointsResend67 endpointsSquare57 endpointsLinkedIn50 endpointsSlack45 endpointsFigma32 endpointsCloudConvert32 endpointseBay25 endpointsQuickBooks21 endpointsCloudflare21 endpoints