Connect Google Sheets to VS Code
To use Google Sheets in VS Code, connect your Google Sheets account in Manyplug and add Manyplug to VS Code once. VS Code then gets 8 Google Sheets tools, for example: “Find spreadsheets”, “Spreadsheet structure”, and “Read cells”. It takes about 3 minutes and works on the free plan.
Connect Google Sheets Free plan, no card
1. Connect Google Sheets in Manyplug
Click “Connect Google Sheets” and sign in on Google Sheets’s own page. Manyplug never sees your password.
2. Add Manyplug to VS Code
GitHub Copilot in agent mode.
- Click “Install in VS Code” or add the server to .vscode/mcp.json.
{ "servers": { "manyplug": { "type": "http", "url": "https://manyplug.com/mcp" } } } - Start the server in the MCP list and sign in when VS Code asks.
3. Ask VS Code
- Find the “Budget 2027” spreadsheet and show the monthly totals.
- Add a row to Leads: ACME, Anna Smith, anna@acme.com, today.
- How many orders on the October sheet are marked Paid?
- Create a “Content plan” spreadsheet with columns Date, Topic, Channel, Owner.
What VS Code can do in Google Sheets
Each action can be turned off per account, and changes can wait for your OK.
| Action | Access |
|---|---|
| Find spreadsheets Finds spreadsheets by name. | Reads |
| Spreadsheet structure Sheets of a spreadsheet and their sizes. | Reads |
| Read cells Reads a range as rows. | Reads |
| Write cells Writes values into a range. | Makes changes |
| Append rows Adds rows after the last filled one. | Makes changes |
| Clear cells Erases the values in a range. | Risky |
| Create a spreadsheet Creates a spreadsheet, optionally with headers. | Makes changes |
| Add a sheet Adds a sheet to a spreadsheet. | Makes changes |
Questions
Can I connect two Google Sheets accounts to VS Code?
Yes. Connect each one in Manyplug under its own name, for example Work and Personal. VS Code can use one of them or all at once.
Will VS Code change anything in Google Sheets without asking?
By default these actions wait for your approval before they run: “Clear cells”. Other changes follow your rules, which you can make stricter per account.
Do I need an official Google Sheets MCP server for this?
No. Manyplug connects to Google Sheets itself (you sign in on Google Sheets’s page) and gives VS Code the tools through one MCP address, together with your other services.
Is it free to connect VS Code to Manyplug?
Yes. New workspaces get 14 days of Pro free, then the free plan keeps going with 150 actions a month and up to 3 connected accounts. No card needed. Paid plans start at $5 a month.
Does VS Code see my passwords or API keys?
No. Keys are entered on Manyplug’s own pages, stored encrypted with a separate key per account, and the AI only receives tool results.