{"id":"0d3aea24-6bfa-4028-8e80-6c03d0dc4dcf","slug":"smithery-node2flow-google-sheets","name":"Google Sheets","description":"MCP server for Google Sheets : read, write, format, and manage spreadsheets through 23 tools.\n\n## Features\n\n- Read and write cell values with A1 notation\n- Batch read/write for multiple ranges at once\n- Full formatting: bold, italic, colors, fonts, alignment, number formats\n- Sheet management: add, delete, rename, copy, duplicate tabs\n- Data operations: sort, find & replace, filters, protected ranges\n- Add charts (bar, line, column, scatter, etc.)\n- Raw batchUpdate pass-through for any Sheets API operation\n\n## 23 Tools\n\n- **Spreadsheet**: create and get spreadsheet metadata\n- **Values**: read, batch read, write, append, clear, batch write\n- **Sheet Management**: add, delete, rename, copy, duplicate sheets\n- **Formatting**: format cells, merge/unmerge, auto-resize\n- **Data Operations**: sort, find & replace, basic filter, protected ranges\n- **Advanced**: add chart, raw batchUpdate\n\n## Configuration\n\n- `GOOGLE_CLIENT_ID` : OAuth 2.0 Client ID from Google Cloud Console\n- `GOOGLE_CLIENT_SECRET` : OAuth 2.0 Client Secret\n- `GOOGLE_REFRESH_TOKEN` : Refresh token with spreadsheets scope","capabilities":[],"protocols":["MCP"],"safetyScore":86,"overallRank":38.3,"trustScore":null,"trust":null,"source":"SMITHERY","updatedAt":"2026-04-16T06:45:15.881Z"}