# Dashboard from Google Sheets

> For AI assistants: this is the BitHut template `sheets-dashboard` (sites and dashboards). Ask the person only for what is listed under "What you'll need", then set it up with the BitHut tools connected to you. If BitHut is not connected yet, start at https://bithut.app/llms.txt.

A web page with charts from your Google Sheet, behind a password, for your team.

## Tell your AI

1. Connect BitHut to your AI (Claude, ChatGPT or Codex): add the address `https://api.bithut.app/mcp`. How: https://bithut.app/connect.md BitHut is invite-only for now. Signing in works for the Google account we invited.
2. Then tell it:

```
Make a dashboard from my Google Sheet and put it on BitHut using the sheets-dashboard template. Keep it behind a password. Ask me for the sheet and which numbers to show.
```

## What you get

A page at its own address with a few charts and a table, built from the sheet.

## Who it's for

Heads of departments who send the same spreadsheet around and want one page everyone can open.

## What you'll need

- A link to the Google Sheet, shared so the dashboard can read it.
- Which numbers and charts you want to see.
- Who should get the password.

## What's included

- **Its own address, with a password.** Closed from the start. You decide who gets the password.
- **A disk.** The dashboard can keep history even when the sheet changes.
- **One step back.** Every update keeps the previous version one step away.

## Your data and privacy

The page opens only with the password. The sheet link is stored as a secret. The dashboard reads the sheet and does not change it.

## Limits

- Reads the sheet. Editing the sheet from the page needs changes your AI can make.
- Very large sheets load slower. Your AI can keep a copy of the data on the disk to speed it up.

## After you start it

1. Your AI builds the page and sends you the address and password.
2. Open it and check the charts.
3. Share the address and password with your team.

## Questions

### Does the dashboard update by itself?

It reads the sheet when someone opens the page, so it shows the latest numbers.

### Can my team sign in with Google instead of a password?

Not yet. Sign-in with a company Google account is planned.

## Technical details

- Language: Python
- Parts: Website, Disk

## Similar templates

- [Daily report to Telegram](https://bithut.app/templates/daily-report-to-telegram.md): Every morning it takes yesterday's numbers and sends a short summary to your Telegram chat.
