OpenAICodex

Connect Codex to Google AppSheet

Give an AI agent your Appsheet app as a tool and it can read and change the data behind that app on its own. It looks up rows by key or with a selector, adds and edits records, deletes stale ones, and fires off your custom actions, calling each as a tool while it works through a task. Wire it into a hosted coding agent in NoClick and it handles the data side of the job instead of only telling you what to change.
Loading preview…
Opens a workflow with 7 tools ready to use.

What happens next

Set up in minutes

The open button drops you into a guided setup. It asks exactly this, nothing else:
  1. Choose where it runs

    On your computer through your own Codex, or hosted in the cloud. The rest of setup adapts to your choice:

  2. Pick what it can do in Google AppSheet

    A preset of real Google AppSheet operations. Each one becomes a tool the agent can call, and it can't touch anything outside the list.

  3. Connect Google AppSheet

    One sign-in. The agent acts through your account, scoped to the operations you picked.

  4. Add your personal MCP link

    The last step mints a private MCP URL for this agent and walks you through exactly this, with your real link filled in. The page flips to Connected the moment your Codex first calls in.

    Run this in your terminal

    $codex mcp add noclick --url https://mcp.noclick.app/s/<your-link>

    <your-link> is your personal server URL — setup mints it for you.

Exact capabilities

Tools Codex gets

Pick the operations you want and each becomes a tool the agent can call directly while it works.

Google AppSheet

7 tools
Add Rows

Insert one or more new rows into a table.

Edit Rows

Update existing rows; each row must include the key column(s) plus changed columns.

Delete Rows

Delete existing rows; each row must include the key column value(s).

Find Rows by Key

Read specific rows by key; provide key values in Rows.

Find All Rows

Return every row in the table (empty Rows, no Selector).

Find with Selector

Read rows matching an AppSheet Selector expression (FILTER/SELECT/ORDERBY/TOP).

Invoke Custom Action

Run a data-change action predefined in the app against the supplied rows.

Starting points

What you can build

When new rows are added to a table, enrich each one with an AI step and edit the row back with the result.
On any data change in a tracking table, find the affected record by key and post a summary to your team.
Every morning on a schedule, find all overdue rows with a selector and invoke a custom action to send reminders.
When a form is submitted in another tool, add a row to your Appsheet table so the app stays in sync with the outside world.
When rows are deleted, find the related records and clean them up so your app data stays consistent.
On a schedule, scan a table for records matching a selector and edit their status field in bulk.

Meet the runner

About Codex

Codex is OpenAI's command-line coding agent. NoClick runs it as a hosted agent and lets you connect your apps to it as tools, turning it from a coding assistant into an operator that can act across your systems. Connect an integration to the agent and Codex can query, create, and update records in that app directly. You keep the Codex experience and give it real reach into the tools your team already uses.
Fast, capable code generation and editing
Good at well-scoped, concrete tasks
Strong at API and data manipulation
Familiar to teams already on OpenAI tooling

Good to know

Frequently asked questions

Keep exploring

More ways to connect

Make it yours

Open your Codex agent in one click.

NoClick runs Codex for you with Google AppSheet wired in as tools. Connect your account and run.