Connects Claude to the Google Sheets API with full read/write access and batch operations. You get all the usual spreadsheet actions: read and update cells, format ranges, create charts, apply conditional formatting. Authentication works three ways: point to a service account JSON file, pass the credentials as an environment variable, or just provide the private key and email directly. Built in TypeScript with stdio transport, so it runs via npx without installation. Useful when you need Claude to analyze data in sheets, generate reports, or automate spreadsheet tasks without copying data back and forth manually.
claude mcp add --transport stdio freema-mcp-gsheets uvx mcp-gsheets