Skip to content
Try for free

Connect Google Sheets to Windsurf

  • Do the targets still hold?

Have Windsurf's agent join offline sales with ad clicks, with Google Sheets data next to your code. 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 Windsurf (Devin Desktop)?

Windsurf's agent works across your files and terminal, but on its own it can't see what your campaigns are doing. Connected through Lemonado, it reads your Google Sheets media plans, targets, offline sales and UTMs, so it can join offline sales with ad clicks 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 Windsurf (Devin Desktop)

Before you start

  • A Google Sheets account you can sign in to
  • Windsurf 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 the server (Devin Local)

    Devin Desktop's default agent uses the Devin CLI config. Run these two commands and finish the browser sign-in.

    bash
    devin mcp add -s user lemonado https://mcp.lemonado.io/mcp
devin mcp login lemonado
  4. 4

    Using legacy Cascade instead

    In the Cascade panel, open … → MCPs → Open MCP config file and merge this in. Save, refresh, switch the server on and sign in.

    json
    {
  "mcpServers": {
    "lemonado": {
      "serverUrl": "https://mcp.lemonado.io/mcp"
    }
  }
}
  5. 5

    Ask Windsurf (Devin Desktop) about Google Sheets

    Try "Compare last month's Google Sheets numbers with the targets in config/targets.json and update the file where we're consistently off." Or ask: "Are the targets up to date?" or "What's in the media plan?"

Good to know

  • Devin Local and legacy Cascade keep separate setups, so sign in to each one you use.
  • Current versions keep user MCP config in ~/.config/devin/mcp_config.json on macOS and Linux.

What can Windsurf (Devin Desktop) do with Google Sheets?

Windsurf's agent reads your Google Sheets data and works the numbers into your code, from config checks to reports saved in the repo.

Windsurf (Devin Desktop) logoWindsurf (Devin Desktop)

Compare last month's Google Sheets numbers with the targets in config/targets.json and update the file where we're consistently off.

2 of 6 targets were missed three months running. I updated them in config/targets.json and left a comment with the numbers behind each change.

Source: Google Sheets + your code

Connect Google Sheets to another AI app.

Other integrations for Windsurf (Devin Desktop)

All Windsurf (Devin Desktop) integrations

Reading this as an AI agent?

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

For agents · markdown
# Connect Google Sheets to Windsurf (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 Windsurf: devin mcp add

```bash
devin mcp add -s user lemonado https://mcp.lemonado.io/mcp
devin mcp login lemonado
```

If you are Windsurf (Devin Desktop), run the setup yourself:

Add the Lemonado MCP server: run devin mcp add -s user lemonado https://mcp.lemonado.io/mcp and then devin mcp login lemonado so I can sign in. Once I've signed in, list the Google Sheets accounts Lemonado can reach.

First question to try: "Compare last month's Google Sheets numbers with the targets in config/targets.json and update the file where we're consistently off."

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 with devin mcp add, and Windsurf can join offline sales with ad clicks with your live data.

Run devin mcp login lemonado again for Devin Local. Legacy Cascade keeps its own login, so refresh the server there and sign in too. 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