Build a Google Sheets Analysis Agent with MCP

{
  "google-sheets": {
    "command": "uvx",
    "args": ["mcp-google-sheets@latest"],
    "env": {
      "CREDENTIALS_PATH": "C:\\Users\\your-username\\.gmail-mcp\\gcp-oauth.keys.json",
      "TOKEN_PATH": "C:\\Users\\your-username\\.gmail-mcp\\token.json"
    },
    "transport": "stdio"
  },
  "yahoo-finance": {
    "command": "uvx",
    "args": ["yahoo-finance-mcp-server"],
    "transport": "stdio"
  }
}

import sys
import os

root_dir = os.path.dirname(os.path.dirname(os.path.dirname(os.path.abspath(__file__))))
sys.path.append(root_dir)

from dotenv import load_dotenv
load_dotenv()

from langchain_google_genai import ChatGoogleGenerativeAI
from langchain.agents import create_agent
from langchain.messages import HumanMessage
from langgraph.checkpoint.memory import InMemorySaver
from langchain_mcp_adapters.client import MultiServerMCPClient
import asyncio

from scripts import base_tools, prompts, utils

if sys.platform == "win32":
    sys.stdout.reconfigure(encoding="utf-8")

model = ChatGoogleGenerativeAI(model="gemini-2.5-flash")
checkpointer = InMemorySaver()

async def get_tools():
    mcp_config = utils.load_mcp_config("google-sheets", "yahoo-finance")
    client = MultiServerMCPClient(mcp_config)

    mcp_tools = await client.get_tools()
    tools = mcp_tools + [base_tools.web_search, base_tools.get_weather]

    # Filter tools that don't work well with Gemini
    problematic_tools = ['update_cells']
    safe_tools = [tool for tool in tools if tool.name not in problematic_tools]

    print(f"Loaded {len(safe_tools)} Tools")
    print(f"Tools Available\n{[tool.name for tool in safe_tools]}")
    return safe_tools

GOOGLE_SHEETS_PROMPT = """You are a helpful Google Sheets assistant.

You have access to Google Sheets tools. When the user asks about spreadsheets:
- Use the list_spreadsheets tool to list all spreadsheets
- Use get_sheet_data to read sheet data
- Use create_spreadsheet to create new sheets

IMPORTANT: You MUST use the available tools to complete user requests.
Do not try to answer without using tools."""

async def google_sheet_agent(query, thread_id="default"):
    tools = await get_tools()

    agent = create_agent(model=model,
                         tools=tools,
                         system_prompt=prompts.GOOGLE_SHEETS_PROMPT,
                         checkpointer=checkpointer)

    config = {"configurable": {"thread_id": thread_id}}
    result = await agent.ainvoke({'messages': [HumanMessage(query)]}, config=config)

    response = result['messages'][-1].text
    print("\n============== Output =============")
    print(response)


async def ask():
    print("\nChat mode started. Type 'q' or 'quite' to exit.\n")
    while True:
        query = input("You: ").strip()
        if query.lower() in ["q", "quite"]:
            print("Exiting chat mode.")
            break
        await google_sheet_agent(query)


if __name__ == "__main__":
    asyncio.run(ask())

python "03 AI Projects/04_gsheet_analysis_agent/gsheet_analysis_agent.py"

You: list all my spreadsheets

Loaded 12 Tools
Tools Available
['list_spreadsheets', 'get_sheet_data', 'create_spreadsheet', ..., 'get_stock_info', 'web_search', 'get_weather']

============== Output =============
Here are the spreadsheets in your Google Drive:
1. Portfolio Tracker
2. Monthly Budget
3. Sales Q1 2024

You: read the Portfolio Tracker sheet and compare my holdings to today's prices

============== Output =============
Your Portfolio Tracker holds AAPL, MSFT, and GOOGL. Using live Yahoo Finance data:
- AAPL: bought at $180, now ~$260 (+44%)
- MSFT: bought at $410, now ~$462 (+13%)
- GOOGL: bought at $140, now ~$165 (+18%)
Overall your tracked holdings are up across the board.