This article provides the instructions to create and configure a Google Sheets card, ideal for displaying information from a Google Sheets file on a TV, by simply configuring the card with:

  • a shareable public link to a file on Google Drive, for G Suite accounts without administrative authentication controls.
  • a shareable private link to a file on Google Drive, for G Suite accounts with administrative authentication controls.

If your organization has administrative controls enabled for your G Suite accounts, then an Appspace account owner/administrator must configure the Google Sheets card theme to input the Google authentication credentials in place. A user who wishes to display his Google Sheets file via the card, must then make the file shareable and publish to the web, before adding the link in the card. 

Important

What’s in this article:

Prerequisites

Configure Google Sheets Card

To configure the card, follow the instructions below:

  1. Configure Google Authentication (Optional)
  2. Create a Shareable Link
  3. Create and Configure Google Sheets Card

Configure Google Authentication

Important
You may skip this section if your Google Drive does not have a G Suite account with administrative controls.

Follow the instructions below to configure the Google Sheets card theme with the G Suite account authentication. Appspace Account Owner role required.

  1. Log in to the Appspace console.
  2. Navigate to System > Cards from the Appspace menu on the left navigation bar, and click the Themes tab.
  3. Select Google Sheets from the Filter By drop-down menu, and click the Duplicate icon of the Base Theme.
  4. Enter in a name for the card theme, and click the Authenticate button.


  5. In the Sign in with Google window, select or enter in your G Suite credentials, and click Allow to enable Appspace to access the Google account.
  6. Click Save once the card is authenticated.

Follow the instructions below to create a shareable link to your file on Google Drive:

  1. Follow the steps outlined in the Publish a file to the web section, from this Google Help site: https://support.google.com/a/users/answer/9308870
  2. Click the Publish button, and close the window.

  3. Once done, follow the Share a single file instructions in the Step 1: Find the file you want to share section, from this Google Help site: https://support.google.com/docs/answer/2494822
  4. In the Step 2: Choose who to share with & how they can use your file section, ensure you select one of the following options:
    • Share a link to the file – Select this option to get a shareable link to a secured Google file, to be used in an authenticated Google card.
    • Share a file publicly – Select this option to get a shareable Google file, to be used in an unauthenticated Google card.
  5. Copy the shareable link to the Google file and proceed to the next section below. 

Create and Configure Google Sheets Card

Follow the instructions below to create and configure the card. Account Owner, Publisher, or Editor (author) role required.

  1. Log in to the Appspace console.
  2. Click the QUICK ACTION menu on the top right, select Create Card, and proceed to step 4 below.
    Or click Library from the Appspace menu navigation bar on the left, and proceed to step 3 below.
  3. Select the desired folder in the library, click the ADD button, and select Create Card.
  4. Select Google Sheets from the Filter by template menu, and select a desired card template.

  5. Enter in the Google Sheets shareable URL obtained earlier, and click Next.
  6. Select the zoom level of the spreadsheet. By default, the value is set to 100%, and anchors to the top right corner.

    This can be used to only display certain portions of the spreadsheet.


  7. Once customizations have been made, click Next.
  8. In the Save tab, enter in the Title, as this is a mandatory field.
    Optionally, you may enter in the ArticleCaptionContent ExpiryContent Tags and even upload a custom thumbnail for the content.
  9. Click Save to complete, and you may now proceed to add the card into a playlist channel.