Google Sheets to Digital Signage: Setup Guide for Operators
You can put a Google Sheet on a digital signage screen in three ways: publish the sheet to the web and open that link in a browser on the screen, connect the sheet to a signage app that reads it through Google’s sharing or API settings, or keep the sheet as your planning tool and push the finished content to a cloud signage platform. The first is free and fast. The second gives you more polish. The third scales best once you have more than a couple of screens.
This guide walks through each route, the sharing and security settings that matter, how to format a sheet so people can read it from across a room, and what to check when the screen shows stale numbers.
TL;DR
The simplest route is File, Share, Publish to web, then opening the published link in a browser on your display.
A sheet shared as “anyone with the link can view” needs no credentials. A private sheet needs OAuth 2.0 and a Sheets API scope.
Treat any public sheet link like a password and keep personal, financial and sensitive data out of it.
Design for distance: big fonts, strong contrast, few words, tall rows.
Once you run several screens, a signage platform with scheduling and templates saves more time than spreadsheet workarounds.
Table of Contents
Three ways to get a Google Sheet onto a screen
Before you touch any setting, pick the route that fits how many screens you run and who updates them.
Route | How it works | Best for | Watch out for |
Published web link | Publish the sheet, open the URL in a browser on the display | One or two screens, a single schedule or price list | Caching delays, no scheduling, a browser has to stay open |
Sheets connector in a signage app | The app reads your sheet by link or through Google sign-in and renders it in a layout | Live menus, leaderboards, class timetables | Sharing and permission settings must match what the app needs |
Sheet as source, platform as player | You maintain the numbers in Sheets, then update screen content from a cloud signage platform | Multi-screen networks, franchises, clubs, tourism groups | Someone has to own the update routine |
Most operators start with the first route, outgrow it, and end up with the third. That is a normal path, not a mistake.
Route one: publish to the web
Google’s own help page describes the steps: open the file, choose File, then Share, then Publish to web, pick the entire spreadsheet or individual sheets, and click Publish. You then copy the URL or embed the published sheet in a page.
For signage, a few details make the difference:
Publish only the tab you want shown. Create a dedicated tab for the screen, such as “Lobby Display”, and publish just that. Your working tabs stay out of view.
Trim the visible range. The embed code accepts parameters: according to Google’s help page, range= limits the rows and columns shown (for example A1:B14), headers= toggles row numbers and column letters, chrome= toggles the title and footer, and widget= toggles the sheet tabs at the bottom. Setting headers and chrome to false and defining a range gives a much cleaner screen.
Open it full screen. Use the browser’s full-screen mode on the display, or a kiosk-style launch on a media player or PC.
Test on the actual screen. What looks right on your laptop can wrap or shrink on a 55-inch TV.
This route works well for something like a gym’s weekly class timetable or a restaurant’s daily specials board, provided one person edits the sheet and the screen is always on and connected.
The limits of a browser tab
A published sheet is a web page, not a signage player. It will not rotate content, run a schedule, switch to a promotion at 5 p.m. or recover gracefully if the browser crashes. When you see those needs show up, it is time to look at the other two routes.
Route two: connect the sheet to a signage app
Many signage apps can read a Google Sheet and render it as a table, ticker or card layout. They generally come in two flavors, and the difference is your sharing setup.
Link-shared sheets
For spreadsheets shared as “anyone who has the link can view”, Google’s developer documentation says credentials are not required. That makes the setup quick: paste the sheet’s link or ID into the app’s widget and choose the range.
The trade-off is exposure. Anyone who has the URL can see everything in that sheet. Workshop’s documentation puts it plainly: treat the URL as a credential, and keep public sheets for sample data, public information and shared reference material. Do not use them for personal information, financial data or anything business-sensitive.
In practice that means a menu, a class schedule, event listings or a public price list are fine. Payroll figures, customer names, member contact details and margin data are not. If a dashboard mixes both, build a separate display tab that pulls only the safe figures, and share just that one.
Private sheets and the API
If the sheet must stay private, the app needs authorized access. Google’s documentation states that private spreadsheets require OAuth 2.0 credentials authorized for a Google Sheets API scope, and that read-only access uses the spreadsheets.readonly scope. Before using Google APIs at all, you need to turn them on in a Google Cloud project and create OAuth 2.0 Client IDs to authenticate users and access their data.
Scopes matter here. Google lists the Sheets API scopes, from spreadsheets (see, edit, create and delete all your spreadsheets) to spreadsheets.readonly and the broader Drive scopes, and advises choosing the most narrowly focused scope possible. For a display, that is almost always read-only. A screen has no reason to edit your data.
A quick checklist before you connect any app:
Does it need to edit the sheet? For signage, the answer should be no.
Does it ask for more access than reading one spreadsheet? Question that.
Who owns the Google account that authorizes it? Use a shared business account, not one employee’s personal login, so the screen does not go dark when someone leaves.
Choose the right data for a screen
Not every spreadsheet belongs on a wall. The best candidates share three traits: they change often, they are short, and the viewer cares about them right now.
Menus and specials. Item, short description, price. Restaurants that change specials daily benefit most. Our getting started guide for restaurant signage covers layout and content for this use.
Class and event schedules. Time, class, instructor, room. A column for “status” (full, moved, canceled) turns a static timetable into a live one.
Promotions. Offer, price, end condition. Keep a column for the date range so you can hide expired rows with a filter.
Team dashboards. Daily sales against target, orders in queue, safety days without incident. Two or three numbers beat a table of twenty.
Wayfinding and directories. Tenant names and suite numbers in an office lobby, or listings across a tourism network.
The same row-and-column discipline that keeps a screen tidy also keeps catalog-style content organized. Marketers who run product feed ads rely on the same idea: one clean source of structured rows that everything else reads from.
Format the sheet for reading at a distance
A viewer gives your screen a few seconds from several feet away. Format for that, not for the person editing.
Guidance on accessible spreadsheets from the Welsh Government recommends structured data with little text, 12-point minimum fonts, good color contrast, alternating row colors and bold table titles, with row heights of around 30 pixels. That guidance is written for documents read up close, so for a display across a room treat those numbers as a floor and go bigger.
Practical rules we use:
One idea per screen. Do not squeeze a week of data into one view. Split it across tabs and rotate.
Big type, short text. If a cell needs a sentence, rewrite it as a phrase.
High contrast. Dark background with light text works well in dim rooms such as bars and gyms. Light backgrounds suit bright lobbies and retail.
Alternate row shading. It helps the eye track across a long row, such as a class name to its start time.
Bold headers, consistent columns. Put the most important value, usually time or price, in the same position on every row.
Freeze nothing, hide helper columns. Helper formulas should live on a hidden or unpublished tab.
Match the aspect ratio. Most TVs are landscape 16:9. Set your column widths so the table fills that shape without scrolling.
For guidance on image sizes and layout structure when you move beyond a table, see our digital signage layout rules.
How fast do changes appear?
Google’s publish options include a setting to republish automatically when changes are made, which is the first thing to confirm. Even so, published pages are cached by browsers and servers, so an edit may not appear on the screen the instant you type it. Treat the update as near-live, not instant, and avoid designing anything where a 1 to 5 minute delay would cause a problem, such as a live auction price.
If timing matters, test it: change a cell, note the time, and watch the screen. Do this on the real device, since a TV browser may cache differently from your laptop.
Troubleshooting a screen that is stale or blank
Work through these in order.
Check that publishing is still on. Open File, Share, Publish to web, then Published content & settings. Google’s help notes you can review or stop publishing there. If someone clicked Stop publishing, the link dies.
Hard refresh the page. A discussion in Google’s support community notes that a published sheet may not update because of browser caching, and that a hard refresh loads the page without the cache. On a Mac that is Shift+Cmd+R. On a signage display, schedule an automatic page reload.
Force a change. The same thread mentions that a Google Apps Script with a time-driven trigger can periodically modify the spreadsheet so the published version updates. It is a workaround, so test it before you rely on it.
Check the range. If you set range= in the embed, new rows added below it will not show. Extend the range or use a larger one with blank rows.
Check the sharing level. Account settings can limit who a published file is visible to. If your organization restricts publishing outside the domain, the screen may see a sign-in page instead of data.
Confirm the account and scopes. For private sheets, an expired OAuth authorization or a removed account breaks the connection quietly.
Look at the device. An underpowered smart TV browser can freeze on heavy sheets. Reduce rows and formulas, or use a dedicated app instead of a browser.
Perspective: where spreadsheets stop and signage starts
We like spreadsheets. They are the fastest way for a manager to keep numbers straight, and plenty of our customers start there. But a spreadsheet is a place to store information, not a way to run a screen network. The trouble shows up the moment you add a second location. Now you need different content on different screens, scheduled changes, a way to hand updates to a front desk employee without giving them access to your whole drive, and some evidence that the content is playing. A browser tab cannot do that. That is why we built SignStream around channels. You control content from any device, update multiple screens instantly, and deploy to unlimited screens with no per-screen fees. Our apps run on smart TVs and tablets, so you are not locked into specific hardware. Keep your planning in Sheets if it suits your team, and let the platform handle scheduling, templates, QR codes, analytics and the screens themselves. The result is less babysitting. Clubs use it to keep class schedules current, restaurants to change menus fast, and one of our customers reported a 25% rise in class attendance after implementation. DKS
When a platform beats a spreadsheet workaround
The spreadsheet route is fine until one of these appears:
More than a few screens. Fixing a published link on ten displays by hand is a bad afternoon.
Different content by location. Franchises and tourism groups need one network with local variations.
Scheduling. Breakfast menu until 11, lunch after, happy hour at 4.
Non-technical staff. The person updating promotions should not need to understand cell ranges or sharing scopes.
Revenue from screens. If you want to sell or swap ad space with neighboring businesses, you need a system built for it.
Reliability. Cloud-managed players are built to keep running when a browser session would not.
That last point has a content side as well: heavy files cause frozen screens whatever the source, so review our file format preflight rules before you upload video. And if you are weighing the bigger picture, our beginner’s guide to digital signage platforms and our piece on why cloud-based signage helps businesses scale explain the shift in detail.
If your screens run Google TV, our walkthrough on Google TV digital signage for business shows what deployment looks like on that hardware.
Run your screens with SignStream
SignStream is a cloud-based digital signage platform for gyms, clubs, offices, restaurants, retail, franchises and tourism networks. You manage content from your phone or browser, schedule it, and push it to as many screens as you own. The SIGNSTREAM NETWORK plan is $10 per month per channel, and the CUSTOM CHANNEL plan is $105 per month per channel. See the current plans on our pricing page for what each includes.
If you would rather not set up hardware yourself, we also offer installation, content and design, and ongoing management, described on our how it works page. You can also use the built-in ad exchange to advertise directly with local businesses and earn from your own screens.
A simple rollout plan
If you are starting from a spreadsheet today, this order keeps risk low:
Pick one use case. A class schedule, a daily menu or a promotions board.
Build a display tab. Large type, short text, only the data you are happy to show publicly.
Publish and test on the real screen. Check legibility from the farthest seat in the room, and time how long edits take to appear.
Assign an owner and a backup. Two people should know how to update it.
Document the routine. A short checklist covering edit, check and refresh beats memory.
Review after 30 days. Count the manual steps. If updates are eating time or you want to add screens, move the content to a platform.
FAQ
Can I show a private Google Sheet on a digital sign?
Yes, but the app showing it needs authorized access. Google states that private spreadsheets require OAuth 2.0 credentials authorized for a Sheets API scope, and read-only access uses the spreadsheets.readonly scope. For a display, read-only is the right choice because the screen never needs to edit data.
Is it safe to publish a sheet to the web?
It is safe for information you would be happy to post on a window or website, such as menus, schedules and public offers. Anyone with the URL can view the published content, so keep personal, financial and sensitive business data out of it. Publish only the one tab the screen needs.
Why is my screen not showing the latest edit?
The most common cause is caching in the browser or on the server. Try a hard refresh, confirm the publishing setting is still on, and check that your published range includes any new rows. A scheduled page reload on the device keeps it current.
What should I put on a Google Sheet for a screen?
Choose short, frequently changing information: menu items and prices, class times, promotions with end dates, or two or three daily targets. Use large fonts, high contrast and one idea per screen so people can read it at a glance.
When should I move from Sheets to a signage platform?
When you add more screens or locations, need scheduled changes, or want non-technical staff to update content without touching the data. A platform also gives you analytics and a managed player, which a browser tab does not.
Sources
Recommended
Comments