Skip to content
Try for free

Connect Google Sheets to AAntigravity

  • Can you build a page for it?

Have Antigravity's agents use your Google Sheets data to turn a targets tab into a scorecard, right in your editor, terminal and browser. Lemonado connects them in about 2 minutes, no API keys needed.

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

Why connect Google Sheets to Google Antigravity?

Antigravity's agents plan and run tasks across your editor, terminal and browser, and can hand you the result to review. 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 Google Antigravity

Before you start

  • A Google Sheets account you can sign in to
  • Antigravity 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

    Open the raw MCP config

    In the agent panel, open … → MCP Servers → Manage MCP Servers → View raw config. That's ~/.gemini/config/mcp_config.json globally, or .agents/mcp_config.json for a workspace.

  4. 4

    Add Lemonado

    Merge this in. Remote servers use serverUrl.

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

    Authenticate

    Refresh the servers, then choose Authenticate beside Lemonado under Settings → Customizations. If you're shown a code, paste it back. In the Antigravity CLI, use /mcp.

  6. 6

    Ask Google Antigravity about Google Sheets

    Try "Build a small internal page that charts last quarter's Google Sheets numbers by week, then open it in the browser to check it." Or ask: "Which names break the rules?" or "Are the targets up to date?"

What can Google Antigravity do with Google Sheets?

Antigravity's agents read your Google Sheets data while they build: a page that charts the numbers, a check on your tracking, a report in the repo.

AGoogle Antigravity

Build a small internal page that charts last quarter's Google Sheets numbers by week, then open it in the browser to check it.

Built the page with real weekly numbers and checked it renders. The biggest weekly change is labeled on the chart.

Source: Google Sheets + your code

Connect Google Sheets to another AI app.

Other integrations for Google Antigravity

All Google Antigravity integrations

Reading this as an AI agent?

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

For agents · markdown
# Connect Google Sheets to Antigravity (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 Antigravity: MCP Servers → View raw config

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

If you are Google Antigravity, run the setup yourself:

Add the Lemonado MCP server to my global MCP config (~/.gemini/config/mcp_config.json). Merge in: {"mcpServers":{"lemonado":{"serverUrl":"https://mcp.lemonado.io/mcp"}}}
Then tell me to refresh MCP servers and choose Authenticate next to Lemonado. Once I've signed in, list the Google Sheets accounts Lemonado can reach.

First question to try: "Build a small internal page that charts last quarter's Google Sheets numbers by week, then open it in the browser to check it."

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 in Antigravity's MCP config, and Antigravity can turn a targets tab into a scorecard with your live data.

Open Manage MCP Servers, refresh, and choose Authenticate next to Lemonado if it isn't signed 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.

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