Skip to content
Try for free

Connect Google Sheets to Zed

  • Can you draft the notes?

In Zed's Agent panel, ask the agent to check spend against the media plan, with your Google Sheets data next to the files you're editing. Lemonado connects them in about 1 minute, no API keys needed.

Try free with $150 in creditsJump to the steps
MCPhttps://mcp.lemonado.io/mcp

Why connect Google Sheets to Zed?

Zed's Agent panel can call MCP servers, which Zed calls context servers, while it edits your files. Connected through Lemonado, it reads your Google Sheets media plans, targets, offline sales and UTMs, so it can check spend against the media plan 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 Zed

Before you start

  • A Google Sheets account you can sign in to
  • Zed installed
  • A Lemonado account (the free trial works)
  1. 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. 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.

    text
    https://mcp.lemonado.io/mcp
  3. 3

    Add a remote server

    Open Settings → AI → MCP Servers → Add Server → Add Remote Server. Or merge this into settings.json.

    json
    {
  "context_servers": {
    "lemonado": {
      "url": "https://mcp.lemonado.io/mcp"
    }
  }
}
  4. 4

    Sign in

    Finish the Lemonado sign-in in your browser, then use the tools from the Agent panel.

  5. 5

    Ask Zed about Google Sheets

    Try "Draft this week's Google Sheets notes in notes/weekly.md from the live numbers." Or ask: "What's in the media plan?" or "Which names break the rules?"

What can Zed do with Google Sheets?

Zed's agent reads your Google Sheets data from the Agent panel and writes the numbers into the notes, docs or code you have open.

Zed logoZed

Draft this week's Google Sheets notes in notes/weekly.md from the live numbers.

Drafted notes/weekly.md: the headline numbers, what changed from last week and two things to look at next.

Source: Google Sheets + your code

Connect Google Sheets to another AI app.

Other integrations for Zed

All Zed integrations

Reading this as an AI agent?

Everything an agent needs to set this up, in plain text. Paste this page's link into Zed and ask it to connect you, or copy the block.

For agents · markdown
# Connect Google Sheets to Zed (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 Zed: Settings → AI → MCP Servers

```json
{
  "context_servers": {
    "lemonado": {
      "url": "https://mcp.lemonado.io/mcp"
    }
  }
}
```

If you are Zed, run the setup yourself:

Add Lemonado as a remote context server in my Zed settings.json. Merge in: {"context_servers":{"lemonado":{"url":"https://mcp.lemonado.io/mcp"}}}
Then tell me to finish the Lemonado sign-in in the browser. Once I've signed in, list the Google Sheets accounts Lemonado can reach.

First question to try: "Draft this week's Google Sheets notes in notes/weekly.md from the live numbers."

More: https://lemonado.io/integrations/google-sheets · https://lemonado.io/llms.txt
FAQ

Frequently Asked Questions

Yes, through Lemonado. Connect your spreadsheet in Lemonado, add Lemonado as a context server in Zed, and Zed can check spend against the media plan with your live data.

Open the Agent panel settings and check the lemonado server's status dot. If it isn't green, restart the server and sign in again. 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.

See plans and pricing

Still have a question?

Shoot us an email at hello@lemonado.io.

Try for free

Stop fighting with data. Start feeding your AI.

Connect your data to AI and free your team from reporting and busywork.

Try Lemonado free