How to connect Google Sheets to Claude Code

1. 1. Enable Google Sheets in Metorial

   In your Metorial portal, enable the Google Sheets MCP server and sign in with the account that owns the data. Access stays governed by your team policies.

2. 2. Add the server over HTTP

   Add --scope user to use it in every project.

   Copy

   claude mcp add --transport http metorial <your-magic-mcp-url>

3. 3. Sign in

   Run /mcp, select Metorial and sign in to load Google Sheets tools.

• Delete Spreadsheet: Permanently deletes a spreadsheet from Google Drive.
• Format Cells: Applies formatting to cells in a spreadsheet range.
• Create Pivot Table: Creates a pivot table that summarizes data from a source range.
• Manage Protected Ranges: Add or remove protection on cell ranges to prevent modifications.
• Batch Update: Executes multiple spreadsheet update operations atomically in a single request.
• Create Spreadsheet: Creates a new Google Sheets spreadsheet with optional initial sheet tabs.
• Create Filter View: Creates a filter view that provides a filtered perspective of data without affecting what other users see.
• Update Spreadsheet: Updates the properties of a Google Sheets spreadsheet, such as its title, locale, or time zone.
• Create Chart: Creates an embedded chart in a spreadsheet.
• Manage Named Ranges: Add, update, or delete named ranges in a spreadsheet.
• Get Spreadsheet: Retrieves metadata and properties of a Google Sheets spreadsheet, including its title, locale, list of sheets/tabs, and named ranges.
• Manage Sheets: Add, delete, duplicate, update, or copy individual sheet tabs.
• Read Cells: Reads values from one or more ranges in a spreadsheet.
• Clear Cells: Clears all values from a specified range in a spreadsheet while preserving formatting.
• Merge Cells: Merge or unmerge a range of cells in a spreadsheet.
• And 2 more on the Google Sheets MCP server page.

• Google Sheets tools appear as mcp__metorial__<tool>. Use that name in permission rules to allow or deny a tool.
• Run /mcp to see whether Metorial is connected and to sign in again.
• Claude Code warns when a tool result passes 10,000 tokens and caps it at 25,000 by default. Raise the cap with MAX_MCP_OUTPUT_TOKENS.
• Pre-approve trusted Google Sheets tools with allow rules in your settings so Claude Code stops asking each time.

claude mcp list shows "Needs authentication"

Run /mcp, select Metorial, and sign in. If sign-in keeps failing, choose Clear authentication in the same menu and sign in again.

A teammate sees "Pending approval"

Servers shared through a project .mcp.json need approval. Run claude in the project and approve Metorial when asked.

Large tool results are cut off

Claude Code limits MCP tool output to 25,000 tokens by default. Raise it with the MAX_MCP_OUTPUT_TOKENS environment variable.

Based on the Claude Code MCP documentation.