Documentation
How to create a live display from Google Sheets.
Sheet2Notice turns a published spreadsheet into a live TV dashboard or display. No developer, no plugins — publish the sheet, generate a display, open TV Mode on the wall, bookmark the manage link, or paste two lines of HTML.
One workbook
Give each display its own tab.
You do not need a new spreadsheet for every display. Keep a Queue Display tab and a Notice Board tab in the same workbook. Google gives every tab a unique gid, and Sheet2Notice reads it from the URL you paste.
- 01
Create or select a tab
Use the + button in Google Sheets, name the tab, and paste the matching sample rows into A1.
- 02
Publish the entire document
File → Share → Publish to web → Entire document. Check Published content & settings when you add tabs later.
- 03
Copy the tab URL
Click the tab so it is active, then copy the normal address-bar URL. Keep the #gid=… part.
- 04
Generate and repeat
Create the display, then repeat with another tab. For websites, add widget.js once and use one data-block div per display.
Queue Display template
Columns for now-serving screens
Row 1 holds the headers. Status controls the layout: Serving and Called appear as large now-serving cards; Waiting fills the up-next list. Done rows stay in the sheet but are hidden from the display.
- Token
- The ticket or token number shown on screen (e.g. A102).
- Counter
- Desk, window or room the visitor should go to (e.g. Counter 4).
- Status
- One of: Serving, Waiting, Called, Done.
- Estimated WaitOptional
- Optional wait time such as 5 or 5 min.
- HighlightOptional
- Optional. TRUE draws extra attention to this row.
- ServiceOptional
- Optional service name such as Billing or Consultation.
| Token | Counter | Status | Estimated Wait | Highlight | Service |
|---|---|---|---|---|---|
| A102 | Counter 4 | Serving | 0 | TRUE | Consultation |
| A09 | Counter 3 | Serving | 0 | FALSE | Billing |
| A14 | Counter 2 | Called | 1 | FALSE | Consultation |
| A103 | Counter 2 | Waiting | 5 | FALSE | Consultation |
| A104 | Counter 1 | Waiting | 8 | TRUE | Pharmacy |
| A17 | Counter 2 | Waiting | 15 | FALSE | Consultation |
| A18 | Counter 3 | Waiting | 18 | FALSE | Billing |
| A08 | Counter 1 | Done | — | FALSE | Consultation |
What a correctly formatted Queue sheet looks like
Metric Cards template
One sheet shape for ops dashboards
Title and Value are required. Optional Subtitle, Unit, Status, Icon, Color and Order control sorting and accents. Operations Dashboard, Reception Display and KPI Dashboard all use this same Metric Cards layout.
- Title
- Metric label shown on the card (e.g. Orders Today).
- Value
- The primary number or text shown large on the card.
- SubtitleOptional
- Optional supporting line such as This Month or Today.
- UnitOptional
- Optional unit such as Orders, USD or %.
- StatusOptional
- Optional tone: good, warning, danger or neutral.
- IconOptional
- Optional icon name from the allowlist (package, users, dollar…).
- ColorOptional
- Optional accent: green, yellow, red, blue, amber or neutral.
- OrderOptional
- Optional sort order (lower numbers appear first).
- LinkOptional
- Optional https:// URL opened from public pages (not TV Mode).
- ImageOptional
- Optional public https image URL (avatar, logo, or product shot).
| Title | Value | Subtitle | Unit | Status | Icon | Color | Order | Link | Image |
|---|---|---|---|---|---|---|---|---|---|
| Orders Today | 2,450 | Today | Orders | good | package | green | 1 | ||
| Pending | 312 | In progress | Orders | warning | clock | yellow | 2 | ||
| Shipped | 2,138 | Today | Orders | good | truck | blue | 3 | ||
| Returns | 24 | Today | Orders | danger | rotate-ccw | red | 4 | ||
| Visitors | 1,245 | Today | neutral | users | blue | 5 | |||
| Revenue | 152K | This month | USD | good | dollar | green | 6 |
What a correctly formatted Metric Cards sheet looks like
Schedule Board / Flight Dispatch
Columns for flight school dispatch TVs
Paste the sample rows into a new sheet to see tails, aircraft, students and statuses immediately. Add an optional Lobby ticker in display options for runway, fuel and density-altitude notices — no second template required.
- Tail Number
- Aircraft tail, bay, room or station shown on screen (e.g. N172SP or Bay 2).
- Aircraft Model
- Aircraft type, vehicle, class or activity label (e.g. Cessna 172S or HIIT).
- Pilot / Student
- Pilot, student, job code or attendee label (initials / codes preferred on public TVs).
- InstructorOptional
- Optional CFI, coach, technician, host or organizer name.
- Departure Time
- Departure, class start, promised pickup or slot time (e.g. 08:00 AM).
- Status
- One of: Scheduled, In Flight / In Progress, Briefing, Delayed, Waiting Parts, Weather, Maintenance, Complete / Ready, Cancelled.
- NotesOptional
- Optional short remark for the wall screen.
- HighlightOptional
- Optional. TRUE draws extra attention to this row.
- LinkOptional
- Optional https:// URL for session details (clickable on public pages, not TV).
- ImageOptional
- Optional public https image URL (poster or speaker photo).
- VisibleOptional
- Optional. Leave blank or Yes to show. No / False / Hide removes the row (avoid Active — that means In Flight in Status).
- Show FromOptional
- Optional. Hide until this date/time.
- Show UntilOptional
- Optional. Hide after this date/time. Date-only values last through that day.
| Tail Number | Aircraft Model | Pilot / Student | Instructor | Departure Time | Status | Notes | Highlight | Link | Image | Visible | Show From | Show Until |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| N172SP | Cessna 172S | J. Doe | M. Miller | 08:00 AM | In Flight | TRUE | ||||||
| N412PA | Piper Archer | S. Jenkins | D. Ross | 09:30 AM | Briefing | FALSE | ||||||
| N810KC | Cessna 172N | — | Mechanic | — | Maintenance | Squawk | FALSE | |||||
| N928EF | Diamond DA40 | A. Smith | M. Miller | 11:00 AM | Scheduled | FALSE | ||||||
| N441FR | Cessna 172S | R. Nguyen | K. Singh | 12:30 PM | Delayed | Awaiting fuel | FALSE | |||||
| N882KA | Cirrus SR20 | T. Hale | D. Ross | 01:15 PM | Weather | Ceiling 800 ft | FALSE |
What a flight dispatch sheet looks like
Notice Board template
Columns for news and notices
Row 1 holds the headers. Every row below becomes one card. Names are not case sensitive, extra columns are ignored, optional cells may be blank, and blank rows are skipped. Optional Media accepts a public https image or direct .mp4 / .webm URL. Active / Show From / Show Until control timed visibility. Use Board + Ticker or Poster Wall for multi-zone and media-first layouts.
- TitleOptional
- The headline people read first. Promo Slides can use Caption instead — or leave blank when Image is set.
- DescriptionOptional
- One or two sentences of detail.
- DateOptional
- Any readable date. Shown exactly as typed.
- LinkOptional
- Optional https:// link for the announcement.
- MediaOptional
- Public https image or direct video file (.mp4 / .webm). Required for Promo Slides — paste the file URL, not a YouTube page.
- SecondsOptional
- Optional. Promo Slides hold time per row (3–120). Falls back to the display default.
- PriorityOptional
- Optional. Use Important, High, Yes, or 1 to highlight the row.
- ActiveOptional
- Optional. Leave blank or Yes to show. No / False / Hide removes the row from the wall.
- Show FromOptional
- Optional. Hide until this date/time (e.g. 2026-08-04 or 4 Aug 2026 09:00).
- Show UntilOptional
- Optional. Hide after this date/time. Date-only values last through that day.
Paste into cell A1. Headers and sample rows land in the right columns.
| Title | Description | Date | Link | Media | Seconds | Priority | Active | Show From | Show Until |
|---|---|---|---|---|---|---|---|---|---|
| Summer hours start next week | Our support team will be available Monday to Friday, 8am–6pm throughout August. | 29 July 2026 | https://example.com/summer-hours | https://placehold.co/960x540/1e293b/f8fafc/png?text=Safety+poster | Important | Yes | |||
| New customer portal is live | Manage requests, download invoices, and find every project update in one place. | 24 July 2026 | https://example.com/customer-portal | Yes | |||||
| Manchester studio opening | Visit our new Northern Quarter space from 12 August. Everyone is welcome. | 18 July 2026 | Yes | ||||||
| Quarterly service update | We've improved response times by 31% and added weekend coverage for priority requests. | 10 July 2026 | Yes |
What a correctly formatted Notice Board sheet looks like
Five steps to a live display
- 01
Create one tab per display
Keep everything in one spreadsheet. Name a tab Queue or Notice Board, then add that template's headers to row 1.
- 02
Publish the entire spreadsheet
File → Share → Publish to web → Entire document → Publish. Review Published content & settings after adding future tabs.
- 03
Copy the active tab URL
Click the tab you want to turn into a display, then copy the normal address-bar URL. Its gid identifies that tab.
- 04
Generate your display
Choose the layout, spacing, height, item count, and theme while the preview updates.
- 05
Open TV Mode, share, or embed
Open the display link or TV Mode on a wall screen, or paste the embed into your website. Repeat with another tab; widget.js only needs to load once.
Wall TV, share, manage, or embed
Every generated display gives you a 6-character code plus links: short TV Mode (/t/CODE or type the code at /go on the TV), a short share link (/s/CODE), and a manage link to restore edit access. If you already have a website, you can also embed with two lines of HTML.
https://www.sheet2notice.com/go
# then type your 6-character code
https://www.sheet2notice.com/t/K7M2XQhttps://www.sheet2notice.com/s/K7M2XQhttps://www.sheet2notice.com/p/joes-cafehttps://www.sheet2notice.com/manage/your-manage-token<script src="https://www.sheet2notice.com/widget.js"></script>
<div data-block="your-block-id"></div>