From Google Sheet to Live, Self-Updating Dashboard in Five Minutes

Somewhere in your Google Drive is the sheet. Orders, leads, inventory, campaign results — the one your team actually runs on. It grows every day, three people edit it, and every Monday someone spends an hour turning it into the same charts as last Monday.

That hour is the tax you pay for the gap between where the data lives (the sheet) and where the answers live (someone's head, via pivot tables).

Here's how to close that gap in about five minutes — no formulas, no BI tool, no data warehouse. Plain-English questions in, a live dashboard out.

Why not just build the dashboard in Sheets?

You can — and if yours works, keep it. But sheet-native dashboards have three chronic problems:

1. They break. A pivot table pointed at A2:F500 quietly stops including row 501. Someone renames a column and four charts die.
2. They only answer the questions you pre-built. A new question means new formula work, so most questions simply don't get asked.
3. Nobody's watching them. A chart that nobody opens on the wrong Thursday is just decoration. (More on that here.)

The BI-tool route (Looker Studio and friends) solves #1 and partially #2 at the cost of a modeling layer someone has to own. For a team running on sheets, that someone usually doesn't exist.

The five-minute version

Step 1 — Connect the sheet (one OAuth click)

In Qunta, add a Google Sheets connection and authorize read access. Qunta pulls a snapshot of the sheet and keeps it in sync — you can re-sync anytime with one click, and monitors re-sync automatically before every check. From here on, the sheet behaves exactly like an uploaded dataset, except it stays current.

Your team keeps working in the sheet. Nothing about their workflow changes. That's the point.

Step 2 — Ask, in plain English (or Arabic)

The moment the data lands, you get an automatic profile — rows, columns, types, and suggested starting questions. Then just ask:

• "Total revenue by month as a line chart"
• "Top 10 products by units sold this quarter"
• "Average order value by region, bar chart"
• "إجمالي المبيعات حسب المدينة" — Arabic questions over Arabic data work first-class, which matters if your sheet (like a lot of real business data in MENA) mixes both.

Each answer arrives as a chart or table plus the exact steps that produced it — filtered which rows, grouped by what, with row counts at every step. When a number looks off, you check the steps instead of re-arguing with a chatbot. Follow-ups chain naturally: "now just the Riyadh region", "sort it descending", "as a pie chart instead."

Step 3 — Pin the answers you want to keep

Every good answer has a Pin button. Pin four or five and you've got a dashboard: revenue trend, top products, cancellations this week, AOV by region.

Here's what makes these pins different from a screenshot or a pasted chart: each pin is a saved pipeline, not a saved picture. Hit refresh — or just come back tomorrow — and the pin re-syncs the sheet and re-runs its exact steps on the current rows. Your Monday report has become an object that rebuilds itself.

Step 4 — Make it watch itself

The final upgrade: pick the one or two pins you'd check obsessively and add a monitor — a schedule plus a condition:

• "Email me if weekly revenue drops below 50,000."
• "Alert me when new rows match: status = refunded."
• "Notify me if this number changes at all."

Every run re-syncs the sheet first, replays the pipeline, diffs the result against the previous run, and emails you only when the condition fires — with a before/after summary and the full step chain attached. The sheet your team edits all day now reports to you.

What this looks like a month later

The pattern we see once a team wires this up:

• The Monday-report hour disappears; the dashboard link replaces the deck.
• Question volume goes up — when asking costs ten seconds, people ask the follow-ups they used to skip.
• The two or three numbers that used to cause fire drills have monitors on them, and the fire drills start with an email that says exactly what changed, from 87 → 132, with receipts.
• The sheet stays the source of truth. No migration project, no "new system" — the dashboard is a lens, not a move.

Connect your sheet

Five minutes: connect, ask, pin, monitor. The sheet keeps doing what it does — and stops needing you to check on it.

Try Qunta free → Connect a Google Sheet and pin your first live chart before your coffee cools.

Qunta is an AI data analyst for teams that run on spreadsheets: connect Google Sheets, ask questions in English or Arabic, pin live-refreshing dashboards, and get email alerts when your numbers change.