Using Google Sheets with uno Apps
Follow

Docs

Last updated: August 24, 2024 03:21

Certain uno apps from the Singular Template Library are designed to connect with Google Sheet data such as uno Flipper and uno Playlist. Seamlessly funnel your cell data the overlays in real time with the uno by Singular.live Add-on.

1 - Download an uno Template Designed to Work With Google Sheets

Find an uno app that works with Google Sheets and open it up.

2 - Duplicate App's Google Sheet

Navigate to the App'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 App

A. Install the "uno by Singular.live" 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 "uno by Singular.live"

uno

B. Open the Add-on Sidebar

To start using the add-on, open it into the sidebar. "Extensions" >> "uno by Singular.live" >> 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 within the "Field Mapping" Section of the Setup panel.

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

A Data Field option is a data column header text inside your Google Sheet.

Was this article helpful?

19 out of 23 found this helpful

Comments

11 comments

tyler.burgess
June 22, 2023 11:42

I've got a template that uses the Google sheets, and I've installed the Addon for Sheets. But when I go to "Add-ons" >> Singular is greyed out, any ideas how to fix?

I've granted the addon permission and just to be safe I set the sheet to not private and it's still greyed out.

1
roderickleverett
March 19, 2023 18:26

Where can I find the compatible uno playlist templates?

0
Mike
March 20, 2023 08:20
Hi Roderick,
You can download the UNO Playlist templates from the "Template Library".
1. Open the "Template Library"
2. Select "UNO" filter
3. Select "Playlist" filter
4. Select your favorite template
5. Click "Use this template" to add the template to your dashboard
tm
0
cerberus
March 22, 2023 10:24

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.

0
Kathryn
March 22, 2023 12:27

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".

0
cerberus
March 22, 2023 13:56

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?

0
Kathryn
March 22, 2023 14:14

cerberus There are templates in the Singular.live Template Library that work with Google Sheets. Here is one for example.

0
Kathryn
March 22, 2023 14:16

cerberus Here are all the Google Sheet type templates in the Template Library.

0
roderickleverett
March 22, 2023 14:17

Will these templates ever be included on the overlays.uno platform?

0
Kathryn
March 22, 2023 14:20

roderickleverett yes we have plans to release Google Sheet connected templates to overlays.uno platform

0
Kathryn
July 05, 2023 11:50

tyler.burgess can you check to see if this has been resolved? This might be related to you simultaneously being logged into two separate Google accounts.

0