Use a Google Sheet as a live data source in a template: the table on your screens follows the sheet, so you update menus, rosters or event schedules by editing the spreadsheet.
How to Use Google Sheets for Dynamic Data
Step 1: Open a Template in the Editor
Add a template to a playlist layer and click Open Editor. See Templates. Leave space in your design where the data will go.
Step 2: Share Your Google Sheet
- In the editor, click Data Sources in the left menu, then Google Sheets.
- The panel shows an email address under “Share your Google Sheet as a viewer with the email address provided below.” Click the copy icon next to it.
- In Google Sheets, click Share, paste the address, choose Viewer and click Share.
Keep the sheet as a plain table, with the same number of columns in every row.
Step 3: Add the Sheet
- Back in the editor, enter a Name for the sheet and paste the sheet’s link in Google Sheets URL. The link looks like
https://docs.google.com/spreadsheets/d/…. - Click Add.
The sheet is also saved to your account, so next time you can pick it from Choose a saved sheet instead of pasting the link again.
Step 4: Choose the Tab and Add the Data
- The panel shows the file name and its tabs. If they don’t appear, click Refresh Data.
- Under Sheets, choose the tab to use (Choose a sheet) and click Save. A template uses one tab.
- Click Add to template. A table with the sheet’s data is added to your design.
- Position and style the table like any other object, then save the template.
To stop using the sheet, click Delete in the panel.
How the Data Stays Up to Date
- When you change the sheet, the table on your screens updates automatically, usually within minutes.
- To pull the latest data straight away, open the template and click Refresh Data.
Use Cases
This integration is ideal for:
- Restaurant menus with daily specials
- Employee rosters
- Event schedules
- Any template requiring frequent data updates
For data from a JSON API instead of a spreadsheet, see Data Sources.