Connect any database. Ask in plain English.

Try free
← Blog

ChatGPT Dashboard: 6 Ways to Build One, and Which Stays Live for Your Team (2026)

ChatGPT can chart an uploaded file in the chat, publish a dashboard as a Site, read live data through plugins, write a dashboard app with Codex or hand the work to a BI tool. What each gives you, whether the numbers stay live, who can open the result, how the same works in Gemini, and when to build it in Fastero instead. Checked 12 November 2026.

Fastero Dev TeamFastero Dev Team2026-11-12

Ask ChatGPT for a dashboard of last quarter's sales and you'll get one. Which kind depends on where your data lives and who needs to open it next Monday, and that decides whether it's a one-off picture or something your team can rely on.

The short answer: for a one-off look at a spreadsheet, upload it and ask: ChatGPT charts it in the chat, with interactive charts on Plus and above, but OpenAI calls the result "a snapshot". For a page others can open, ask for a Site (beta, on Plus, Pro, Business, Enterprise and Edu), which you can share with chosen people, your workspace or the public. A Site's numbers stay current in only two ways: a scheduled task that rebuilds it, or, in a Business or Enterprise workspace, each visitor's own connected apps read when the page opens. For an app on your own database, Codex writes it and you host it. For a team dashboard on your database that everyone opens with the same live numbers, whether or not they use ChatGPT, build it in a dashboard tool such as Fastero.

Fastero

Connect your database. Ask questions. Get dashboards.

Postgres, BigQuery, Snowflake, and 10+ sources — live-connected, AI-powered, no dashboard builder learning curve.

Try free →

The six ways at a glance

From OpenAI's own pages, checked 12 November 2026. We had no ChatGPT account for this, so nothing here is hands-on.

Way Where the data comes from Do the numbers stay live? Who can open it
A chart in the chat Files you upload No, a snapshot You, in your chat
A Site Uploaded files, or connected apps Snapshot, unless a scheduled task rebuilds it or visitors' own connections fill it You and admins at first; then chosen people, the workspace or the public
Plugins to live data BigQuery, Snowflake, Databricks, Metabase and more, or your own MCP server Yes in the chat, when you ask The person asking, with their own connection
Codex writes a dashboard app Your database Only if you host it with a backend Whoever can reach where you put it
ChatGPT plus a BI tool The BI tool's sources Yes, as the BI tool refreshes The BI tool's users
Build it in Fastero Your database, through a stored connection Yes: queries run against the database, on a timer, or when data changes on Postgres and BigQuery Your team with a free viewer login, or anyone with a public link

1. Ask in the chat: a chart from an uploaded file

Upload a CSV or Excel file and ask for a dashboard, and ChatGPT analyses it and draws the charts in the reply. Data analysis is "Limited" on Free, and interactive tables and charts start at Plus. A newer option, Visualize ("Create visualizations and interactive tools"), is rolling out: type @ and choose it under Plugins.

Build a dashboard from this file: revenue by month, revenue by region and the top 10 products, with a region filter.

What you get is a picture of that file: "A visualization is generally a snapshot of the information available when ChatGPT created it, not a live dashboard that stays synchronized with a connected source." Next month's numbers need next month's file. OpenAI's current ChatGPT documentation doesn't cover canvas for this; it documents Visualize and Sites instead.

Best for: a fast first look at a spreadsheet.

2. Publish it as a Site

Sites is ChatGPT's way to build and host a web page: "Create dashboards, team trackers, client portals, landing pages, calculators, games, and more." It's in beta on Plus, Pro, Business, Enterprise and Edu, and "Hosting is free through December 31, 2026." Each plan has a monthly hosting allowance: 125 credits on Plus, 375 on Pro, 125 per seat on Business.

Turn this analysis into a Site: a weekly sales dashboard with number cards for revenue and orders, revenue by month, and a region filter.

"A new site is limited to its owner and workspace admins until you change its access." Then share it with selected people, who sign in with the account that received access, with your workspace, or with the public: "A public site is available without ChatGPT workspace access." Enterprise workspaces have public publishing off by default.

The catch is whether the numbers stay live. "A source link or uploaded export doesn't create a live connection." Two things keep a site current:

  • Visitors' own connections. In a Business or Enterprise workspace, "On page load, sites reads connected data using the visitor's connection and permissions." But "Plugin use must be enabled in the workspace, and the site must be private to that workspace", and the site "does not use the creator’s connections", so two colleagues can see different numbers and a public site can't use it.
  • A scheduled task. OpenAI's recipe for "a dashboard that stays up to date" runs a ChatGPT Work task that "checks the approved source each weekday and updates the dashboard when the data changes." "The site does not run the schedule itself", and the task should start in the browser if it must run while your laptop is off.

