vanman2024/google-sheets-mcp
If you are the rightful owner of google-sheets-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 dayong@mcphub.com.
A FastMCP server providing comprehensive Google Sheets operations including formulas, formatting, charts, data validation, and more.
Tools
Functions exposed to the LLM to take actions
sheets_create
Create new spreadsheets
sheets_read
Read data from ranges
sheets_write
Write data with formula support
sheets_append
Append rows to sheets
sheets_get_sheet_id
Get sheet ID by name
sheets_delete_rows
Delete rows
sheets_insert_rows
Insert blank rows
sheets_clear_range
Clear cell contents
sheets_find_replace
Find and replace text
sheets_duplicate_sheet
Duplicate sheets
sheets_delete_duplicates
Remove duplicate rows
sheets_trim_whitespace
Clean cell whitespace
sheets_merge_cells
Merge cell ranges
sheets_copy_paste
Copy and paste ranges
sheets_format_cells
Apply formatting
sheets_add_borders
Add cell borders
sheets_add_chart
Create charts
sheets_add_dropdown
Add dropdown lists
sheets_conditional_format
Apply conditional formatting
sheets_sort_range
Sort data ranges
Prompts
Interactive templates invoked by user choice
No prompts
Resources
Contextual data attached and managed by the client