Google Sheets
Read, write, and edit Google Sheets (via the combined Workspace server).
Google Sheets
Read, write, and edit Google Sheets (via the combined Workspace server). With Lunar.dev MCPX, the MCP Gateway for secure and governed tool access, you connect the Google Sheets MCP server to Claude, ChatGPT, Cursor, and any MCP client through one gateway that routes, authenticates, and governs every Google Sheets tool call against your policies.
Why MCPX
MCPX is Lunar.dev's MCP Gateway. It sits between your AI agents and your MCP servers as a single gateway for every tool call, routing, authenticating, and governing traffic against your policies. Connect Google Sheets once and govern it everywhere: role-based access per agent with on-behalf-of attribution, real-time visibility, and an immutable audit trail of who did what, all deployable inside your own VPC.
Tools content
- list_spreadsheets · Read-only
Lists spreadsheets from Google Drive that the user has access to. - get_spreadsheet_info · Read-only
Gets information about a specific spreadsheet including its sheets. - read_sheet_values · Read-only
Reads values from a specific range in a Google Sheet. - modify_sheet_values · Write
Modifies values in a specific range of a Google Sheet - can write, update, or clear values. - format_sheet_range · Write
Applies formatting to a range: colors, number formats, text wrapping, alignment, and text styling. - manage_conditional_formatting · Write
Manages conditional formatting rules on a Google Sheet. - create_spreadsheet · Write
Creates a new Google Spreadsheet. - create_sheet · Write
Creates a new sheet or duplicates an existing sheet. - list_sheet_tables · Read-only
Lists all structured tables in a spreadsheet with their IDs, names, ranges, and column details. - append_table_rows · Write
Appends rows to a structured table in a Google Sheet. - resize_sheet_dimensions · Write
Manages sheet-level dimension properties: resize columns/rows, auto-resize to fit content, freeze rows/columns, hide/unhide rows/columns, and insert/delete rows/columns. - move_sheet_rows · Write
Moves rows from one sheet to another within the same spreadsheet.
Frequently asked questions
What is the Google Sheets MCP server?
Read, write, and edit Google Sheets (via the combined Workspace server). Through Lunar.dev MCPX, Google Sheets connects to any MCP-compatible AI client behind a single governed gateway.
How do I connect Google Sheets to MCPX?
Add the Google Sheets server in the MCPX control plane or your app.yaml, then point your AI client at your MCPX gateway. MCPX handles OAuth and routes every Google Sheets call through the gateway.
Is the Google Sheets MCP server official?
Google Sheets is a community-maintained MCP server. MCPX lets you risk-assess and sandbox it before rolling it out to your teams.
What authentication does Google Sheets use with MCPX?
Google Sheets uses OAuth. MCPX enforces authentication at the gateway with token-based auth, OAuth, and role-based profiles, so you control which agents can invoke it.
How many tools does Google Sheets expose in MCPX?
Google Sheets exposes 13 tools. In MCPX you can enable or disable each tool per agent for least-privilege access.
