Connectto Google Sheets, Salesforce, Gong MCP Servers
Create powerful AI workflows by connecting multiple MCP servers including Google Sheets, Salesforce, Gong for enhanced automation capabilities in Klavis AI.
Google Sheets
Google Sheets is a web-based spreadsheet application that allows users to create, edit, and collaborate on spreadsheets online
Available Tools:
- google_sheets_create_spreadsheet
- google_sheets_get_spreadsheet
- google_sheets_write_to_cell
- +1 more tools
Salesforce
Salesforce is the world's leading customer relationship management (CRM) platform that helps businesses connect with customers, partners, and potential customers
Available Tools:
- salesforce_query
- salesforce_tooling_query
- salesforce_describe_object
- +2 more tools
Gong
Gong is a revenue intelligence platform that captures and analyzes all revenue-related interactions to help sales teams close more deals. It provides conversation analytics, deal insights, and sales performance tracking through call recordings and transcripts
Available Tools:
- gong_get_transcripts_by_user
- gong_get_extensive_data
- gong_get_call_transcripts
- +2 more tools
Quick Setup Guide
Follow these steps to connect OpenAI to these MCP servers
Create Your Account
Sign up for KlavisAI to access our MCP server management platform.
Configure Connections
Add your desired MCP servers to OpenAI and configure authentication settings.
Test & Deploy
Verify your connections work correctly and start using your enhanced AI capabilities.
OpenAI + KlavisAI Integration Snippets
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,
)
salesforce_mcp_instance = klavis_client.mcp_server.create_server_instance(
server_name=McpServerName.SALESFORCE,
user_id="1234",
platform_name="Klavis",
connection_type=ConnectionType.STREAMABLE_HTTP,
)
gong_mcp_instance = klavis_client.mcp_server.create_server_instance(
server_name=McpServerName.GONG,
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,
)
salesforce_tools = klavis_client.mcp_server.list_tools(
server_url=salesforce_mcp_instance.server_url,
connection_type=ConnectionType.STREAMABLE_HTTP,
format=ToolFormat.OPENAI,
)
gong_tools = klavis_client.mcp_server.list_tools(
server_url=gong_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(salesforce_tools)
all_tools.extend(gong_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
)Frequently Asked Questions
Everything you need to know about connecting to these MCP servers
Ready to Get Started?
Join developers who are already using KlavisAI to power their OpenAI applications with these MCP servers.
Start For Free