Bring Spreadsheet
to VS Code Copilot
Create your Vinkius account to connect Google Sheets to VS Code Copilot and start using all 10 AI tools in minutes. Fully managed, enterprise secure, and ready to use without writing a single line of code. No hosting, no server setup — just connect and start using.
GDPR Free for SubscribersCompatible with every major AI agent and IDE
Gemini
What is the 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.
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
How it works
- Subscribe to this server
- Enter your Google OAuth Client ID and Secret
- Complete the secure Google authorization flow
- Start manipulating data from Claude, Cursor, or any MCP-compatible client
Your AI agent acts as a virtual data entry clerk and spreadsheet analyst, capable of translating natural language requests into structured API calls.
Who is this for?
- Financial Analysts — quickly pull specific KPIs from massive financial models without opening the spreadsheet
- Project Managers — log updates, append new tasks, or extract project timelines from shared trackers seamlessly
- Marketing Teams — add new leads or campaign metrics to tracking sheets via conversational commands
Built-in capabilities (10)
Add a new sheet to a spreadsheet
Append rows of data to a table
Read multiple ranges of values
Apply multiple updates to a spreadsheet structure/formatting
Clear values from a range
Create a new Google Spreadsheet
Delete a sheet from a spreadsheet
Read values from a specific range
Get spreadsheet metadata and sheets
Update values in a specific range
Why VS Code Copilot?
GitHub Copilot Agent mode brings Google Sheets data directly into your VS Code workflow. With a project-scoped config, the entire team shares access to 10 tools. Copilot queries live data, generates typed code, and writes tests from actual API responses, all without leaving the editor.
- —
VS Code is used by over 70% of developers. adding MCP tools to Copilot means your team can leverage external data without leaving their primary editor
- —
Project-scoped MCP configs (
.vscode/mcp.json) let you commit server configurations to your repository, ensuring the entire team shares the same tool access - —
Copilot's Agent mode integrates MCP tools seamlessly with file editing, terminal commands, and workspace search in a single agentic loop
- —
GitHub's enterprise compliance and audit features extend to MCP tool usage, providing visibility into how AI interacts with external services
Google Sheets in VS Code Copilot
Why run Google Sheets with Vinkius?
The Google Sheets connection runs on our fully managed, secure cloud infrastructure. We handle the hosting, maintenance, and security so you don't have to deal with servers or code. All 10 tools are ready to work instantly without any complex setup.
You stay in complete control of your data. Your AI only accesses the information you approve, keeping your sensitive passwords and private details completely safe. Plus, with automatic optimizations, your AI works faster and more efficiently.
* Every connection is hosted and maintained by Vinkius. We handle the security, updates, and infrastructure so you don't have to write code or manage servers. See our infrastructure
Over 4,000 integrations ready for AI agents
Explore a vast library of pre-built integrations, optimized and ready to deploy.
Connect securely in under 30 seconds
Generate tokens to authenticate and link external services in a single step.
Complete visibility into every agent action
Audit live requests, latency, success rates, and active security compliance policies.
Optimize spending and track token ROI
Analyze real-time token consumption and cost metrics detailed by connection.
Explore our live AI Agents Analytics dashboard to see it all working
This dashboard is included when you connect Google Sheets using Vinkius. You will never be left in the dark about what your AI agents are doing with your tools.
Google Sheets and 4,000+ other AI tools. No hosting, no code, ready to use.
Professionals who connect Google Sheets to VS Code Copilot through Vinkius don't need to write code, manage servers, or worry about security. Everything is pre-configured, secure, and runs automatically in the background.
Raw MCP | Vinkius | |
|---|---|---|
| Ready-to-use MCPs | Find and configure each manually | 4,000+ MCPs ready to use |
| Connection Setup | Manual coding & server setup | 1-click instant connection |
| Server Hosting | You host it yourself (needs 24/7 uptime) | 100% hosted & managed by Vinkius |
| Security & Privacy | Stored in plaintext config files | Bank-grade encrypted vault |
| Activity Visibility | Blind execution (no logs or tracking) | Live dashboard with real-time logs |
| Cost Control | Runaway AI token spend risk | Automatic budget limits |
| Revoking Access | Must delete files or code to stop | 1-click disconnect button |
How Vinkius secures
Google Sheets for VS Code Copilot
Every request between VS Code Copilot and Google Sheets is protected by our secure gateway. We automatically keep your sensitive data private, prevent unauthorized access, and let you disconnect instantly at any time.
Frequently asked questions
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.
Which VS Code version supports MCP?
MCP support requires VS Code 1.99 or later with the GitHub Copilot extension. Ensure both are updated to the latest version. Older versions of Copilot may not expose the Agent mode toggle.
How do I switch to Agent mode?
Open the Copilot Chat panel and look for two mode options: "Ask" and "Agent". Click "Agent" to enable autonomous tool calling. In Ask mode, Copilot provides conversational answers but cannot invoke MCP tools.
Can I restrict which MCP tools Copilot can access?
Yes. VS Code shows a tool consent dialog before any MCP tool is invoked for the first time. You can also configure tool access policies at the organization level through GitHub Copilot settings.
Does MCP work in VS Code Remote or Codespaces?
Yes. MCP servers configured via .vscode/mcp.json work in Remote SSH, WSL, and GitHub Codespaces environments. The MCP connection is established from the remote host, so ensure the server URL is accessible from that environment.
MCP tools not available
Ensure you are in Agent mode in Copilot Chat. MCP tools only appear in Agent mode.
Explore More MCP Servers
View all →
Elastic Email
10 toolsEquip your AI agent to manage email campaigns, track contacts, and monitor delivery logs via the Elastic Email API.
VineRadar
6 toolsSearch wine and vineyards — audit varietals and vintages via AI.
Manage your LinkedIn presence — audit organizations, posts, and profile via AI.
Qichacha / 企查查
10 toolsLeading enterprise data platform in China — search companies, check industrial info, and monitor risks via AI.