Skip to main content

Build a profit report website with Codex Sites and Marrow MCP

Codex Sites is an OpenAI plugin that builds, saves, and deploys hosted websites directly from a prompt. You do not need a separate deployment workflow. With Marrow MCP, you can generate a live business dashboard powered by real Amazon seller data without writing code. This tutorial shows you how to build a profit report website for a Delto UK seller. You will write one prompt, let Codex generate and deploy the site, and create a hosted analytics page that reads live data from Marrow.

What you will build

By the end of this tutorial, you will have a deployed website that shows:
  • KPI tiles for the last 7 days: profit, total sales, units sold, ACOS, TACOS, and ROI
  • A daily profit and cost breakdown table grouped by SKU and child ASIN
  • A top five most profitable products section for the same period
Live profit report website powered by Marrow MCP

Prerequisites

  • A Codex account on a ChatGPT Business or Enterprise workspace (Sites is currently in preview on those plans)
  • A Marrow account with your Amazon connections set up
  • A Marrow MCP key, which you can create in Marrow MCP Integrations
  • Codex connected to Marrow MCP, as described in Using Codex with Marrow MCP

Step 1: Add the Sites plugin

  1. Open the Codex app.
  2. Click Plugins in the sidebar.
  3. Find Sites and click to add it.
  4. Start a new thread. Plugins only take effect in threads created after installation.
Adding the Sites plugin in Codex Site plugin in Codex

Step 2: Confirm Marrow MCP is connected

Before running the Sites prompt, make sure Marrow MCP is configured for Codex. Your global ~/.codex/config.toml or project-scoped .codex/config.toml should contain:
Replace YOUR_API_KEY with your Marrow MCP key. If you have not done this yet, follow Using Codex with Marrow MCP first.

Step 3: Paste the prompt and start the task

In your new Codex thread, paste the prompt below. The @Sites mention at the top activates the Sites plugin, so Codex knows to build and host a website.
Entering the prompt in Codex with Sites plugin active

Step 4: Review the build

Codex reads the prompt, calls Marrow MCP to understand the available data, and generates the website code. While it works, you can follow along in the thread. When Codex finishes building:
  1. Open the Review pane in Codex to inspect the generated source changes.
  2. Confirm the build succeeded and the layout matches what you expected.
  3. To review the site before going live, ask Codex to save a version first:
Codex building the site with Marrow data

Step 5: Deploy the site

When you are happy with the build, tell Codex to deploy it:
Note: Codex may guide you through the deployment flow automatically after the build is complete. In that case, you do not need to paste the command above. Follow the prompts in the thread and confirm when asked.
Codex publishes the saved version and returns a production URL. Every Sites deployment URL is live immediately, so you can share it directly with your team. Deploying the site in Codex Deploying the site in Codex

Result

The deployed site shows live Marrow data: KPI tiles at the top, a day-by-day profit and cost breakdown table, and a ranked top five products section. All data is pulled from the Profit by SKU & Date table for the last 7 days. Live profit report website powered by Marrow MCP To adapt this for another seller or time period, open a new Codex thread and adjust the Seller and Time period fields in the prompt. The rest of the design and structure stays the same.

Marrow MCP resources

Check the following resources for more information: