How to set up Google Spreadsheets on Rise Vision

  • 1
  • Article
  • Updated 3 years ago
  • (Edited)
This article will walk you through how to get your Spreadsheets set up on your display as well as outline the configuration options our widget offers.

First, let’s head on over to our spreadsheet.

Click ‘File’ and then select ‘Publish to the Web..’ in the dropdown. Hit ‘Publish’ in the configuration window that pops up.

Screen Shot 2015-10-27 at 21316 PMpng

Screen Shot 2015-10-27 at 22334 PMpng

Next, it is very important that we set our spreadsheet to public. Otherwise, the spreadsheet will not appear on your display.

Let’s go to ‘File’ again and select ‘Share’ from the dropdown.

Screen Shot 2015-10-27 at 22545 PMpng

booppng

step3 copypng

step2png

Remember to hit Save.

Now that we’ve got our spreadsheet configured properly, let’s head on over to the new editor.

Select the green ‘Add Placeholder’ button on the top right. Screen Shot 2015-10-27 at 34355 PMpng

Now, click on the newly added placeholder that will appear on the left. Hit the ‘Playlist’ tab and hit the ‘Add Playlist Item’ button.

Screen Shot 2015-10-27 at 34241 PMpng

Select ‘Content’ from the dropdown. You will then be forwarded to our store where you can locate our Spreadsheet Widget. Click the green ‘Add’ button.

Next, click ‘Google Spreadsheet’ beside ‘Content:’ to access your settings:

Screen Shot 2015-10-27 at 24452 PMpng

In your configuration settings you will be able to pull your spreadsheet from your Google Drive folder.

Under ‘Include’ you can choose between displaying your entire sheet, or a particular range within your sheet:

Screen Shot 2015-10-28 at 22725 PMpng

If you select the ‘Range’ option, this will allow you to manually input the rows. For example, if I just want the first 3 rows on my spreadsheet to display on my presentation, I would enter A1:B3, which would cover the following area of the spreadsheet:

Screen Shot 2015-10-28 at 23307 PM copypng

Remember you must include the ‘:’ between the range.

Header Row: If you’d like, you can specify how many rows in the spreadsheet are header rows in the dropdown. These header rows will be excluded from the spreadsheet data and added to the top of the widget. Otherwise, the widget will read and extract the header rows for you.

Table Format: Select which columns to format. You can assign header text, as well as adjusting the width of the column in pixel format. This also includes alignment options.

You are also able to Scroll through your spreadsheet where you can adjust the speed and direction.

Screen Shot 2015-10-28 at 23656 PMpng

Row Padding: Set the space between rows. You can also set a row color and an alternative row color.

Under data refresh interval you can set how often to refresh your spreadsheet to check for updates. This way, your changes will be shown automatically without having to re-publish your presentation.

You can also select from an array of custom fonts and colors to customize your spreadsheet, this includes setting a background color and adjusting the opacity.

Layout: Select ‘Use default layout’ for a standard spreadsheet, or enter in a custom URL if you’ve developed your own.

Remember to hit ‘Save’. Congratulations! Your spreadsheet should now be ready to present on your display.
Photo of Ashleigh

Ashleigh

  • 3,740 Points 3k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Robb

Robb, Official Rep

  • 76,676 Points 50k badge 2x thumb