MCP Integration
Codex CLI Setup
Add an InsightfulPipe server to Codex CLI with codex mcp add. When Codex detects the server's OAuth support it starts sign-in right away, so the only other step is clicking Authorize access in the browser.
Before you start
- At least one account connected in InsightfulPipe. See First Connection.
- The server URL and name from MCP Servers in the app. Names follow the pattern
<platform>-mcp, for examplegoogle-ads-mcp.
Setup steps
- Install Codex CLI if you haven't already:
npm install -g @openai/codex - Run this command to add the server. Codex detects OAuth support and starts sign-in:
codex mcp add google-ads-mcp --url https://google-ads.insightfulmcp.com/ - A browser window opens. Log in and click Authorize access. If no browser opens, run
codex mcp login google-ads-mcp.
Once connected, start a new Codex session and ask about your data.
Add every connected source at once
codex mcp add main-mcp --url https://main.insightfulmcp.com/Using the Codex app instead
The InsightfulPipe listing in the OpenAI app directory connects the full InsightfulPipe MCP in both ChatGPT and Codex under the same account. See ChatGPT Setup.
Example prompts
- "Use Google Ads to show my top 5 campaigns by spend this month."
- "Pull Google Search Console clicks and impressions for my top 20 pages last month."