« Back to Knowledge Base
How to use Google Sheets with vMix Data Sources
Data Sources in vMix can be used to assign dynamic text and images to Titles from a variety of sources including Google Sheets, Excel, CSV, XML, RSS, JSON and Text.
See our tutorial video for more on vMix Data Sources: https://www.youtube.com/watch?v=t9CcKd9GeSY
This guide will explain the steps to add a Google Sheet data source into vMix.
To start with, you will need a Google API Key in order to use a Google Sheet within vMix. So firstly log into your Google Account and then go to the Google API Dashboard by visiting the following link: https://console.developers.google.com/
If you have created a project before you wish to use, select it from the top and then go to Step 4. Otherwise, if you haven't created a project before click the Create Project button.
Give your project a name and optional location and click the Create button.
Once your project has been created and selected, click Credentials from the left sidebar.
Then click the Create Credentials button and choose API Key.
(Do not worry about any mention of an OAuth which is not needed in this case)
A popup window will appear with your unique API Key. Make a copy of this as you will need to use it in vMix. You can then click the Close button.
Next, you will need to enable your Google Sheets API. To do that, click Dashboard from the left sidebar. Then select the Enable APIs and Services button.
Select Google Sheets API from the list.
Then click the Enable button. If Google prompts for additional steps after this, they can be safely ignored and the key will be ready to use.
Step 8Next, go to your Google Sheets account - https://docs.google.com/spreadsheets/. After selecting the Google Sheet you would like to use, click the Share button at the top right.
In the Get Link section make sure you click the option for Change to anyone with the link, so that it can be accessed by vMix.
Then select the Copy Link text next to the Google Sheets URL. This unique link to your Google Sheet will be automatically copied to your clipboard. Or you can copy it from the field it provides.
We can now add our Google Sheet into the Data Sources manager in vMix. To do that, click the hamburger menu button from the bottom right (3 lines button) and choose Data Sources Manager.
From the top left click the plus icon button and choose Google Sheets.
In the URL field, put the Google Sheets URL from Step 8. In the Google API Key field, put the Google API Key from Step 5. Then press OK.
Your Google Sheet is now ready to use in vMix Data Sources.
Last Updated: Monday, 6 July 2020 4:07:20 PM