Does Claude support the Google Sheets MCP server?

Yes. Claude connects to the Google Sheets MCP server through its connector settings, pointed at your Metorial URL. You need any Claude plan; Free plans allow one custom connector.

Do I need an API key to connect Google Sheets to Claude?

No. You sign in to Google Sheets once through Metorial, and Claude uses that connection. No API keys go into Claude's settings.

Which Google Sheets tools can Claude use?

All 17 Google Sheets tools your team allows, such as Delete Spreadsheet, Format Cells, Create Pivot Table. Admins can narrow that list per team.

Can I control which teammates use Google Sheets in Claude?

Yes. Role-based access control decides who can use Google Sheets and which of its tools appear in Claude, and every call is logged with the person's identity.

What if Claude doesn't show Google Sheets tools?

On Team and Enterprise plans an Owner adds custom connectors in Organization settings, then Connectors. Members then connect it with their own account.

Connect Google Sheets to Claude (MCP setup guide)

Ask Claude to use the delete spreadsheet tool in Google Sheets
Ask Claude to use the format cells tool in Google Sheets
Ask Claude to use the create pivot table tool in Google Sheets
Ask Claude to use the manage protected ranges tool in Google Sheets
Ask Claude to use the batch update tool in Google Sheets

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. Add a custom connector
Open Customize, then Connectors. Select Add, then Custom, then Web.
3. Paste your Metorial MCP URL
Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>) and continue.
4. Sign in
Select Add and sign in to load Google Sheets tools.

Once Google Sheets is enabled in Metorial, teammates sign in with SSO and get the same connection in Claude, with only the tools their role allows.

One link covers every app you approve. See how the MCP gateway handles access, roles and audit logs for the whole company.

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.

Turn Metorial on for a conversation with the + button, then Connectors; each connector has its own toggle.
Claude asks before it runs a Google Sheets tool. Choose Allow always only for tools you trust to run unsupervised.
Use the Search and tools menu to switch off tools you do not need in the current conversation.
Remove the connector from Customize, then Connectors. Team and Enterprise owners can do this for the whole organization.

Members on a Team or Enterprise plan cannot add the connector: On Team and Enterprise plans an Owner adds custom connectors in Organization settings, then Connectors. Members then connect it with their own account.
The Free plan only allows one custom connector: One is enough: your Metorial URL carries every app your team approves, so you never need a second connector.
Tools do not show up in a chat: Connectors are switched on per conversation. Open the + menu in the chat, choose Connectors, and turn Metorial on.

Based on the Claude MCP documentation.

Frequently asked questions

Common questions about connecting Google Sheets to AI agents with Metorial.

Does Claude support the Google Sheets MCP server?
Yes. Claude connects to the Google Sheets MCP server through its connector settings, pointed at your Metorial URL. You need any Claude plan; Free plans allow one custom connector.
Do I need an API key to connect Google Sheets to Claude?
No. You sign in to Google Sheets once through Metorial, and Claude uses that connection. No API keys go into Claude's settings.
Which Google Sheets tools can Claude use?
All 17 Google Sheets tools your team allows, such as Delete Spreadsheet, Format Cells, Create Pivot Table. Admins can narrow that list per team.
Can I control which teammates use Google Sheets in Claude?
Yes. Role-based access control decides who can use Google Sheets and which of its tools appear in Claude, and every call is logged with the person's identity.
What if Claude doesn't show Google Sheets tools?
On Team and Enterprise plans an Owner adds custom connectors in Organization settings, then Connectors. Members then connect it with their own account.