> mcp // google workspace
Google Sheets
for AI.
MCP server enabling Claude to read, write, and format Google Sheets with AI assistance.
// what it is
Google Sheets does a lot of heavy lifting: project trackers, client reports, data exports, and shared records. This connector gives your AI assistant genuine read-write access to spreadsheets: reading and writing cell values, creating and renaming sheets, sorting and filtering data, applying formatting, and managing named ranges. It can do in one pass what would take ten minutes of manual editing.
GOOD FOR // Anyone managing data in Google Sheets who wants their AI assistant to populate, clean, format, and organise spreadsheets rather than doing it manually.
// what you can do
Read and write cell data
Read ranges, write values, append rows, clear cells, and run batch read or write operations across multiple ranges in one go. Includes find-and-replace for bulk updates.
Sheet and spreadsheet management
Create new spreadsheets, add, delete, rename, and copy sheets within a file. Everything you would do in the sheet tab menu, from a conversation.
Formatting and layout
Apply cell styles, set borders, resize columns and rows, merge cells, freeze headers, and set up conditional formatting rules, so the spreadsheet looks right, not just populated.
Data organisation
Sort by any column, set filter views, add data validation rules, create named ranges, and insert or delete rows and columns.
// try asking
Read the data from columns A to E in the May sheet and summarise it for me.
Append last week's sales figures to the bottom of the Revenue Tracker sheet.
Freeze the top row as a header and bold all the column titles.
Sort the client list sheet by the 'Last Contact' column, newest first.
// the full toolset
sheets_spreadsheets 7 Spreadsheet management (list, get, create, add_sheet, delete_sheet, rename_sheet, copy_sheet) sheets_values 8 Cell value operations (read, write, append, clear, batch_read, batch_write, batch_clear, find_replace) sheets_format 7 Formatting and styling (cell_style, borders, resize, auto_resize, merge, freeze, conditional) sheets_data 7 Sort, filter, validation (sort, filter, validate, duplicate_sheet, named_range, insert_dimension, delete_dimension) // connect
Works with Claude (Code, Desktop, claude.ai), and any MCP-compatible client. OAuth on first connect: no keys to paste.
claude mcp add --transport http google-sheets-mcp https://sheets.mcp.jezweb.ai/mcpclaude.ai: Settings → Connectors → Add connector → https://sheets.mcp.jezweb.ai/mcp
// more in google workspace
Google Calendar
Create, update, and manage calendar events.
Google Chat
Read and send messages across Google Chat spaces.
Google Docs
MCP server enabling Claude to create, read, edit, and format Google Docs with AI assistance..
Google Drive
Upload, download, and organise files in Google Drive.
Google Slides
MCP server enabling Claude to create, read, edit, and format Google Slides presentations with AI assistance..
Google Tasks
Create, update, and organise tasks and task lists.