How to Use the Google Sheets MCP in VS Code Copilot

Q: How do I share the Google Sheets MCP Server configuration with my team in VS Code Copilot?

Save your Google Sheets server settings in a .vscode/mcp.json file at the root of your repository. When team members open the project in VS Code, the MCP tools will be available to VS Code Copilot automatically.

Q: Can VS Code Copilot read multiple Google Sheets ranges at once?

Yes, VS Code Copilot can use the batchgetvalues tool to fetch multiple Google Sheets cell ranges simultaneously. This is highly efficient for pulling distinct Google Sheets datasets into your VS Code Copilot workspace.

Q: Can VS Code Copilot create a new Google Sheets file from scratch?

Yes, VS Code Copilot can call createspreadsheet to generate a brand new Google Sheets document. The tool will return the new Google Sheets ID directly to your VS Code Copilot chat window.

Equip VS Code Copilot with Google Sheets tools so your team can read and update project spreadsheets directly from the editor.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect Google Sheets MCP to VS Code Copilot

Create your Vinkius account to connect Google Sheets to VS Code Copilot and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup Google Sheets with VS Code Copilot

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Commit team-wide Google Sheets workflows in VS Code Copilot

The `get_sheet_values` tool enables VS Code Copilot to pull down shared constants or localization keys directly from Google Sheets into your active file using this MCP Server. This ensures that every developer on your team uses the same Google Sheets data instead of outdated local files inside VS Code Copilot.

Push local build metrics directly to Google Sheets

Executing `append_sheet_values` lets VS Code Copilot write build metrics and test execution times directly into your team's tracking Google Sheets. This automates your team's performance logging to Google Sheets directly from the VS Code Copilot terminal interface.

Manage project roadmaps without leaving VS Code Copilot

With `update_sheet_values`, VS Code Copilot can modify task statuses in your product roadmap Google Sheets the moment you finish coding. This keeps your team's Google Sheets roadmap updated without requiring you to leave VS Code Copilot.

Setup guide

Set up Google Sheets MCP in VS Code Copilot

Prerequisites

VS Code 1.99 or later with GitHub Copilot extension
Active Vinkius subscription with a valid endpoint token

1

Open MCP configuration

Open the Command Palette (Cmd+Shift+P / Ctrl+Shift+P) and run "MCP: Add Server". Select HTTP (Streamable) as the server type. VS Code will create .vscode/mcp.json in your workspace.
2

Add the Google Sheets MCP

Paste the JSON snippet shown on the right into your .vscode/mcp.json. Replace [YOUR_TOKEN_HERE] with your endpoint token from cloud.vinkius.com.
3

Switch to Agent mode

Open Copilot Chat (Cmd+Shift+I / Ctrl+Shift+I) and switch to Agent mode using the dropdown. MCP tools are only available in Agent mode — they do not appear in Edit or Ask modes.
4

Verify the connection

In the Copilot Chat input, type # to list available tools. You should see the Google Sheets tools listed. Try asking: "List my recent Google Sheets transactions" and Copilot will invoke them automatically.

.vscode/mcp.json

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

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Google Sheets. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect Google Sheets now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about Google Sheets MCP in VS Code Copilot

Save your Google Sheets server settings in a `.vscode/mcp.json` file at the root of your repository. When team members open the project in VS Code, the MCP tools will be available to VS Code Copilot automatically.

Yes, VS Code Copilot can use the `batch_get_values` tool to fetch multiple Google Sheets cell ranges simultaneously. This is highly efficient for pulling distinct Google Sheets datasets into your VS Code Copilot workspace.

VS Code Copilot requires access to your Google Sheets files via the credentials you provide to the server. You control permissions by sharing specific Google Sheets files with the service account.

Yes, VS Code Copilot can call `create_spreadsheet` to generate a brand new Google Sheets document. The tool will return the new Google Sheets ID directly to your VS Code Copilot chat window.

Your Google Sheets cell values, sheet structures, and metadata are handled through isolated sandboxes that run locally or via encrypted channels. This ensures your sensitive Google Sheets content is never cached or used to train public models via VS Code Copilot.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript