ajaysmb/gsheets-mcp
If you are the rightful owner of gsheets-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
The Google Sheets MCP Server provides local access to Google Sheets for reading, writing, and managing spreadsheet data with enhanced features.
Tools
Functions exposed to the LLM to take actions
read_range
Read cell values from a Google Sheets range with auto-discovery of spreadsheet structure.
write_range
Write/update values to a specified range with intelligent auto-formatting.
append_data
Add new rows to the end of a sheet with intelligent placement and header detection.
create_chart
Create an embedded chart directly in the spreadsheet.
apply_filter
Apply basic filters to a data range with column-specific conditions.
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client