Contact Us

Integrate Google Spreadsheets in Studio Graphic Layers

One 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 graphic layers; this is an authorization limitation determined by Google.

Navigate to a graphics overlay track, open the Create Custom Graphic menu and select Google.

the graphics panel showing the create custom graphic opened, highlighting the Google option.

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

The google graphic layers settings before a sheet is added, showing 'enter a public spreadsheet' option selected.

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.

google spreadsheet layer settings, showing 'select from my google spreadsheets' selecting and a prompt to sign in with google.
google permission prompt

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.

google sheet layer settings, showing a spreadsheet selected on the left and columns and rows of information on the right.

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

google graphic layer settings, highlighting the 'change' button next to the spreadsheet name.

Scroll down to adjust additional settings for this layer. To turn your first row into column titles, check Use first row as column titles.

google graphic layer settings highlight the checkbox labeled 'use first row as column titles' and showing the column titles.

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

the data portion of the layer, showing the column menu open and highlighting the 'change to image column' option.

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.

google sheet graphic layer settings, highlighting a unchecked box label 'read only' and showing text being edited.

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.

google sheet graphic layer settings showing auto loop options such as time interval, restarting, and direction.

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.

the bottom of the graphic designer window, highlighting the Google Spreadsheet layer being selected and the data dropdown menu being opened.

Click on the gearwheel button to access more options for your graphic element's appearance.

the graphic designer window, showing one text data element being selected and gearwheel option being opened showing appearance settings.

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.

google sheet layer settings highlighting the back button.

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.

the google sheet graphic layer, highlighting the eye icon being turned on.
Have more questions? Submit a request