Cards: Display Google Sheets Data

This article provides the instructions to create and configure a Google Sheets card, ideal for displaying information from a Google Sheets file on a display screen.

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.

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

What’s in this article:

Prerequisite

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.

Create Shareable Link

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.

Configure Google Sheets Card

The instructions below allow you to display Google Sheets data.

  1. Log in to the Appspace console.
  2. To create this card, select one of the following options:

    • Click +QUICK ACTION from the Appspace menu bar on the top right, and select Create Content.
    • Click Library from the ☰ Appspace menu, and select a library or folder you wish to create the content in. Click +CREATE, and select Content.
    • To create and add the card directly to an existing channel, refer to Add Content to Playlist Channels.
  3. Select Feeds from the All Templates drop-down menu, and click Google Sheets.

    Important
    If you are unable to locate the content, try using either the Search bar, the Order by, or Filter icon to narrow down the content that you are looking for.
  4. In the Edit tab;

    • Enter the Title of the content as this will also act as the filename for the content. This is a mandatory field.
    • Enter the Google Sheets shareable URL obtained earlier in the URL field.
    • 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.

  5. In the Article tab; This section may be skipped.
    • Include an Article or Caption to accompany the content item when being displayed on mobile apps, tablets, and other social collaboration apps.
    • Enter a Referral Link to link more information to the content.
  6. In the Schedule tab; This section may be skipped.
  7. In the Settings tab; This section may be skipped.
    • The Name field will be auto-populated to match the Title of the content which will also act as the filename for the content. This is a mandatory field.
    • Enter any relevant Tags for the content. (Optional)
    • Select a folder for the content in the Library Location drop-down menu to change the default folder location.
    • Select an expiry date for the content from the Auto Delete Content from Library drop-down menu. (Optional)
    • Upload an image to be used as the Thumbnail for the content.
  8. Once done, click SAVE.

Edit Google Sheets Card

The instructions below show you how to edit a Google Sheets card.

  1. Log in to the Appspace console.
  2. Click Library from the ☰ Appspace menu, and select a library or folder containing the content you wish to edit.
  3. Select and click the Google Sheets card to edit, and select the desired tab to edit or view.
    • In the Edit, Article, and Settings tabs:
    • In the Preview tab:
      • Preview how the content is displayed on your device.
    • In the Channels tab:
    • In the Analytics tab:
      • View the individual content analytics in this tab. For more information, please refer to the Individual Content Analytics section of the Analytics article.
  4. Once done, click SAVE.
Related Articles