Display data tables from Google Sheets on your screens

If you are using our Google Sheets integration, you can use data from a Google report to show lists of information that are not necessarily related to users. For example, you may want to show a list of last month’s “Top 10 Opportunities”. Data Tables pull data directly from Google reports, and update on a regular schedule.

How to Configure a Data Table

1. In Configure > Integrations > Google Integration, find the section called Data Tables.

2. Click Add.

3. Use the dropdown to select a Google Sheet to map into Hoopla Next, select a Sheet Tab

4. Optionally, change the report’s name in Hoopla.

5. Select up to 4 columns from the report. The order in which you make your selections will determine the order on Hoopla TV, from left to right.

6. Optionally, change each column’s label in Hoopla.

7. Schedule how often you want Hoopla to sync with the Google report.

8. Click OK, then Save.

9. Next, add that Data Table to your Channel(s).

How to Add a Data Table to a Channel

1. In the Channel configuration page, you will see a Data Table tile as an option in the left-most pane.

2. Click and drag the Data Table tile to your Lineup, and select a Data Table from the drop-down menu in the right-most column.

3. Configure the step details in the right-most column.

• Number of rows to display

• Transition

• Background

• Duration

• Column Width, as a percentage of screen width

Finally, Save your Channel.

Related articles

• Connect Hoopla to Google Sheets Connect Hoopla to your Google account so you can export metric data to Google Sheets and import calculated data back into Hoopla.
• What are Data Tables? Understand how data tables show list-style information that isn’t tied to users, and the four sources you can build one from.
• Add content to your Hoopla lineup Add steps to a channel or reusable segment, from leaderboards and newsflashes to videos, web pages and countdowns, and configure each type.