Skip to main content
Claude and ChatGPT can each build a dashboard from a prompt and host it in your own Claude or ChatGPT account. Charts read SourceMedium through the connector, so they use your workspace’s metric definitions and you never paste a BigQuery credential. Everyone who opens one reads through their own SourceMedium connection and sees only what they already can. On Dashboards & Apps, these are Claude Dashboard and ChatGPT Dashboard. On Claude Dashboard, Set up opens the connection steps on AI Agents. On ChatGPT Dashboard, it opens the steps below, starting with the workspace plugin and the server URL to copy. Once you connect, the row shows Connected, and Manage has the steps and prompts on this page.
When you connect SourceMedium to an AI service, queries and the resulting data may be sent to the AI provider you choose. Ask for totals and trends, not customer contact, address, or other direct personal data, unless it is necessary and authorized for your use case.

Before you start

Connect SourceMedium to the agent you will build in: follow Connect your own agent, or choose Set up on Claude Dashboard in Dashboards & Apps. Any workspace member can connect, with their own SourceMedium sign-in. A ChatGPT Dashboard needs SourceMedium added as a workspace plugin instead: Set up on its tile has those steps, also below.

Claude Dashboard

Claude builds it with Claude Data, on Claude’s paid plans. Chat works on every plan.
1

Ask for a dashboard

In Claude, open Artifacts, choose Data, and say what you want to see and how often to refresh it. Asking in any chat works too.
2

Check, refine and share

Open a chart’s query to see how it was counted, ask Claude for changes, then Share it.
  • Where it lives: your Claude account. Claude refreshes it through the SourceMedium connector as often as you ask.
  • Who can open it: whoever you share it with in Claude. Each needs their own SourceMedium connection, unless you turn on Claude’s live sharing (beta) for it.
  • What it needs: on Team or Enterprise, an Owner may first need to turn on Claude Data (Organization settings → Artifacts) and artifact connectors (Organization settings → Capabilities).

ChatGPT Dashboard

ChatGPT builds and hosts it as a website with ChatGPT Sites, in public beta on eligible Plus, Pro, Business, Enterprise and Edu plans. Hosting uses your plan’s Sites allowance, and live data needs a Business, Enterprise or Edu workspace.
A SourceMedium connection added only to your own ChatGPT account (Plugins → Add custom MCP server) works in chat, but a Site can’t use it: the Site’s sign-in lists SourceMedium as not available. A Site reads SourceMedium through a workspace plugin.
1

Add SourceMedium as a workspace plugin

A ChatGPT workspace admin opens the workspace’s admin settings and chooses Plugins → Add → Create MCP plugin. Name it SourceMedium, paste the server URL that Set up on ChatGPT Dashboard shows (also on AI Agents), keep OAuth, and sign in to SourceMedium when asked. Then choose Review app, review its tools and risks, and Publish. Allow site visitors to use this plugin is on by default; leave it on.
2

Ask for a website

In ChatGPT on the web or desktop, mention @Sites or ask for a website using SourceMedium, and say what you want to see. The prompts below keep it inside your workspace.
3

Check and refine

Try it in the preview and check the numbers against SourceMedium. Select Edit or ask ChatGPT for changes.
4

Open it

On their first visit, each person signs in with ChatGPT, allows the Site to read their SourceMedium connection, and selects Continue.
  • Where it lives: your ChatGPT workspace, as a Site.
  • Who can open it: people in your ChatGPT workspace. A public Site, or anyone outside the workspace, gets no SourceMedium data. Sharing a Site never shares your own connection.
  • What it needs: a ChatGPT Business, Enterprise or Edu workspace, SourceMedium added as a workspace plugin, and a Site shared only inside the workspace.

Keeping it current

Each visitor’s own SourceMedium connection loads the data, and Refresh now, in the Site’s refresh menu, reloads it. Ask for the date the data runs through, so everyone can see how current the numbers are. The same menu offers Schedule refresh, which creates a cloud task. OpenAI says a scheduled task can’t use a visitor’s connected access, so don’t count on it to refresh SourceMedium data in a Site.

Keeping it private

  • Keep the Site shared inside your workspace.
  • Let the Site load SourceMedium data through each visitor’s connection. Rows saved in a Site’s own database are a copy outside SourceMedium’s access checks, and the Site’s editors can read them. Save only totals, and only when you need them.
  • Never paste a password, key or token into a prompt. The Site needs none: each visitor’s sign-in is the access.

Prompts to start from

Copy one into Claude or ChatGPT, then refine it in the same chat.
Ask for more in the same chat: another chart, a filter by store or channel, a comparison with the previous period, or a layout that fits a phone. Ask which metric definition a chart uses, and for its query, whenever a number surprises you.

Vendor guides