Download PDFMarkdown Version
ClaudeChatGPTPerplexityGeminiMicrosoft CopilotRaycastMeta AIGrokZ.aiQwenKimi
DeepSeekMistralCursorVS CodeWindsurfJetBrainsClineLovableVercel AI SDKLangChain

Use Google Sheets with your AI.

Connect your account once and let the AI you already use work with it, without building another integration. Power up spreadsheets via Google Sheets. create, read, write, and append data, handle batch operations, and audit sheet info directly from any AI agent.

Included with plan

Ask AI about this Connector

Developed, maintained, and hosted by Vinkius.

MCP VERIFIED · PRODUCTION READY · VINKIUS GUARANTEED

Waiting for input…

Works with modern AI clients that support MCP, including ChatGPT, Claude, Cursor, and more.

ChatGPTClaudeCursorPerplexityGeminiMicrosoft CopilotRaycastMeta AI

Complete set · 7 capabilities

The complete Google Sheets capability set.

These are the exact actions your AI can choose when you ask it to work with Google Sheets.

Capability set01 / 02

01-04

4 capabilities in this set.

Part of 7 available through Google Sheets.

  1. 01

    Sheets.info

    Accepts full Google Sheets URL or just the spreadsheet ID. For reading cell values, use sheets.read. Get Google Sheets spreadsheet metadata: title, timezone, locale, and list of all sheet tabs with row/column dimensions

  2. 02

    Sheets.read

    Range uses A1 notation: "SheetName!A1:D10". If no sheet name, defaults to first sheet. To read multiple ranges in one call, use sheets.batch_read. To discover sheet names and dimensions first, use sheets.info. Present results as a Markdown table with the first row as headers. Read cell values from a Google Sheets range in A1 notation (e.g. "Sheet1!A1:D10" or "A:Z")

  3. 03

    Sheets.append

    Rows are inserted after the last row of existing data in the table range. Provide values as a 2D JSON array: [["val1","val2"],["val3","val4"]]. For overwriting a specific range, use sheets.write instead. Append new rows to the end of a Google Sheet table. does not overwrite existing data

  4. 04

    Sheets.batch read

    Provide ranges as comma-separated A1 notation strings (e.g. "Sheet1!A1:D10, Summary!A:B"). For a single range, use sheets.read instead. Read multiple cell ranges from a Google Sheet in a single API call. more efficient than calling sheets.read multiple times

Capability set02 / 02

05-07

3 capabilities in this set.

Part of 7 available through Google Sheets.

  1. 05

    Sheets.clear

    Note: formatting (colors, borders, fonts) is preserved. only values are removed. WARNING: This is destructive. Always confirm with the user before clearing. To clear a whole sheet, use the sheet name with no range: "Sheet1". Clear all values in a Google Sheets range. removes cell content but preserves formatting and formulas structure

  2. 06

    Sheets.create

    Returns the spreadsheet ID and a direct edit URL. After creating, use sheets.write or sheets.append to add data. Create a new blank Google Sheets spreadsheet with a given title

  3. 07

    Sheets.write

    Provide values as a 2D JSON array: [["row1col1","row1col2"],["row2col1","row2col2"]]. Uses USER_ENTERED input. formulas (starting with =) will be evaluated. WARNING: This overwrites existing data in the range. To add rows without overwriting, use sheets.append instead. Always confirm with the user before writing to production spreadsheets. Write data to a Google Sheets range. overwrites existing values. Accepts 2D array of rows and columns

Observed, not estimated

988ms average. Fast in production.

Google Sheets is checked daily against the live service.

Daily averagePeak 1167ms
Aug 20Today
Fastest day
800ms
Slowest day
1167ms
14-day trend
Slowing+43%

Connect your client

One URL. Every client.

Activate the Connector, copy your link, and paste it into the client you already use. 7 capabilities arrive ready to run.

Preview access · not provider authentication

The vk_preview_* token belongs to Vinkius preview infrastructure. It lets Claude discover and display the capabilities of Google Sheets, so you can see the experience inside your AI.

It does not authenticate your account with Google Sheets. Actions requiring credentials or live account data may not run until you activate the Connector and authorize the service.

Google Sheets Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_WRZzfv7tD5Iq0uGPYkA47NxkBfDiDeHJTMYzqLBk/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — Google Sheets capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "google-sheets-oauth-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_WRZzfv7tD5Iq0uGPYkA47NxkBfDiDeHJTMYzqLBk/mcp"
    }
  }
}
  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Step-by-step instructions for each client are in the guide. How to connect

FAQ

Questions Google Sheets owners ask.

  • 01

    How do I get a Google OAuth2 access token for this server?

    You can use the Google OAuth Playground (select Sheets API v4 and authorize) or run 'gcloud auth print-access-token' in your terminal. Note that these tokens are typically valid for 1 hour.

  • 02

    Can my agent create a new spreadsheet and add data to it in one go?

    Yes. The agent can orchestrate multiple operations. First, use 'create_spreadsheet' to get the new ID, and then use 'write_data' or 'append_data' to populate it with your JSON arrays natively.

  • 03

    What is the benefit of batch reading through the agent?

    Batch reading allowing your agent to retrieve data from multiple non-contiguous ranges (e.g., 'Sheet1!A1:B10' and 'Sheet2!C5:D15') in a single request, improving context efficiency and reasoning accuracy flawlessly.

Explore

More in Industry Titans

Suggestions