Skip to content

Connect Codex to Google Sheets

Connect Codex to Google Sheets: 1. Sign in to ApexGenius and connect Google Sheets. 2. Add the ApexGenius plugin. 3. Start using Google Sheets in Codex. Start in Plugins in the ChatGPT desktop app and authorize your connection.

Connect Google SheetsSee the setup

1,000 free credits · No card required

How to connect Google Sheets to Codex

  1. 1Sign in to ApexGenius and connect Google Sheets
  2. 2Add the ApexGenius plugin to Codex
  3. 3Start using Google Sheets in Codex

FirstConnect Google Sheets to ApexGenius

ThenConnect ApexGenius to Codex

Google Sheetsapexgenius.ai/connections/google_sheets1 of 3

Connect Google Sheets. Google Sheets shows as connected in ApexGenius.

Then ask Codex:

Find the available Google Sheets read tools. Do not open or change a spreadsheet.

Written setup, step by stepShow

Before you start

  • An account with permission to use the Google Sheets resources you intend to connect.

1. Connect Google Sheets to ApexGenius

  1. Open Google Sheets in Connections. Choose Connect, or Add connection when offered. Give the connection a name if prompted. If Gateway setup pending appears, contact ApexGenius support before continuing.
  2. Choose the account and review access. Sign in to the Google account that has access to the intended resources. Review the permissions Google requests, then return to ApexGenius.
  3. Review the connected account and resources. Find Allowed resources on the connection page or its Tools tab. Choose Refresh and enable only the connected Sheets account. Resource selection does not add permissions to the Google account.
  4. Check the connection. Use Test connection or Check again and read the reported status. Add an AI agent from the AI agents page, choose Read only for the first test, and try the question below.
    The actual Google Sheets connection page in ApexGenius, showing its saved connection status.
    This captured Google Sheets connection reports ready. Check your own connection and its latest validation before using tools.Open full-size image (opens in a new tab)
Connect Google Sheets →

2. Connect ApexGenius to Codex

  1. In the desktop app, open Settings, then MCP servers and Add server.
  2. Name the server ApexGenius, choose Streamable HTTP, and paste the MCP address above.
  3. Save, then select Restart. Choose Authenticate for ApexGenius and complete the browser sign-in.
  4. When ApexGenius asks what this AI client may use, choose Read only for the first test, or Custom to limit it to the tools you need.
  5. Start a new conversation and select ApexGenius from the available tools before asking for live data.
Official Codex setup instructions ↗

Watch the setup

Follow each step at your own pace.

Codex desktop app with Plugins selected and ApexGenius listed under Available to your account.
Open Codex in the ChatGPT desktop app, then Plugins, and find ApexGenius.Open full-size image (opens in a new tab)

Step 1 of 4Open Plugins

The walkthrough uses the original ChatGPT web plugin captures. After connecting, open Codex in the desktop app and start a new task with ApexGenius. A ChatGPT web connection does not verify Codex access.

A public ApexGenius plugin listing is not verified. Use a plugin shared with you or one you created, subject to your account and workspace policy.

OpenAI Plugins guide (opens in a new tab)Full Codex setup guide
Create a personal plugin

Where Developer mode is available, open ChatGPT Settings, then Security and login, and enable it. In Plugins, select the plus button, enter ApexGenius and a description, then add this URL under Connection. Create the connection, complete OAuth, and review the tools. Return to Codex in the desktop app and start a new task with the plugin enabled.

https://server.autom8.pro/mcp
OpenAI custom connection guide (opens in a new tab)
No plugin available? Use desktop settings
  1. In the ChatGPT desktop app, open Settings, then MCP servers, then Add server.
  2. Name the server ApexGenius, choose Streamable HTTP, and paste the MCP address below.
  3. Save, select Restart, then Authenticate. Sign in to ApexGenius and authorize the intended connections and access.
  4. Start a new Codex task and ask one read-only question. Check the returned result and its matching successful read in Activity.
