Certain UNO templates from the Singular Template Library are designed to connect with Google Sheet data such as the UNO Flipper and UNO Playlist type templates. Seamlessly funnel your cell data the overlays in real time with the Singular.live UNO Add-on.
1 - Download an UNO Template Designed to Work With Google Sheets
Find an UNO template that works with Google Sheets and open it up.
2 - Duplicate Template's Google Sheet
Navigate to the template's Setup panel and select the CONNECT TO GOOGLE SHEET button under "Data Source".
Selecting the button duplicates a specific Google Sheet into your account, allowing you to have control over the data.
3 - Connect the Google Sheet to your Template
A. Install the Singular.live UNO Add-on
In your new personal Google Sheet, navigate to "Add-ons" >> "Get add-ons" if not yet installed >> search for Singular.live and download "Singular.live UNOs"
B. Open the Add-on Sidebar
To start using the add-on, open it into the sidebar. "Add-ons" >> "Singular.live/UNOs" >> Open Sidebar
C. Paste Information into Sidebar
Copy/paste Access Token
Copy the Access Token from your template and paste it into the Token field in the Google Sheet Add-on sidebar.
Select Cell Range
Select the cell range of data you want to use in your template. Make sure you include your column header text in the range as this is necessary for proper data mapping!
4 - Map Data
Now that your Sheet has been successfully connected to your template, you'll need to map your Sheet data to the desired control points.
Choose a Google Sheet Data Field for each Control Node ID parameter to make sure your data goes to the correct areas of your overlay. Note that a Data Field option is a data column header text inside your Google Sheet.
Where can I find the compatible uno playlist templates?
You can download the UNO Playlist templates from the "Template Library".
I have the same issue as roderickleverett
Followed the advice from support......
There are no templates that use google sheets in the Template Library.
The filter options for 'data source' are:
Census.gov - 2 templates
Crypto.com - 5 templates
Manual - 334 templates
Weather API - 19 templates
None of the available templates appear to use a GoogleSheet as the data source.
cerberus are you using Singular.live or overlays.uno? The Template Library in Singular does have Google Sheet connected templates as outlined by the original comment or by simply searching "google sheets".
I'm using Uno Overlays.
This article is about using Google Sheets with Uno. It says right there in the article: "Find an UNO template that works with Google Sheets and open it up".
But there are no UNO templates that work with Google Sheets, by design?
So.... what is the point of this article? But worse, If you can't point UNO at dynamic data then... what's the point of UNO?
cerberus There are templates in the Singular.live Template Library that work with Google Sheets. Here is one for example.
cerberus Here are all the Google Sheet type templates in the Template Library.
Will these templates ever be included on the overlays.uno platform?
roderickleverett yes we have plans to release Google Sheet connected templates to overlays.uno platform