How to Use the Google Sheets MCP in CrewAI

Q: Can multiple CrewAI agents write to Google Sheets at the same time?

Yes, but to prevent conflicts, you should assign updatesheetvalues to a single writer agent while other CrewAI agents focus on reading.

Q: How do I restrict which Google Sheets tools a CrewAI agent can use?

You can use a toolfilter in your CrewAI setup to only expose reading tools like getsheetvalues to research agents while keeping write tools restricted.

Q: Can my agents format cells or change column names?

Yes, your agents can use batchupdatespreadsheet to handle structural changes and formatting across any of your sheets.

Let specialized CrewAI agent teams read, analyze, and update Google Sheets autonomously.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect Google Sheets MCP to CrewAI

Create your Vinkius account to connect Google Sheets to CrewAI and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup Google Sheets with CrewAI

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Coordinate CrewAI agents around a shared Google Sheet

CrewAI lets you run teams of specialized agents with this MCP Server. One agent can read raw data using `get_sheet_values`, a second agent analyzes it, and a third agent writes the final report back using `append_sheet_values`. This collaborative loop keeps your team in sync. By using `update_sheet_values`, your CrewAI agents can leave status updates in specific cells, signaling to other agents that a task is ready for the next step.

Let CrewAI build and clean its own workspaces

Autonomous crews need room to work. An operations agent can call `create_spreadsheet` to start a new project, then use `add_sheet` to divide tasks among different specialized agents. When the job is done and the data is archived, a cleanup agent can run `delete_sheet` or `clear_sheet_values` to remove temporary workspaces. This keeps your Google Drive organized without human intervention.

Scale your CrewAI operations with this MCP Server

Busy crews generate a lot of spreadsheet activity. To avoid rate limits, your agents can use `batch_get_values` to pull all the data they need for a run in a single request. If the crew needs to restructure a sheet, they can use `batch_update_spreadsheet` to apply formatting or rename tabs in one go. It keeps your multi-agent pipelines running smoothly.

Setup guide

Set up Google Sheets MCP in CrewAI

Prerequisites

Python 3.10+ installed
crewai package (pip install crewai)
Active Vinkius subscription with a valid endpoint token

1

Install CrewAI
Run pip install crewai to install the framework. MCP support is built-in via the mcps parameter.
2

Add the MCP URL to your agent
Pass your Vinkius endpoint directly to the mcps list. Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com. CrewAI handles tool discovery and caching automatically.
3

Kick off your crew
Create a Crew with your agent and tasks. Call crew.kickoff() — the agent will automatically invoke Google Sheets tools as needed.

crew.py

from crewai import Agent, Task, Crew

agent = Agent(
    role="Google Sheets Analyst",
    goal="Access and analyze Google Sheets data via MCP.",
    backstory="Expert analyst with direct Google Sheets access.",
    mcps=[
        "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
    ],
)

task = Task(
    description="List recent Google Sheets transactions",
    agent=agent,
    expected_output="A summary of recent activity",
)

crew = Crew(agents=[agent], tasks=[task])
result = crew.kickoff()
print(result)

Get your connection token →

Prerequisites

Python 3.10+ installed
crewai + crewai-tools packages
Active Vinkius subscription with a valid endpoint token

1

Install dependencies
Run pip install crewai crewai-tools. The MCPServerAdapter handles lifecycle management and tool conversion.
2

Connect with MCPServerAdapter
Use MCPServerAdapter as a context manager with SseServerParameters pointing to your Vinkius endpoint. The adapter automatically manages connection lifecycle.
3

Assign tools and run
Pass the returned mcp_tools to your agent's tools parameter. The adapter converts MCP tools to native BaseTool objects compatible with all CrewAI agents.

crew.py

from crewai import Agent, Task, Crew
from crewai_tools import MCPServerAdapter
from mcp import SseServerParameters

server_params = SseServerParameters(
    url="https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
)

with MCPServerAdapter(server_params) as mcp_tools:
    agent = Agent(
        role="Google Sheets Analyst",
        goal="Access and analyze Google Sheets data via MCP.",
        backstory="Expert analyst with direct Google Sheets access.",
        tools=mcp_tools,
    )

    task = Task(
        description="List recent Google Sheets transactions",
        agent=agent,
        expected_output="A summary of recent activity",
    )

    crew = Crew(agents=[agent], tasks=[task])
    result = crew.kickoff()
    print(result)

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Google Sheets. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect Google Sheets now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about Google Sheets MCP in CrewAI

Yes, but to prevent conflicts, you should assign `update_sheet_values` to a single writer agent while other CrewAI agents focus on reading.

You can use a `tool_filter` in your CrewAI setup to only expose reading tools like `get_sheet_values` to research agents while keeping write tools restricted.

Yes, you can run the MCP Server via stdio or connect over HTTP/SSE. CrewAI handles both setups easily using the Vinkius endpoint.

Yes, your agents can use `batch_update_spreadsheet` to handle structural changes and formatting across any of your sheets.

No. Vinkius runs each MCP server in an ephemeral container. Your sheet cells and tokens are strictly isolated to your active crew session and wiped immediately after.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript