How to connect Google Sheets to Codex

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 and sign in

   The Codex CLI, IDE extension and ChatGPT desktop app share this config.

   Copy

   codex mcp add metorial --url <your-magic-mcp-url>
   codex mcp login metorial

3. 3. Check the connection

   Type /mcp in Codex to see Metorial and its 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.

• Limit which Google Sheets tools Codex sees with enabled_tools and disabled_tools on the metorial server in config.toml.
• Set default_tools_approval_mode to auto, prompt, writes or approve. writes prompts only for tools that are not marked read-only.
• Type /mcp in the composer to see the connected servers.
• Override the approval behavior for a single Google Sheets tool with tools.<tool>.approval_mode.

Metorial is listed but tools are missing

Codex can connect without credentials and then see nothing. Run codex mcp login metorial to complete the OAuth sign-in.

Metorial times out at startup

Codex waits 10 seconds by default. Raise startup_timeout_sec under [mcp_servers.metorial] in ~/.codex/config.toml.

Long tool calls fail after a minute

The default tool timeout is 60 seconds. Raise tool_timeout_sec for the metorial server in config.toml.

Based on the Codex MCP documentation.