Enables AI agents to seamlessly interact with Google Sheets via Model Context Protocol, offering comprehensive spreadsheet management including reading, editing, creating, and organizing sheets and data.
Unlock the full potential of Google Sheets MCP through LangDB's AI Gateway. Get enterprise-grade security, analytics, and seamless integration with zero configuration.
Free tier available • No credit card required
A Model Context Protocol (MCP) connector for Google Sheets that allows AI agents to interact with spreadsheets directly.
https://github.com/user-attachments/assets/cc4729d9-4e6e-437b-848b-6da9a09418c3
git clone https://github.com/mkummer225/google-sheets-mcp cd google-sheets-mcp
Install dependencies:
npm install
Build:
npm run build
Create OAuth credentials in Google Cloud Platform:
gcp-oauth.keys.json
in the dist
subdirectoryStart the MCP server (you'll automatically be prompted to authenticate/re-authenticate your Google account when necessary):
npm run start
Sample config:
{ "mcpServers": { "google-sheets-mcp": { "command": "node", "args": [ "/{path_to_dir}/google-sheets-mcp/dist/index.js" ] } } }
Then you should be able to simply specify your spreadsheetId or ask your agent to create a new one for you.
Action | Description |
---|---|
refresh_auth | Re-authenticate your Google Account when credentials expire |
list_sheets | List all sheets/tabs in a Google Spreadsheet |
create_sheet | Create a new sheet/tab in a Google Spreadsheet |
create_spreadsheet | Create a new Google Spreadsheet |
read_all_from_sheet | Read all data from a specified sheet |
read_headings | Read the column headings from a sheet |
read_rows | Read specific rows from a sheet |
read_columns | Read specific columns from a sheet |
edit_cell | Edit a single cell in a sheet |
edit_row | Edit an entire row in a sheet |
edit_column | Edit an entire column in a sheet |
insert_row | Insert a new row at specified position |
insert_column | Insert a new column at specified position |
rename_sheet | Rename a sheet/tab in a spreadsheet |
rename_doc | Rename a Google Spreadsheet |
MIT
Discover shared experiences
Shared threads will appear here, showcasing real-world applications and insights from the community. Check back soon for updates!