ExampleDashboards

A sales dashboard that reads the shops' own spreadsheets

An independent bakery with three shops

Each shop already kept a weekly sales sheet. The owner wanted one page that showed all three, without copying numbers by hand.

This is an example. The business is made up to show what BurrowHub can do today — it is not a customer, and nothing here is a customer's words or results.

Illustration A simple picture of how the pieces fit. It is not a screenshot of a real business's app.
  1. Their data
    • Sales sheets, uploaded
    • Sales sheet in Google Drive
  2. BurrowHub's AI

    Builds the app from what they asked for

  3. The appSales dashboard
    • This week
    • Best sellers
    • Weeks
  4. Who uses it
    • The owner, on her phone
    • Shop managers
01 / 06

The situation

Each of the three shops keeps a weekly sales spreadsheet. One manager saves hers in the business's Google Drive; the other two email theirs to the owner, who copies the totals into a fourth sheet every Monday. Nobody enjoys it, and the summary is always a week behind.

02 / 06

What they asked for

A dashboard for our three bakery shops. Show this week's sales for each shop and for all of them together, compared with last week, and which products sell best. Use the sales spreadsheets we already have.

In their own words, as they'd type it into Create with AI.

03 / 06

What BurrowHub built

The owner connected the spreadsheets once, on the Your data screen: two uploaded, one from Google Drive. Starting from Dashboard, she chose them when she described the app, and the AI built a dashboard that reads them live.

Screens

  • This week: a total for each shop and for all three, next to last week's
  • Best sellers: the products that sold most, shop by shop
  • Weeks: a chart of sales week by week

Data

  • Two sales spreadsheets uploaded to BurrowHub
  • One spreadsheet that stays in the business's Google Drive
04 / 06

The steps in BurrowHub

Real BurrowHub screens, filled with made-up data for this example — the business, the people and the figures are invented. They show how it was set up, not the finished app. The screens are in English.

BurrowHub's Your data screen on a phone: a spreadsheet called Station shop sales, uploaded, with its four columns (Week, Product, Sold, Sales) and its first rows.Open the full-size picture
Example data Your data, on the owner's phone: one shop's weekly sales sheet, uploaded once. BurrowHub shows its columns and first rows.
BurrowHub's Create an app with AI screen on a computer. The Dashboard starting point is chosen, the app is named Sales dashboard, and the description says in the owner's words what the dashboard should show.Open the full-size picture
Example data Create with AI: she started from Dashboard and replaced the description it filled in with her own words.
The same Create screen on a phone, further down: the owner's description, and under Build it on your data both shops' sales sheets ticked.Open the full-size picture
Example data Under Build it on your data she ticks both uploaded sheets, so the app is built on them and reads their latest version.
05 / 06

How they use it

  • The owner opens the dashboard on her phone on Monday morning, instead of making the summary sheet.
  • When the two emailed sheets arrive, she uploads each one as a new version of that shop's data, and the dashboard reads it straight away. The Google Drive sheet is fetched again on a schedule, and she can press Refresh now at any time.
  • When she wanted the weekly chart split by shop, she asked for it in the Build with AI chat, tried the new version in the preview, and published it.
06 / 06

What it doesn't do yet

  • It reads the spreadsheets; it does not change them. Corrections are still made in the sheets.
  • If a manager renames or adds columns, BurrowHub says the data changed shape and offers to rebuild the app with the new columns. That rebuild uses one of the business's builds.
  • Google Drive works only where whoever runs BurrowHub has connected it to Google. Uploads work everywhere.
  • It does not connect to the shops' tills. It shows what is in the spreadsheets.

BurrowHub features in this story

  • Starting points
  • Spreadsheets your apps read live
  • Google Drive filesNeeds switching on by whoever runs BurrowHub
  • Build with AI by chatting
  • Preview, then publish
  • Works on phones

Want an app like this for your business?

Tell us a little about your business and what you need, and we'll get back to you.

More examples

More examples