Skip to content
Try for free

Connect Google Sheets to Claude Code

  • Do offline sales lag clicks?

Read and join Google Sheets data in Claude Code, from media plans to offline sales, without the Sheets API. 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 Claude Code?

Spreadsheets hold the plans and offline numbers, and the Sheets API is a pain to set up for a one-off script. Claude Code reads the sheet through Lemonado, joins it with ad data and writes the result into your project.

  • 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 Claude Code

Before you start

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

    With Claude Code installed, run one of these in your terminal. Most people want the first: it adds Lemonado to every project.

    bash
    # every project (recommended)
claude mcp add --scope user --transport http lemonado https://mcp.lemonado.io/mcp

# this project only
claude mcp add --transport http lemonado https://mcp.lemonado.io/mcp
  4. 4

    Sign in

    Start Claude Code with claude and run /mcp. Choose Lemonado and finish the sign-in in your browser.

    bash
    claude
/mcp
  5. 5

    Ask Claude Code about Google Sheets

    Ask a question about the accounts your connection can reach. Claude Code can also write the numbers into a file or a script for you. Try "Read the offline sales tab, join it with Google Ads clicks by week and save the result as data/offline_vs_clicks.csv with a lag column." Or ask: "Are the targets up to date?" or "What's in the media plan?"

Good to know

  • The command uses Claude Code's default local scope. Use --scope user to share the server across projects.

What can Claude Code do with Google Sheets?

Claude Code queries your Google Sheets data while it works in your repo: it saves data as files, checks tracking against code and runs headless with claude -p.

Claude Code logoClaude Code

Read the offline sales tab, join it with Google Ads clicks by week and save the result as data/offline_vs_clicks.csv with a lag column.

Saved 52 weeks to data/offline_vs_clicks.csv. Offline sales follow clicks with a 2-week lag (correlation 0.71 at 2 weeks vs 0.38 in the same week).

Source: Google Sheets + your code

Connect Google Sheets to another AI app.

Other integrations for Claude Code

All Claude Code integrations

Reading this as an AI agent?

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

For agents · markdown
# Connect Google Sheets to Claude 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 Claude Code: Terminal: claude mcp add

```bash
# every project (recommended)
claude mcp add --scope user --transport http lemonado https://mcp.lemonado.io/mcp

# this project only
claude mcp add --transport http lemonado https://mcp.lemonado.io/mcp
```

If you are Claude Code, run the setup yourself:

Add the Lemonado MCP server for all my projects by running: claude mcp add --scope user --transport http lemonado https://mcp.lemonado.io/mcp
Then tell me to run /mcp and sign in to Lemonado. Once I've signed in, list the Google Sheets accounts Lemonado can reach.

First question to try: "Read the offline sales tab, join it with Google Ads clicks by week and save the result as data/offline_vs_clicks.csv with a lag column."

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

Frequently Asked Questions

Yes. You sign in to Google once in Lemonado, and Claude Code reads the spreadsheets you've connected through the Lemonado server. No service account, credentials.json or Sheets API quota to manage.

Run claude mcp list to see whether lemonado is connected. If it needs authentication, run /mcp inside Claude Code 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