Where can I find the Google sheet Menuboard Apps?
The Signagelive Marketplace offers a selection of Google Sheets-enabled Menuboards, each with the ability to alter the title, text, pricing, and calorie information from your own Google Sheets document.
Head to the Signagelive Marketplace and search for Menuboard with GSheets. Once you have chosen your desired Menuboard app, add it to your Signagelive Network by clicking the Add to Signagelive button.
Please Note
For LG webOS devices - these Menuboard apps are only compatible with landscape orientations. A future release will make these responsive and therefore suitable to use in portrait too.
For BrightSign devices - the minimum firmware version of 8.*.* is recommended. You can download the latest supported BrightSign firmware here.
How do they work?
The Menuboard with GSheets apps allow you to populate menu items from your own Google Sheet. This allows you to make real-time changes without even having to enter Signagelive (once the menuboard is published to a Player). Simply add a new item/row to your Google Sheet and then your Player will download any changes automatically when it next performs a content check.
How to use the Menuboard with GSheets apps in your Playlists
Once you have the Menuboards in your Asset Library, you can drag and drop them into your desired Playlist. Double-click on the asset or click the 3 dots to enter the Properties area.
Within the Asset Properties, you'll be able to add the URL for your Google Sheet that will contain your menu items. You can also customize the font colours should you wish.
For a video walkthrough, please see below:
If you have different menus for different days, or different times of the day, be sure to edit the days/times it will show under the Recurrence tab.
Setting up your Google Sheet and configuring the Menuboard app
Head to Google Sheets and create a new Google Sheets document
Next, click on this template we've created for you
Copy and paste the contents from our template into your newly-created Google Sheets document
With your Google Sheet now created, you're ready to add this into the URL field of your chosen Menuboard app! To do so:
In Google Sheets (on your document), click the Share button in the top right
Change the General Access settings so that Anyone on the Internet with the link can view
Next, click Done (we saw you looking at the Copy Link button, and whilst it is tempting - this is not where we're going to get this URL from in this case)
With your document now open, take a look at the address bar of your web browser, notice this URL has "gid=" in the URL followed by a number. This is important, copy this entire URL including that gid number
Paste the full URL in the URL field of your chosen app
Press Refresh to confirm the data from your Google Sheets is populating within the app
Congrats! You just successfully configured your Menuboard app! Go ahead and publish this to your Player and you're good to go.
Please Note
Ensure that the URL you have copied from Google Sheets contains the gid number. See the Setting Up Your Google Sheet and configuring the Menuboard app section of this article if you are unsure what this is.
For reference, this URL will look something like this: https://docs.google.com/spreadsheets/d/1o23fdeItkmg3hWG6g42QHHSM8LuGiCVDqHKCf_BoWS8/edit#gid=0
Setting up a Local Version
As well as providing the Google Sheets version, there is also the optional widget that allows you to edit the values directly in Signagelive through the Widget preferences. This splits each field into an item name, item price and also item calorie information. There is also the option to change what the calorie unit being displayed is, as well as the currency symbol.