MCP Google Sheets

This MCP server turns Claude into a proper Google Sheets client. You get cell-level read and write, formula insertion, formatting control, and sheet management (create, delete, rename). The setup requires a Google service account JSON, which is a one-time faff but standard for server-to-server access. I'd reach for this when automating repetitive Sheets work that benefits from LLM smarts. Example: I pointed it at a messy expense tracker, asked Claude to categorise transactions based on descriptions, then write the categories into a new column with conditional formatting for different spend types. It handled the logic, the writes, and the formatting in one go. Much faster than writing a script myself. The tool shines for anything that mixes data manipulation with light reasoning. Financial modelling where you need Claude to suggest formulas based on your goals. Reporting automation where the LLM decides what to highlight. Dashboard updates that adapt to changing data patterns. It's less useful if you're just doing bulk data dumps (Apps Script or the Sheets API directly will be faster). Quirks: the service account needs explicit sharing on every spreadsheet you want to touch, which is easy to forget. No batch operations mentioned in the docs, so if you're updating thousands of cells, expect multiple tool calls. The formatting options are decent but not exhaustive; complex conditional formats might need manual setup first. Skip this if you don't already live in Sheets or if your workflows are simple enough for manual copy-paste. Also skip if you're uncomfortable with service account permissions (they're powerful and need careful scoping). But if you're doing regular Sheets work that involves decisions, categorisation, or dynamic formulas, this is genuinely useful. It's not flashy, but it does what it says and saves real time.