Contact Us My Activity Community

Integrating Google Spreadsheets

An easy way to integrate and manage data in a graphics overlay from an external source is to use Google Sheets. Livestream Studio can integrate up to 15 Google Sheets graphics layers; this is an authorization limitation determined by Google.

Navigate to a graphics overlay track and select Google from the New Layer menu.

You do not need to log in if you select Enter a public Google spreadsheet. Selecting this will allow you to enter the document’s URL.

If you want to use your own private Google document, you will need to log in to a Google account to allow access to your Google Drive.

The Google module will ask permission to view and manage your spreadsheets. Click Accept.

Once you have access to your Drive, select the document with the information you want to include in your graphic. The selected document’s data will populate on the right.

Once you select your spreadsheet, click the Back button to access settings for this layer.

You can always use a different spreadsheet in your Google Drive by clicking the Change button.

To turn your first row into column titles, check Use first row as column titles.

Click on any column title to change the type of data included in that field (text or image).

Uncheck Read only if you want to be able to edit the information within Livestream Studio. Otherwise, changes can only be made in Google Docs.

Scroll down further in the settings to configure your Auto-Loop preferences.

The next step is to start designing your graphic. Click on the paintbrush button to enter the GFX Designer.

In the Google Spreadsheet layer, click on the list icon to see your columns. Click on one to insert it into the GFX Designer.

Click on the gearwheel button to access more options for your font, colors, etc.

Close out of the GFX Designer when you have finished. In the graphics overlay channel, click Back in the upper right corner to return to the layer module.

Make sure the Google spreadsheet layer is visible by selecting the eye icon. This will allow you to include information from your spreadsheet as a graphics overlay in Livestream Studio.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.