Google Sheets MCP Server
by CDataSoftware
This project provides a read-only Model Context Protocol (MCP) server for Google Sheets, enabling LLMs to query live data through a simple interface. It leverages the CData JDBC Driver for Google Sheets to expose Google Sheets data as relational SQL models.
Last updated: N/A
What is Google Sheets MCP Server?
The Google Sheets MCP Server is a read-only server that allows Large Language Models (LLMs) to query live data from Google Sheets. It wraps the CData JDBC Driver for Google Sheets and makes the data available through a simple MCP interface, enabling natural language queries.
How to use Google Sheets MCP Server?
To use the server, clone the repository, build the server using Maven, download and license the CData JDBC Driver for Google Sheets, configure the connection to Google Sheets using the Connection String utility, create a .prp file with connection properties, and configure your AI client (e.g., Claude Desktop) to use the server by adding it to the client's configuration file.
Key features of Google Sheets MCP Server
Read-only access to Google Sheets data
MCP interface for LLM integration
Leverages CData JDBC Driver for Google Sheets
Supports natural language queries
Easy setup and configuration
Use cases of Google Sheets MCP Server
Answering questions about data in Google Sheets using natural language
Retrieving live information from Google Sheets within an LLM environment
Integrating Google Sheets data with AI clients
Building applications that leverage Google Sheets data through natural language queries
FAQ from Google Sheets MCP Server
How do I license the CData JDBC Driver?
How do I license the CData JDBC Driver?
Navigate to the lib
folder in the installation directory and run the command java -jar cdata.jdbc.googlesheets.jar --license
. Enter your name, email, and 'TRIAL' (or your license key).
How do I configure the connection to Google Sheets?
How do I configure the connection to Google Sheets?
Run the command java -jar cdata.jdbc.googlesheets.jar
to open the Connection String utility. Configure the connection string and click 'Test Connection'. Copy the connection string for use in the .prp file.
What properties are required in the .prp file?
What properties are required in the .prp file?
The .prp file requires properties such as Prefix, ServerName, ServerVersion, DriverPath, DriverClass, JdbcUrl, and Tables.
How do I add the MCP server to Claude Desktop?
How do I add the MCP server to Claude Desktop?
Create or modify the claude_desktop_config.json
file to include the new MCP server configuration, specifying the command and arguments to run the server.
What if I can't see the CData MCP Server in Claude Desktop?
What if I can't see the CData MCP Server in Claude Desktop?
Ensure you have fully quit Claude Desktop (using Task Manager on Windows or Activity Monitor on Mac) and re-opened it.