How to connect Google Sheets to ChatGPT

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 a custom MCP server

   On ChatGPT web, open Plugins, select +, then Add custom MCP server.

3. 3. Paste your Metorial MCP URL

   Name it Metorial, paste your Magic MCP URL (<your-magic-mcp-url>), choose OAuth and accept the risk notice.

4. 4. Create and install the plugin

   Select Create as a plugin, install it 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.

• Type @ and pick the plugin. The selection applies to that message only, so @mention it again when a follow-up needs fresh Google Sheets data.
• For write actions, ChatGPT may ask you to confirm first, depending on the app permissions and the action.
• Once published for a workspace, ChatGPT keeps a snapshot of the tool list. When your team adds Google Sheets tools in Metorial, an admin refreshes the actions in Workspace settings before they appear.
• You can use several apps in one prompt, for example read Google Sheets data and then create a ticket in another app.

Add custom MCP server is missing

Workspace policy controls it. On Enterprise and Edu, an admin grants the permission to create plugins with MCPs; ask them to enable it for you.

The plugin exists but no tools appear

Creating the plugin is not enough: install it from your plugins, then start a new conversation so ChatGPT loads its tools.

ChatGPT answers without using the tools

Pick the plugin with @ in the composer and name the action you want, for example "use Metorial to look up the latest ticket".

Based on the ChatGPT MCP documentation.