How do I specify which cells to read or update?

You use 'A1 notation'. For example, 'Sheet1!A1:B5' refers to the first two columns and first five rows of the tab named 'Sheet1'. If you just say 'Sheet1', it attempts to read the active data range.

Can I add a new row of data without knowing the exact empty row number?

Yes! Use the `append_sheet_values` tool. You simply provide the range of the table (e.g., 'Sheet1!A:C') and the data you want to add. It automatically appends to the next empty row.

Can it delete sheets completely?

The tool endpoints are restricted to inside-sheet operations. It cannot delete the root spreadsheet itself from your Drive to prevent catastrophic destructive commands.

Google Sheets MCP Server for Windsurf 10 tools — connect in under 2 minutes

Name: Google Sheets
Availability: InStock
Author: Vinkius

docs.windsurf.com/windsurf/mcp

Built by Vinkius GDPR 10 Tools IDE

Windsurf brings agentic AI coding to a purpose-built IDE. Connect Google Sheets through the Vinkius and Cascade will auto-discover every tool — ask questions, generate code, and act on live data without leaving your editor.

Get MCP Server for AI Agents

ASK AI ABOUT THIS MCP SERVER

Open in ChatGPT Open in Claude Open in Perplexity

Vinkius supports streamable HTTP and SSE.

RecommendedModern Approach — Zero Configuration

Vinkius Desktop App

The modern way to manage MCP Servers — no config files, no terminal commands. Install Google Sheets and 2,500+ MCP Servers from a single visual interface.

Download Free Open SourceNo signup required

Classic Setup·json

{
  "mcpServers": {
    "google-sheets": {
      "url": "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    }
  }
}

Fully ManagedVinkius Servers

60%Token savings

High SecurityEnterprise-grade

IAMAccess control

EU AI ActCompliant

DLPData protection

V8 IsolateSandboxed

Ed25519Audit chain

<40msKill switch

Stream every event to Splunk, Datadog, or your own webhook in real-time

* Every MCP server runs on Vinkius-managed infrastructure inside AWS - a purpose-built runtime with per-request V8 isolates, Ed25519 signed audit chains, and sub-40ms cold starts optimized for native MCP execution. See our infrastructure

About Google Sheets MCP Server

Connect Google Sheets to your AI agent and turn conversational commands into complex spreadsheet operations. Read data from specific ranges, append new rows, and update existing values across all your Google Sheets without writing a single formula.

Windsurf's Cascade agent chains multiple Google Sheets tool calls autonomously — query data, analyze results, and generate code in a single agentic session. Paste the Vinkius Edge URL, reload, and all 10 tools are immediately available. Real-time tool feedback appears inline, so you see API responses directly in your editor.

What you can do

Data Extraction — Read values from specific ranges (e.g., 'Sheet1!A1:D10') or fetch multiple ranges simultaneously for instant analysis
Data Entry & Updates — Append new rows to existing tables or update specific cells directly from the chat
Sheet Management — Create new spreadsheets, add new tabs (sheets) to existing files, and delete unwanted tabs
Formatting & Structure — Execute batch update requests to manipulate the spreadsheet structure programmatically

The Google Sheets MCP Server exposes 10 tools through the Vinkius. Connect it to Windsurf in under two minutes — no API keys to rotate, no infrastructure to provision, no vendor lock-in. Your configuration, your data, your control.

How to Connect Google Sheets to Windsurf via MCP

Follow these steps to integrate the Google Sheets MCP Server with Windsurf.

Open MCP Settings

Go to Settings → MCP Configuration or press Cmd+Shift+P and search "MCP"

Add the server

Paste the JSON configuration above into mcp_config.json

Save and reload

Windsurf will detect the new server automatically

Start using Google Sheets

Open Cascade and ask: "Using Google Sheets, help me..." — 10 tools available

Why Use Windsurf with the Google Sheets MCP Server

Windsurf provides unique advantages when paired with Google Sheets through the Model Context Protocol.

Windsurf's Cascade agent autonomously chains multiple tool calls in sequence, solving complex multi-step tasks without manual intervention

Purpose-built for agentic workflows — Cascade understands context across your entire codebase and integrates MCP tools natively

JSON-based configuration means zero code changes: paste a URL, reload, and all 10 tools are immediately available

Real-time tool feedback is displayed inline, so you see API responses directly in your editor without switching contexts

Google Sheets + Windsurf Use Cases

Practical scenarios where Windsurf combined with the Google Sheets MCP Server delivers measurable value.

Automated code generation: ask Cascade to fetch data from Google Sheets and generate models, types, or handlers based on real API responses

Live debugging: query Google Sheets tools mid-session to inspect production data while debugging without leaving the editor

Documentation generation: pull schema information from Google Sheets and have Cascade generate comprehensive API docs automatically

Rapid prototyping: combine Google Sheets data with Cascade's code generation to scaffold entire features in minutes

Google Sheets MCP Tools for Windsurf (10)

These 10 tools become available when you connect Google Sheets to Windsurf via MCP:

add_sheet

Add a new sheet to a spreadsheet

append_sheet_values

Append rows of data to a table

batch_get_values

Read multiple ranges of values

batch_update_spreadsheet

Apply multiple updates to a spreadsheet structure/formatting

clear_sheet_values

Clear values from a range

create_spreadsheet

Create a new Google Spreadsheet

delete_sheet

Delete a sheet from a spreadsheet

get_sheet_values

Read values from a specific range

get_spreadsheet

Get spreadsheet metadata and sheets

update_sheet_values

Update values in a specific range

Example Prompts for Google Sheets in Windsurf

Ready-to-use prompts you can give your Windsurf agent to start working with Google Sheets immediately.

"Read the data in range A1:C10 from spreadsheet ID '1abcxyz'."

"Append a new row to the 'Q1 Sales' sheet with the values: 'Mike T', 'Engineering', '$12,000'."

"Create a new sheet called 'Finances 2026' and populate the headers."

Troubleshooting Google Sheets MCP Server with Windsurf

Common issues when connecting Google Sheets to Windsurf through the Vinkius, and how to resolve them.

Server not connecting

Check Settings → MCP for the server status. Try toggling it off and on.

Google Sheets + Windsurf FAQ

Common questions about integrating Google Sheets MCP Server with Windsurf.

How does Windsurf discover MCP tools?

Windsurf reads the mcp_config.json file on startup and connects to each configured server via Streamable HTTP. Tools are listed in the MCP panel and available to Cascade automatically.

Can Cascade chain multiple MCP tool calls?

Yes. Cascade is an agentic system — it can plan and execute multi-step workflows, calling several tools in sequence to accomplish complex tasks without manual prompting between steps.

Does Windsurf support multiple MCP servers?

Yes. Add as many servers as needed in mcp_config.json. Each server's tools appear in the MCP panel and Cascade can use tools from different servers in a single flow.