Connect 
Google Sheets to 
VS Code
- Can you update the KPI doc?
https://mcp.lemonado.io/mcpAsk GitHub Copilot in VS Code to turn a targets tab into a scorecard, with live Google Sheets data in agent mode. Lemonado connects them in about 2 minutes, no API keys needed.
https://mcp.lemonado.io/mcpWhy connect Google Sheets to VS Code (GitHub Copilot)?
Copilot's agent mode can call MCP tools inside your workspace, so it can read live numbers while it edits code and docs. Connected through Lemonado, it reads your Google Sheets media plans, targets, offline sales and UTMs, so it can turn a targets tab into a scorecard with today's numbers.
All your Google Sheets data
Any tab you connect, as a table, ready to ask about.
Always today's numbers
Targets and forecasts, synced from Google Sheets automatically, so answers use today's numbers.
Connect all your tools
Questions like "Is the forecast holding?" use Google Sheets and GA4, Google Ads at once.
How to connect Google Sheets to VS Code (GitHub Copilot)
Before you start
- A Google Sheets account you can sign in to
- VS Code installed
- A Lemonado account (the free trial works)
- 1
Connect Google Sheets in Lemonado
In Lemonado, open Connectors, find Google Sheets and sign in. Choose the spreadsheets you want AI to read. Keep column names in the first row of each tab.
- 2
Turn on external access
In the company's settings, open External tools, turn the connection on, choose which sources it can reach and copy the server URL.
texthttps://mcp.lemonado.io/mcp - 3
Add the server
With AI features on and a project open, run MCP: Add Server from the command palette. Choose HTTP, paste the server URL and name it lemonado.
texthttps://mcp.lemonado.io/mcp - 4
Choose where it lives
For your personal Copilot setup, choose Global → Copilot Global. That writes to ~/.copilot/mcp-config.json unless COPILOT_HOME says otherwise.
- 5
Trust and sign in
Accept the trust prompt and sign in to Lemonado. Turn the tools on under Chat: Open Customizations → Tools.
- 6
Ask VS Code (GitHub Copilot) about Google Sheets
Try "Update the table in docs/kpis.md with last month's Google Sheets numbers and add one line on what changed." Or ask: "Which names break the rules?" or "Are the targets up to date?"
Good to know
- The older .vscode/mcp.json format still works for the local harness, but VS Code now marks that destination as deprecated. It uses a servers key with type http and the same URL.
What can VS Code (GitHub Copilot) do with Google Sheets?
Copilot reads your Google Sheets data in agent mode and works the numbers into your code, docs and notebooks in the workspace you have open.
VS Code (GitHub Copilot)Update the table in docs/kpis.md with last month's Google Sheets numbers and add one line on what changed.
Updated docs/kpis.md with last month's numbers next to the month before, plus a line on the biggest change and its cause.
Source: Google Sheets + your code
Compare the campaign names in our launch config with the naming rules sheet. Which names break the rules?
5 of 22 break them. Three are missing the market code, two use "FB" instead of "META".
Source: Google Sheets + your code
Pull the targets tab and add the numbers to the targets constant in our dashboard code.
Updated TARGETS in lib/targets.ts with 6 values from the sheet. Leads went from 900 to 1,050.
Source: Google Sheets + your code
Read the Q4 media plan sheet and save it as data/media_plan.json with one entry per channel and month.
Saved 18 entries to data/media_plan.json. Two rows had budgets typed as text, so I converted "$12k" to 12000.
Source: Google Sheets + your code
Use the Q4 media plan sheet and tell me which channels are off pace this month.
Meta is 18% over plan, LinkedIn 31% under. At this pace Meta overspends by $7,200 by month end.
Source: Google Sheets
Join our offline sales sheet with Google Ads clicks by week. Is there a lag?
Store sales follow click peaks by about 9 days. Weeks with 20% more clicks saw 12% more store sales.
Source: Google Sheets
Connect Google Sheets to another AI app.
Claude
Connect Google Sheets to Claude
ChatGPT
Connect Google Sheets to ChatGPT
Claude Code
Connect Google Sheets to Claude Code
Cursor
Connect Google Sheets to Cursor
Codex
Connect Google Sheets to Codex
Perplexity
Connect Google Sheets to Perplexity
Google Antigravity
Connect Google Sheets to Google Antigravity
Windsurf (Devin Desktop)
Connect Google Sheets to Windsurf (Devin Desktop)
Zed
Connect Google Sheets to Zed
n8n
Connect Google Sheets to n8n
Other integrations for VS Code (GitHub Copilot)
All VS Code (GitHub Copilot) integrations
Google Ads in VS Code (GitHub Copilot)Ask Claude, ChatGPT or Cursor about your Google Ads campaigns, search terms and spend.
Meta Ads in VS Code (GitHub Copilot)Ask Claude, ChatGPT or Cursor about your Facebook and Instagram ads, creatives and results.
Google Analytics in VS Code (GitHub Copilot)Ask Claude, ChatGPT or Cursor about GA4 traffic, conversions and funnels, next to your ad spend.
Google Search Console in VS Code (GitHub Copilot)Ask Claude, ChatGPT or Cursor about your search queries, rankings and lost clicks.
LinkedIn Ads in VS Code (GitHub Copilot)Ask Claude, ChatGPT or Cursor about LinkedIn campaigns, lead forms and who converts.
TikTok Ads in VS Code (GitHub Copilot)Ask Claude, ChatGPT or Cursor which TikTok videos hold attention and which ones sell.
Reading this as an AI agent?
Everything an agent needs to set this up, in plain text. Paste this page's link into VS Code and ask it to connect you, or copy the block.
# Connect Google Sheets to VS Code (Lemonado MCP) - Server URL: https://mcp.lemonado.io/mcp - Transport: Streamable HTTP - Auth: OAuth; the user signs in to Lemonado in the browser. No API keys. - In Lemonado: connect the spreadsheet. Choose the spreadsheets you want AI to read. Keep column names in the first row of each tab. - In VS Code: Command palette: MCP: Add Server ```text https://mcp.lemonado.io/mcp ``` First question to try: "Update the table in docs/kpis.md with last month's Google Sheets numbers and add one line on what changed." More: https://lemonado.io/integrations/google-sheets · https://lemonado.io/llms.txt
Frequently Asked Questions
Yes, through Lemonado. Connect your spreadsheet in Lemonado, add Lemonado with MCP: Add Server in VS Code, and VS Code can turn a targets tab into a scorecard with your live data.
Run MCP: List Servers from the command palette. If lemonado isn't running, start it there, accept the trust prompt and sign in. In Lemonado, check that Google Sheets is connected and External tools is on for the company. If a tab is missing, check it's in a spreadsheet you connected and that the Google account you used can open it.
Yes, if both are connected in Lemonado. One connection reaches every source you allow, so you can ask things like "Compare the revenue forecast sheet with actual Stripe revenue so far this quarter."
MCP is included in Lemonado's paid plans and in the free trial, so you can try it before you pay.
Still have a question?
Shoot us an email at hello@lemonado.io.
Try for freeStop fighting with data. Start feeding your AI.
Connect your data to AI and free your team from reporting and busywork.
Try Lemonado free