Create powerful collaborative AI workflows by connecting multiple MCP servers including Google Sheets, Confluence, Klavis ReportGen 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
Confluence is a team workspace where knowledge and collaboration meet
Generate visually appealing JavaScript web reports from search queries with Klavis AI.
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,
)
confluence_mcp_instance = klavis_client.mcp_server.create_server_instance(
server_name=McpServerName.CONFLUENCE,
user_id="1234",
platform_name="Klavis",
connection_type=ConnectionType.STREAMABLE_HTTP,
)
klavis_reportgen_mcp_instance = klavis_client.mcp_server.create_server_instance(
server_name=McpServerName.KLAVIS_REPORTGEN,
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)
confluence_tools = MCPServerAdapter(confluence_mcp_instance.server_params)
klavis_reportgen_tools = MCPServerAdapter(klavis_reportgen_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
)
confluence_agent = Agent(
role="Confluence Specialist",
goal="Handle all Confluence related tasks and data processing",
backstory="You are an expert in Confluence operations and data analysis",
tools=confluence_tools,
reasoning=True,
verbose=False
)
klavis_reportgen_agent = Agent(
role="Klavis ReportGen Specialist",
goal="Handle all Klavis ReportGen related tasks and data processing",
backstory="You are an expert in Klavis ReportGen operations and data analysis",
tools=klavis_reportgen_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=confluence_agent,
markdown=True
)
# Create multi-agent crew
multi_agent_crew = Crew(
agents=[google_sheets_agent, confluence_agent, klavis_reportgen_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