How to use Google Sheets with OptiSigns

You can set up Google Sheets with OptiSigns so that whenever changes are made on Google Sheets it will automatically show up on your screen.
You can also use the Website app with your Google Sheets. Here is the link.

In this guide, we will walk you through end to end process to use Google Sheets in OptiSigns.

How to use Google Sheets with OptiSigns

1. Go to your Google Sheet.
Click File -> Publish to the Web

googlesheet-1.png

The "Automatically republish when changes are made" is checked by default.
Click Publish and you will get a link. Copy that link.

googlesheet-2.png

2. Go to our portal: https://app.optisigns.com/
Go to File/Assets and click App.
Add Google Sheet App:

googlesheet-3.png

There are two options to enter your Google Sheets.

  • Enter your Google Sheets link directly.
  • Sign in with Google, and select your Google Sheets

Option 1: Enter your Google Sheets' information.

googlesheet-4.png

  • Name: This is the name to organize assets, it will not be shown on the screen.
  • URL: This is the Google Sheets link that you got from Publish to the Web in your Google sheets.

Option 2: Sign in with Google Account

googlesheet-5.png

  • Name: This is the name to organize assets, it will not be shown on the screen.
  • URL: This is the Google Sheets link that is auto-generated.
  • Select Sheet: You can select which sheet will play on your screen.
  • Update Interval: Google Sheets is auto-update by default. You can also input an interval here on how often you want to refresh the content.
Click Save.
After Saving, you can Preview it. 

That's all! Congratulation!

You have created your Google Sheets.

You can assign the newly created wall to your screen by going to Screens, click Edit screens, and assign the Google Sheets to screens that you want.

You can put the created Google Sheets in a Playlist, Schedule too.

 

If you have any additional questions, concerns or any feedback about OptiSigns, feel free to reach out to our support team at support@optisigns.com or just submit a ticket here.

 

 

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.