Spreadsheet / Datatable Gadget

Mike Tinnes
Mike Tinnes
  • Updated

Formerly the Google Sheets Gadget.

The Spreadsheet / Datatable gadget displays tabular data on your digital signage. It supports three data sources: a published Google Sheet, a hosted CSV file, or a native Revel Digital Data Table. Once configured, the gadget keeps itself up to date on a refresh interval you control, and gives you full control over header/body styling, row density, and scrolling behavior.


Choose a data source

Add the gadget to a zone in your template, then double-click the zone to open its properties. The first setting, Data Source, determines the rest of the configuration:

Data Source Use when…
Google Sheet Your data lives in a Google Spreadsheet you can publish or share.
CSV You have a CSV file hosted at a public URL.
Data Table You want to display a Revel Digital Data Table managed directly in the CMS.

The fields shown below the Data Source selector change depending on which source you pick. Follow the matching section below.


Option A — Google Sheet

1. Create or open a spreadsheet

From your Google Docs account, create a new spreadsheet or open an existing one.

2. Generate a share link

From the File menu in your spreadsheet, click Share.

Google Sheets share menu

Copy the generated link and save it for the next step. Make sure link access is set so that anyone with the link can view the sheet, otherwise the player won't be able to read the data.

Copy Google Sheets share link

3. Configure the gadget

With Data Source set to Google Sheet, complete the following fields:

  • Published spreadsheet URL — paste the link you copied above.
  • Sheet Name (optional) — the name of the specific tab/worksheet to display (e.g. Sheet1). Leave blank to use the first sheet.
  • Cell Range (optional) — restrict the display to a specific range in A1 notation (e.g. A1:D20). Leave blank to display the full sheet.

Option B — CSV

With Data Source set to CSV, enter the public URL of your CSV file in the Published spreadsheet URL field. The file must be reachable by the player without authentication.


Option C — Data Table

With Data Source set to Data Table, select the desired table from the Data Table dropdown. Data Tables are created and managed directly in Revel Digital, which makes this the best option when your data is maintained inside the CMS, updated via the API, or populated by scheduled/AI-driven tasks — no external spreadsheet or hosting required.


Display options

These options apply to all three data sources and control how the table looks and behaves on screen.

  • Use first row as header — when enabled (default), the first row of your data is treated as a header row and rendered with the header style. Disable it if your data has no header row.
  • Header Style — font family, color, and size for the header row. Default: Open Sans, white, 24px.
  • Body Style — font family, color, and size for the data rows. Default: Open Sans, white, 18px.
  • Max Visible Rows (optional) — limits how many rows are shown at once. Leave blank to size to the zone.
  • Row Padding — vertical padding (in pixels) applied to each row. Default: 10.
  • Scroll Speed — how fast rows scroll when the content is taller than the zone: Fastest, Fast, Medium, Slow, or None. Default: None (no scrolling).
  • Scroll By — how the content advances when scrolling is enabled: Continuous (smooth, steady scroll) or Page (jump one page at a time). Default: Continuous.
  • Refresh Interval (minutes) — how often the gadget re-reads its data source. Default: 30 minutes.

Preview, save, and schedule

Click Accept to save the zone properties, then click the Preview button (green play icon) in the template designer to confirm your data and styling look correct.

Save your template and schedule it to play. Any changes to the underlying spreadsheet, CSV, or Data Table are automatically picked up on the next refresh, based on the Refresh Interval you configured.

 

Related to

Was this article helpful?

1 out of 1 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.