Sites doesn't host everything: "Some frameworks, private networks, databases, background services, and hosting patterns aren't supported." OpenAI's business page says ChatGPT Work "creates live dashboards with Sites"; the documentation above is what decides how live.

Best for: sharing a polished page of results, refreshed by a task, with people inside or outside your workspace.

3. Plugins that read live data

Connectors are now called plugins in ChatGPT, and "Plugins pull in live details across your CRM, codebase, documents, and analytics tools". OpenAI's own Data Analytics plugin lists warehouses and query tools ("Databricks, Databricks Genie, BigQuery, Snowflake") and analytics and BI tools ("Amplitude, Mixpanel, PostHog, Omni Analytics, Metabase, ThoughtSpot, Statsig"). For anything else, such as a Postgres database, you can add a custom MCP server as a plugin; see ChatGPT MCP for how.

Using the Snowflake plugin, chart weekly signups for the last six months split by plan, and tell me what changed.

The answer is current when you ask, through your own connection. Shared, it stops being live: the plugin publishes to Sites "as a Sites-hosted snapshot; it does not add live source connections to the Site." Scheduled tasks (Go and above) can re-run the question on a timetable and notify you.

Best for: asking current questions of a warehouse you already connect to.

4. Codex writes a dashboard app

Codex is included in every ChatGPT plan, Free and Go with limits. In the CLI it works on your machine: "Let Codex inspect files, make edits, and run the tools already installed on your machine." In the cloud, "Each task has its own workspace and can keep working while your computer is asleep", and it reaches a private database over a VPN; "Tailscale is currently the supported VPN provider."

Write a small web app that queries our orders table for revenue by month and by channel, with charts and a date filter, and a README for running it.

Codex can write a React app, a Streamlit dashboard or a static page. Making it live for a team is your job from there: a backend that queries the database safely, a login, and somewhere to run it. A Site can start from a Codex project, but Sites doesn't host databases or background services.

Best for: developers who want full control over the code.

5. ChatGPT plus a BI tool

If the team already has a BI tool, ChatGPT can sit beside it. The Metabase, ThoughtSpot and Omni Analytics entries in OpenAI's Data Analytics plugin read from those tools, and ChatGPT's plugins page mentions "creating charts in Figma". The dashboard itself stays in the BI tool, which refreshes it and decides who can open it, usually with a licence per viewer.

Best for: teams that already pay for a BI tool and want ChatGPT to answer questions about what's in it.

Connect any database. Ask in plain English.

Start free →

6. Build it in Fastero

This is the option for a dashboard your team opens every week on live company data. Fastero is an AI and data platform where people and AI agents work together on a team's data: connect your database once, ask Fastero's AI agent for the dashboard, and it writes the queries and builds it.

A Fastero dashboard named Sales overview with four headline numbers, a monthly revenue line chart and the start of a quarterly revenue by channel chart

A dashboard in Fastero, built on the sample sales database. Invented data.

What changes for your team:

  • It refreshes from the database. Each chart is a saved query against your database, and the dashboard can refresh on a timer or whenever the data behind it changes.
  • Viewers are free. Teammates and clients sign in with their own Fastero login and land on the dashboard; viewers cost nothing on every plan, including Free.
  • A public link for everyone else. Publish a link that opens without an account, and revoke it at any time.
  • It arrives by email. Schedule the dashboard daily, weekly or monthly, with a PDF of the whole dashboard attached, to people with or without an account.
  • Claude can build it too. Fastero's remote MCP server signs in with OAuth. We've tested it with Claude and Claude Code; we haven't tested it in ChatGPT.

The Send dialog of a Fastero dashboard on the Anyone with the link tab: a public link with a Copy button, and a Turn off button that stops the link

A dashboard's public link: anyone with it can view without a login, and turning it off stops it. Link shortened.

How to build a dashboard in Fastero

  1. Connect your data. Postgres, MySQL, SQL Server, Redshift, Snowflake, Oracle or BigQuery, or a CSV, Excel file or Google Sheet.
  2. Ask for the dashboard. "Build a weekly sales dashboard from our orders table: revenue, orders and average order value as number cards with the change since last week, revenue by month, and orders by region."
  3. Check and share it. Open any chart's query to check it, then invite viewers, publish a public link or schedule the email.

The Claude version of this guide is Claude dashboard: 5 ways to build one, and for how ChatGPT compares on database work, see Fastero vs ChatGPT for database analysis.

