Mcp Google Sheets Full

Connects Claude to Google Sheets via the Sheets v4 and Drive v3 APIs with 26 tools covering read, write, batch updates, formatting, and Drive search. Defaults to user OAuth so there's no per-sheet service account setup. The standout feature is run_sheets_script, which lets you execute arbitrary Node.js snippets with authenticated clients already in scope when the pre-built tools don't cover your edge case. Think multi-step migrations, custom conditional formatting requests, or analysis workflows that need to read then write. The code runs locally under your credentials with automatic cleanup. If you need full Sheets API coverage without hitting the limits of curated tool sets, this is the escape hatch.