Google Sheets MCP Server
Provides tools to create, read, update, and manage Google Sheets spreadsheets, including batch operations and data filtering.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Google Sheets MCP ServerCreate a spreadsheet called 'Meeting Notes' and add a header row."
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Google Sheets
A Model Context Protocol (MCP) server that provides Google Sheets integration for AI assistants like Claude.
Tools
create_spreadsheet: Creates a spreadsheet
get_spreadsheet: Gets a spreadsheet by ID
list_spreadsheets: Lists the user's spreadsheets
get_filtered_spreadsheet: Retrieve a spreadsheet or specific ranges using data filters, with optional grid data.
batch_update_spreadsheet: Applies batch updates to a spreadsheet
copy_sheet_to: Copies a sheet to another spreadsheet
append_values: Appends values to a spreadsheet
get_values: Gets values from a spreadsheet
update_values: Updates values in a spreadsheet
clear_values: Clears values from a spreadsheet
batch_get_values: Gets values from a spreadsheet using batch get
batch_update_values: Updates values in a spreadsheet using batch update
batch_clear_values: Clears values from a spreadsheet using batch clear
batch_get_values_by_data_filter: Gets values from a spreadsheet using batch get by data filter
batch_update_values_by_data_filter: Updates values in a spreadsheet using batch update by data filter
batch_clear_values_by_data_filter: Clears values from a spreadsheet using batch clear by data filter
This server cannot be deployed
Maintenance
Related MCP Connectors
Connect AI assistants to Google Sheets through controlled tools for reading and updating rows.
Create and manage documents, spreadsheets, and presentations from your AI assistant.
AI access to Quadratic spreadsheets: open files, run Python/SQL, query connected databases.
Open, inspect, filter, edit and convert xlsx and csv files from your AI chat. Processing is local.
Related MCP Servers
- AlicenseNot gradedqualityFmaintenanceEnables AI assistants to interact with Google Sheets for reading, writing, and managing spreadsheets through a set of MCP tools.MIT
- AlicenseNot gradedqualityDmaintenanceEnables AI assistants to interact with Google Sheets via natural language, supporting CRUD operations, listing, sharing, and batch updates.MIT
- AlicenseNot gradedqualityDmaintenanceEnables AI agents to read, write, and manage Google Sheets using the Google Sheets API v4.MIT
- FlicenseNot gradedqualityBmaintenanceEnables AI agents to read, write, and format Google Sheets using the Google Sheets API v4.1-