Create powerful collaborative AI workflows by connecting multiple MCP servers including Google Sheets, OneDrive for enhanced multi-agent automation capabilities in Klavis AI.
Google Sheets is a web-based spreadsheet application that allows users to create, edit, and collaborate on spreadsheets online
OneDrive is a file hosting service and synchronization service operated by Microsoft
Follow these steps to connect CrewAI to these MCP servers
Sign up for KlavisAI to access our MCP server management platform.
Set up your CrewAI agents with your desired MCP servers tools and configure authentication settings for collaborative workflows.
Test your multi-agent workflows and start using your enhanced collaborative AI capabilities.
import os
from crewai import Agent, Task, Crew, Process
from crewai_tools import MCPServerAdapter
from klavis import Klavis
from klavis.types import McpServerName, ConnectionType
# Initialize clients
klavis_client = Klavis(api_key=os.getenv("KLAVIS_API_KEY"))
google_sheets_mcp_instance = klavis_client.mcp_server.create_server_instance(
server_name=McpServerName.GOOGLE_SHEETS,
user_id="1234",
platform_name="Klavis",
connection_type=ConnectionType.STREAMABLE_HTTP,
)
onedrive_mcp_instance = klavis_client.mcp_server.create_server_instance(
server_name=McpServerName.ONEDRIVE,
user_id="1234",
platform_name="Klavis",
connection_type=ConnectionType.STREAMABLE_HTTP,
)
# Initialize MCP tools for each server
google_sheets_tools = MCPServerAdapter(google_sheets_mcp_instance.server_params)
onedrive_tools = MCPServerAdapter(onedrive_mcp_instance.server_params)
# Create specialized agents for each service
google_sheets_agent = Agent(
role="Google Sheets Specialist",
goal="Handle all Google Sheets related tasks and data processing",
backstory="You are an expert in Google Sheets operations and data analysis",
tools=google_sheets_tools,
reasoning=True,
verbose=False
)
onedrive_agent = Agent(
role="OneDrive Specialist",
goal="Handle all OneDrive related tasks and data processing",
backstory="You are an expert in OneDrive operations and data analysis",
tools=onedrive_tools,
reasoning=True,
verbose=False
)
# Define collaborative tasks
research_task = Task(
description="Gather comprehensive data from all available sources",
expected_output="Raw data and initial findings from all services",
agent=google_sheets_agent,
markdown=True
)
analysis_task = Task(
description="Analyze and synthesize the gathered data",
expected_output="Comprehensive analysis with insights and recommendations",
agent=onedrive_agent,
markdown=True
)
# Create multi-agent crew
multi_agent_crew = Crew(
agents=[google_sheets_agent, onedrive_agent],
tasks=[research_task, analysis_task],
verbose=False,
process=Process.sequential
)
result = multi_agent_crew.kickoff()
Everything you need to know about connecting CrewAI to these MCP servers
Join developers who are already using KlavisAI to power their CrewAI multi-agent systems with these MCP servers.
Start For Free