Integrating Google Spreadsheets

To integrate information from a Google spreadsheet into Livestream Studio, select ‘Google’ from the graphics 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


Please sign in to leave a comment.