Contact Us

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, open the Create Custom Graphic menu and select Google.

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 sign in to a Google account to allow access to your Google Drive. When you click Sign in with Google, a new browser window will open allowing you to sign in and allow this permission.

Once you see the Authorization Successful message, navigate back to Studio and select the document with the information you want to include in your graphic. The selected document’s data will populate on the right.

For the best experience, we recommend that your document not have more than 250 rows. You can use Google in multiple graphics layers if you need to show more data.

You can always use a different spreadsheet in your Google Drive by clicking the Change button. Spreadsheets will be ordered by most recently modified.

Scroll down to adjust additional settings for this layer. 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 in the settings to configure your Auto-Loop preferences, including how often Studio switches to the next row, the direction the loop should go, and where the loop should start from.

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 this  graphics overlay to be visible in Livestream Studio.

Have more questions? Submit a request