Create powerful AI workflows by connecting multiple MCP servers including Google Sheets, Dropbox, Hacker News for enhanced automation capabilities in Klavis AI.
Google Sheets is a web-based spreadsheet application that allows users to create, edit, and collaborate on spreadsheets online
Complete file management solution for Dropbox cloud storage. Upload, download, organize files and folders, manage sharing and collaboration, handle file versions, create file requests, and perform batch operations on your Dropbox files and folders
Access the latest tech news, discussions, and stories from Hacker News. Fetch top stories, newest posts, best stories, show HN posts, ask HN posts, job listings, and user profiles from the popular tech community platform
Follow these steps to connect OpenAI to these MCP servers
Sign up for KlavisAI to access our MCP server management platform.
Add your desired MCP servers to OpenAI and configure authentication settings.
Verify your connections work correctly and start using your enhanced AI capabilities.
import json
import os
from openai import OpenAI
from klavis import Klavis
from klavis.types import McpServerName, ConnectionType, ToolFormat
# Initialize clients
openai_client = OpenAI(api_key=os.getenv("OPENAI_API_KEY"))
klavis_client = Klavis(api_key=os.getenv("KLAVIS_API_KEY"))
# Constants
OPENAI_MODEL = "gpt-4o-mini"
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,
)
dropbox_mcp_instance = klavis_client.mcp_server.create_server_instance(
server_name=McpServerName.DROPBOX,
user_id="1234",
platform_name="Klavis",
connection_type=ConnectionType.STREAMABLE_HTTP,
)
hacker_news_mcp_instance = klavis_client.mcp_server.create_server_instance(
server_name=McpServerName.HACKER_NEWS,
user_id="1234",
platform_name="Klavis",
connection_type=ConnectionType.STREAMABLE_HTTP,
)
# Get tools from all MCP servers
google_sheets_tools = klavis_client.mcp_server.list_tools(
server_url=google_sheets_mcp_instance.server_url,
connection_type=ConnectionType.STREAMABLE_HTTP,
format=ToolFormat.OPENAI,
)
dropbox_tools = klavis_client.mcp_server.list_tools(
server_url=dropbox_mcp_instance.server_url,
connection_type=ConnectionType.STREAMABLE_HTTP,
format=ToolFormat.OPENAI,
)
hacker_news_tools = klavis_client.mcp_server.list_tools(
server_url=hacker_news_mcp_instance.server_url,
connection_type=ConnectionType.STREAMABLE_HTTP,
format=ToolFormat.OPENAI,
)
# Combine all tools
all_tools = []
all_tools.extend(google_sheets_tools)
all_tools.extend(dropbox_tools)
all_tools.extend(hacker_news_tools)
messages = [
{"role": "system", "content": "You are a helpful assistant."},
{"role": "user", "content": user_message}
]
response = openai_client.chat.completions.create(
model=OPENAI_MODEL,
messages=messages,
tools=all_tools if all_tools else None
)
Everything you need to know about connecting to these MCP servers
Join developers who are already using KlavisAI to power their OpenAI applications with these MCP servers.
Start For Free