Google Sheets

smithery.ai/node2flow/google-sheets↗

MCP server for Google Sheets : read, write, format, and manage spreadsheets through 23 tools. ## Features - Read and write cell values with A1 notation - Batch read/write for multiple ranges at once - Full formatting: bold, italic, colors, fonts, alignment, number formats - Sheet management: add, delete, rename, copy, duplicate tabs - Data operations: sort, find & replace, filters, protected ranges - Add charts (bar, line, column, scatter, etc.) - Raw batchUpdate pass-through for any Sheets API operation ## 23 Tools - **Spreadsheet**: create and get spreadsheet metadata - **Values**: read, batch read, write, append, clear, batch write - **Sheet Management**: add, delete, rename, copy, duplicate sheets - **Formatting**: format cells, merge/unmerge, auto-resize - **Data Operations**: sort, find & replace, basic filter, protected ranges - **Advanced**: add chart, raw batchUpdate ## Configuration - `GOOGLE_CLIENT_ID` : OAuth 2.0 Client ID from Google Cloud Console - `GOOGLE_CLIENT_SECRET` : OAuth 2.0 Client Secret - `GOOGLE_REFRESH_TOKEN` : Refresh token with spreadsheets scope