Best for: a team dashboard on your own database, for people who don't all use ChatGPT.

Which should you use?

  • A quick look at a spreadsheet: ask in the chat.
  • A page to share, refreshed by a task: a Site.
  • Current answers from a warehouse: a plugin, in the chat.
  • Full control of the code: Codex, hosted by you.
  • A dashboard your BI tool already owns: ChatGPT beside the BI tool.
  • Your own database, live numbers, opened by the whole team: Fastero.

The same in Gemini

Gemini has its own versions of the first two ways:

  • Charts in the chat. "You can ask the Gemini web app to create a chart based on your uploaded spreadsheet(s)", with files up to 100 MB.
  • Canvas apps. "Canvas is available for all Gemini users", and Google suggests it for "custom-built dashboards ranging from team trackers to customer management systems and sales pipelines". Sharing is public only: "Canvas apps are shared through public links", and "Anyone with that public link can view and edit data associated with the app."
  • Gemini in Sheets. "The generated chart doesn't link or respond to changes in the original data set that was used to generate it", except on a BigQuery Connected Sheet, where the chart updates when you refresh it, by hand or on a schedule.
  • Data Studio. Conversational analytics in Data Studio (the renamed Looker Studio) is "Available to all Data Studio users", on BigQuery data agents.

FAQ

Can ChatGPT make a dashboard?

Yes: as charts in the chat from a file you upload, as a Site you publish (beta, Plus and above), from live data through plugins, as an app Codex writes, or alongside a BI tool. Only some of these keep the numbers current.

Can ChatGPT connect to my database to build a dashboard?

Through plugins: OpenAI's Data Analytics plugin covers BigQuery, Snowflake and Databricks, and you can add any database's MCP server as a custom plugin. Codex can reach a private database over a Tailscale VPN. A Site can't host a database connection itself.

Does a ChatGPT dashboard update automatically?

A chart from an uploaded file doesn't: OpenAI calls it a snapshot. A Site updates when a scheduled task rebuilds it, or, in a workspace-private site, from each visitor's own connected apps when the page opens.

Can someone without ChatGPT open my dashboard?

A public Site, yes; one shared with selected people needs them to sign in. A dashboard in Fastero opens for anyone you invite, with a free viewer login, or for anyone with its public link.

Is ChatGPT Sites free?

It's in beta on Plus, Pro, Business, Enterprise and Edu, and hosting is free through 31 December 2026. Each plan also has a monthly hosting allowance in credits.

Can Gemini make a dashboard?

Yes. Gemini charts an uploaded spreadsheet, and Canvas builds dashboard apps you share through a public link that anyone holding it can view and edit. Charts Gemini makes in Google Sheets don't update with the data, unless they're on a BigQuery Connected Sheet.

Sources

Checked 12 November 2026. OpenAI's help centre (help.openai.com) refused our requests, so the details come from OpenAI's other official sites:

Ready to try it yourself?

Connect your database, ask questions in plain English, and get live dashboards — in under 2 minutes. No credit card required.

Keep reading

Related articles

2026-11-18

ChatGPT File Upload Limits: 512 MB a File, 20 per Message, 50 MB for Spreadsheets (2026)

ChatGPT's upload limits from OpenAI's own pages: 512 MB a file, 2M tokens for documents, about 50 MB for CSVs and spreadsheets, 20 MB for images, 20 files a message, 5 to 40 files a project and 500 MB to 100 GB of storage by plan. Plus what we measured: about 827 rows of a sales table fill a Free chat's whole context as text, while 611,826 rows fit in a 50 MB CSV that ChatGPT analyses with Python.

chatgptai-agents

2026-11-12

Gemini Canvas: What It Makes, How Sharing Works, Its Limits and Live Data (2026)

Gemini Canvas, on every Gemini plan including free, writes docs, slides and code and builds apps, web pages, infographics, quizzes and Audio Overviews. A shared canvas is a public g.co/gemini/share link, and in a multi-user app anyone with it can view and edit the app's data. Limits, live data, and how it compares with Claude artifacts and ChatGPT canvas, checked 12 November 2026.

geminidashboardsai-agents

2026-11-12

Fastero Alternatives (2026): 10 Tools by Job, and When Each Is the Better Pick

An honest list of Fastero alternatives, grouped by the job you're hiring a tool for: hosting a Python app or notebook (Streamlit Community Cloud, Deepnote, Databricks Free Edition, Observable), dashboards on a database (Metabase, Count, Evidence, Mode) and AI on a single file (ChatGPT, Julius). Prices checked on each vendor's page in November 2026, with the case where each beats Fastero.

alternativesdata-platformsdashboards