Contact Us

Integrate Google Spreadsheets in Studio Graphic Layers

As of October 2024, private Google spreadsheets are no longer displayable via GFX layers in Livestream Studio. 

We recommend using another gfx data source or using a public spreadsheet that does not contain private information

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.

Enter in the URL for the public Google sheet.

screenshot showing where to enter URL

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

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

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.

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.

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