https://server.autom8.pro/mcp
OpenAI desktop MCP settings (opens in a new tab)
Manual setup for developers

Codex CLI is optional. Run these commands, complete browser authorization, then start a new session. Do not paste bearer tokens or static authorization headers.

Register the remote MCP server

codex mcp add apexgenius --url https://server.autom8.pro/mcp

Authorize in your browser

codex mcp login apexgenius

Inspect registered servers

codex mcp list

The desktop app, CLI, and IDE extension share MCP configuration on the same host. The IDE extension does not install plugins. ChatGPT web does not read local Codex configuration.

3. Verify one safe read

Find the available Google Sheets read tools. Do not open or change a spreadsheet.

Find the available Google Sheets read tools. Do not open or change a spreadsheet.

Compare the returned account and resource with Google Sheets. Check the connection status separately from the result of the first read.

What Codex can do in Google Sheets

6 operations. Read looks things up and changes nothing. Write changes Google Sheets and runs only when that tool is enabled.

Read2 operations

Looks things up. Changes nothing.

Read

  • get_spreadsheetRead a spreadsheet’s tabs and settings, with cell data and comments if you ask.
  • get_valuesRead the values in a range, such as Sheet1!A1:D20.

Write4 operations

Changes Google Sheets. Runs only when enabled.

Edit

  • update_valuesSet the values in a range.
  • update_formulasSet the formulas in a range.
  • insert_dimensionInsert rows or columns.
  • update_spreadsheetChange a spreadsheet in bulk: tabs, formatting, filters, charts and comments. It can also delete rows and tabs.

You choose what Codex can use

When you approve Codex, pick Full access, Read only, or Custom. Read only allows the Read operations and nothing else. Custom picks apps and tools one by one.

Limits in Google Sheets

  • · The connected Google account decides which spreadsheets can be read and changed.
  • · Bulk updates can delete rows and tabs. Read the range first and ask for the exact change.
  • · Enabled writes run immediately. Turn a tool off to block calls.
  • · Disconnecting stops future access. It does not undo a change; use the spreadsheet’s version history.

What it looks like in Codex

An illustrative read-only request and response. Your results come from the account and dates you choose.

How the route works
Codex
CodexApexGenius MCP route
List the tabs in the spreadsheet I name. Do not change it.
ApexGenius
Working with ApexGenius1 tool search · 1 read
RequestList the tabs
Account scopeAuthorized connections checked
apex_search_toolsGoogle Sheets read · Find Google Sheets toolsComplete
apex_call_write_toolget_spreadsheet · Read the spreadsheetComplete
Codex

Illustrative example: four tabs, Leads, Pipeline, Q3 and Notes. Nothing was changed.

Read-only route
Codex

Try asking

“List the tabs in the spreadsheet I name. Do not change it.”

“What were total sales by region last month in the sales sheet?”

“Which rows in the leads sheet have no email?”

“Add this week’s numbers as a new row in the tracker sheet.”

More connections like this one

One ApexGenius account covers every pair below. Connect an app once and each agent you allow can use it.

Codex with other apps

Questions people ask first

How do I connect Google Sheets?

Open Google Sheets in ApexGenius Connections, choose Connect, and sign in with the Google account that can open your spreadsheets.

Which spreadsheets can my AI read?

Any spreadsheet the connected Google account can open. Give your AI the link, or let it find the file with Google Drive.

Can my AI change a spreadsheet?

Yes. It can update values, formulas, rows and formatting. Enabled writes run immediately. Turn a tool off to block calls.

Can my AI create a new spreadsheet?

Not with the Sheets tools. Connect Google Drive, which can create a new spreadsheet.

Will this list of tools change?

Google publishes the Sheets MCP tools, and ApexGenius reads Google’s live list on every search. This page shows the list as of its review date.

Connect Google Sheets to Codex today

Start free

1,000 free credits. No card required. Disconnect any time.