Google SheetsTutorial

Google Sheets

January 29, 2018

What is Google Sheets?

Google Sheets makes your data pop with colorful charts and graphs. Built-in formulas, pivot tables and conditional formatting options save time and simplify common spreadsheet tasks. All for free.

What else should I know?

When using the Google Sheets Integration in your Live Playlist, your screens will update automatically (within a few minutes) after changes have been made to your Google Sheet.

Integration Requirements

  • You must have a digital sign player with a serial number starting with: 800a or d076
  • This integration requires a constant, reliable and stable internet connection at all times
  • Please consult with your network administrator

Step 1: Select the Google Sheets Integration from your template library and click “Install”.

Screen Shot 2018-03-23 at 6.15.54 PM

Step 2: Once in the “My Templates” area, select the Google Sheets Integration and click “Edit”.

Screen Shot 2018-03-23 at 6.18.06 PM

Step 3: Click the “Edit Template” button towards the top of the screen.

Screen Shot 2018-03-23 at 6.31.18 PM

Step 4: Click the “Edit Mode Active” bar towards the top of the screen.

Screen Shot 2018-03-23 at 6.19.07 PM

Step 5: Enter the shareable Google Sheets link and click “Save”.

Screen Shot 2018-03-23 at 6.20.27 PM

Step 6: Click “Save Changes”.

Screen Shot 2018-03-23 at 6.27.17 PM

Step 7: Then click “Back”, include the template in your playlist, and enjoy your Google Sheets Integration!

‍