Google Sheets Dashboards on Office TVs

The setup, start to finish

Four steps. Ten minutes if you already know which tab you want on the screen.

1. Connect Google Sheets. You sign in with Google and pick which spreadsheets to share. Access is read-only, so nothing writes back. No key to paste, no service account to create.
2. Describe the dashboard.Type what you want to see. “Show weekly revenue against target from the Forecast tab, with a twelve-week trend line and the current week in purple.” The DJ Agent reads the ranges and builds it.
3. Pair the Apple TV. Plug it into the TV, open the app, type the code shown on screen. Once per display, forever.
4. Assign the dashboard to that screen from the web app at your desk.

You never walk to the TV again. That is the part people underestimate until they have done it the other way for a quarter.

Structure the sheet for a wall, not a laptop

A screen read from twelve feet holds six numbers. Eight if you push it. Your sheet has sixty and most of them are inputs.

Build a summary tab. One tab, clean headers in row 1, only the numbers meant for the room, nothing else. Point the dashboard at that tab and let the rest of the workbook stay raw and ugly.

Five things that make the difference:

• Headers in the first row, one row only. Merged cells and stacked header rows confuse everything that reads the range, including people.
• One value per cell. Do not jam “$12,400 (up 8%)” into a single cell. Two columns.
• Keep dates as real dates. Text that looks like a date kills every trend line you try to build on it.
• Name the range. WeeklySummary beats Sheet4!B7:F31 when you want to change the dashboard three weeks from now.
• Put the number you care most about top left. That is where eyes land, and you get about two seconds of them.

Gemini in Sheets started building and editing whole spreadsheets from a plain prompt on May 6, 2026, so writing that summary tab now takes a sentence. Describing the dashboard that puts it on the wall takes about the same. Both halves of the job got easy in the same year, which is new.

Skip the laptop in the room

The screen should run with nobody attached to it. That single requirement rules out most of what people try first.

• Casting from a laptop. The sheet is on the wall until the lid closes, the machine sleeps, or its owner goes to lunch. You have tied a company screen to one person’s calendar.
• Publish to the web. File, then Publish to the web, gives you a URL that refreshes about every five minutes. It also looks like a spreadsheet on a wall: gridlines, tab strip, scroll bar. Fine for a demo. Not a dashboard.
• The smart TV browser. Old engine, slow render, and a session that expires over the weekend. The fix involves a keyboard, a chair, and somebody’s Monday morning.

A native app on an Apple TV skips all three. It renders, it stays on, and it is managed from a browser at your desk. That trade is covered in more detail in the Apple TV vs browser dashboards breakdown, and the short version is that a browser tab is a temporary thing pretending to be permanent.

What ops teams actually put up there

The sheets that earn a screen are the ones holding a number no system owns. In practice that is a short and repeatable list.

• Weekly forecast roll-up, actual against target, by team.
• Hiring plan: open roles, offers out, start dates this month.
• Commission and bonus tracker, with the leaderboard people actually check.
• The board metric somebody built in a spreadsheet three years ago and never moved into a real system.
• Whatever your CEO asks about every Monday. That one belongs on the wall more than anything else on this list.

The sheet does not have to be alone up there either. Quota lives in a Sheet, closed-won lives in HubSpot, cash lives in Stripe. Google Sheets is one of 48 self-serve connectors, so one dashboard can pull all three and show the number that only exists when you combine them. That is the version worth mounting, and it is the argument in office TVs deserve better than a KPI grid.

The hardware math, current as of today

Apple raised the Apple TV 4K to $199 on June 25, 2026, up from $129. The 128GB model with Ethernet and Thread is $249. Apple tied the increase to component costs, not a new box, so you are paying more for the same third-generation hardware that has been shipping since 2022.

That stings and it is still the right buy. A commercial signage player runs $300 to $500 and drags a separate content system behind it. The Apple TV is one payment per screen, it is silent, it is passively cooled, and it disappears behind the mount. Take the Ethernet model if the TV sits far from an access point. A wall screen on marginal Wi-Fi is a support ticket waiting to happen.

When a spreadsheet should not be your source

If the number already lives in a system of record, pull it from there. Pipeline belongs to HubSpot or Salesforce. Revenue belongs to Stripe. Tickets belong to Zendesk. A sheet that copies those numbers by hand is a second source of truth, and the wall will eventually show the wrong one in front of the whole company.

And if nobody owns updating the sheet, keep it off the TV. A stale number in public is worse than a blank screen. People do not discount the one bad tile. They stop trusting the whole board, and you spend a month earning that back.

Sheets earns the screen when it is the only place the number lives and somebody is on the hook for keeping it current. That is the whole test.

The bottom line

Connect the sheet read-only, build a summary tab with six numbers, describe the dashboard you want, and pair an Apple TV to the screen. Ten minutes, and the wall updates itself from then on. Keep the spreadsheet as your source only for numbers that live nowhere else, and pull everything else straight from the system that owns it. Mixing a Sheet with HubSpot or Stripe on one screen is where this gets genuinely useful. If you want the general version of this rather than the Sheets version, start with how to put a dashboard on a TV in your office.

Frequently asked questions

Can you put a Google Sheet on a TV without casting from a laptop?

Yes. Connect the sheet to a dashboard app over Google sign-in, then run that dashboard on an Apple TV plugged into the screen. The Apple TV pulls the data itself, so no laptop has to stay awake in the room and nobody has to keep a browser tab open.

How often does a Google Sheets TV dashboard update?

Within minutes of the sheet changing. Dance Party refreshes each dashboard on its own schedule and the screen catches up on its own. For comparison, a Google Sheet published to the web refreshes roughly every five minutes and shows gridlines and the tab strip along with your data.

Does connecting Google Sheets give the dashboard write access to my spreadsheet?

No. Dance Party reads Google Sheets read-only through Google’s Sheets API and never creates, edits, moves, or deletes anything. You sign in with Google and pick which spreadsheets to share, one by one. There is no key to paste and no service account to set up.

How many numbers should a Google Sheets TV dashboard show?

Six to eight. A screen read from twelve feet cannot carry more than that, and a spreadsheet dropped on a wall unedited carries sixty. Build a summary tab with only the numbers meant for the room and point the dashboard at that tab.

What hardware do you need for a Google Sheets office dashboard?

A TV with an HDMI port and an Apple TV 4K. Apple raised the Apple TV 4K to $199 for the 64GB model on June 25, 2026, and the 128GB model with Ethernet and Thread is $249. It is a one-time cost per screen, it is silent, and it mounts behind the TV.

Can one screen show a Google Sheet and another data source at the same time?

Yes, and that is usually the better dashboard. Quota often lives in a Sheet while closed-won lives in HubSpot and cash lives in Stripe. Google Sheets is one of 48 self-serve connectors, and a single dashboard can pull from several of them at once.

When should a spreadsheet not be the source for an office TV dashboard?

When the number already lives in a system of record. Pull pipeline from HubSpot or Salesforce, revenue from Stripe, and tickets from Zendesk rather than from a sheet that copies them by hand. A sheet with no owner also does not belong on a wall, because a stale number in public costs more trust than a blank screen does.