Using Google Sheets with VMIX - Part 1

[@KBlidkvist]

Hey there! Greetings from Sweden. I have been trying to figure this out all day and just as I am about to give up and call it the day I see that you have done a livstream. You just saved me tomorrows headache. Thank you!

[@StreamingAlchemy]

Hi Kim - I'm glad what we covered was able to help with your upcoming production. If you have any other production/streaming related topics you'd like us to dig in to on Streaming Alchemy, just let us know. Thanks for watching!

[@BillAshtonNelo]

Amazing

[@vighnesh.acharya]

Is there any option to pay google cloud platform to get more speed or read and write qouta increase???

[@StreamingAlchemy]

Hi @vighnesh.acharya - Unfortunately there isn't an option to increase the default query quota that Google allows. I know a LOT of people that would love to increase that, but it just isn't something they offer. Thanks for watching! Best, -j

[@navalc9]

This tutorial helped learn how to use G-sheet and Vmix. I'm really thankful. Although I have a doubt. The scripting part was cool as it was automatically going to the next row. I wanted to explore the possibility of automatically displaying the lower third when a new row is added instead of me clicking a button. Will that be a possibility?

[@nash97778]

Great video. I follow all the steps to import data from Google Sheets. but I am getting an error message 'The remote server returned an error 400'

[@SeanTolan_illuminated_imaging]

I did too...I had forgot to share the Google sheet

[@StreamingAlchemy]

Hi @nash97778 - Let me know if @SeanTolan's suggestions worked for. Thanks for watching! -john

[@StreamingAlchemy]

Thanks @SeanTolan!

[@manuelpaech4012]

Hi, is it free to use API key, or do you need to pay monthly?

[@StreamingAlchemy]

The Google API Key is currently free. There may be some limitations of the use of it vs paid accounts, but I'm not aware of anything specific that is deprecated. Best, John

[@crooker2]

Hmm... If you have people pushing images to an external source... Does GT Title designer scale those images?

[@StreamingAlchemy]

Hi Dave - I believe that GT Title Designer will scale any mapped image to fit within height and width, but without changing the aspect ratio. This means you will have the entire mapped image visible and undistorted, but potentially with 'dead space' around a centered image. Hope this helps!

[@crooker2]

@@StreamingAlchemy Helps alot. Do you know if you can use video in a GT Title? I want to create a title (say a full screen graphic), but have a 'flowing' background over the graphic. I don't think you can layer a video underneath a title without using a script or triggers or something. Thanks for your advanced Vmix tutorials. I'm a pretty smart guy, but this stuff stretches my brain!

[@SeanTolan_illuminated_imaging]

I love the concepts, but somehow when setting up selected row and dynamic value stream deck shortcuts, the selected row button works on the stream deck, but the dynamic value one does not. I rewound your tutorial a hundred times and gave up out of frustration as it moves fast there, is hard to follow, and I just feel like an idiot at this point...lol UPDATE: I was being an idiot. When inputting Dynamic 1 in the parameter field for the selected row in the Vmix shortcut it cannot have a space in between Dynamic and the number 1: Should look like this Dynamic1

[@StreamingAlchemy]

Hi @SeanTolan_illuminated_imaging - Glad you were able to figure it out. I know how hard those little mistakes in syntax can be to find. Thanks for watching! Best -john

[@DJGeek]

I get a forbidden error message. Am I doing something wrong?

[@StreamingAlchemy]

Hi Charlie - You will need to make sure allow access to the sheet for anyone with the URL. That is probably the issue you are seeing. Thanks for watching!

[@vmixkchschsla489]

This is exactly what I was looking for to use with my students in our daily broadcast to change our many OTS (Over-the-Shoulder GFX) using one button on XKEY! Do you have the needed notes to help to do the process with GOOGLE Sheet API kit? Can you show or share your script you use with your streamdeck ( Select previous - Select next) It will be very useful. So many questions... for later! LOL! It's fantastic! Much appreciated!

[@StreamingAlchemy]

Hi vmixkchs - The scripts we develop for our shows are available in a public GitHub repository: github.com/StreamingAlchemy/StreamingAlchemy You should be able to download what you need from there. We tried to cover everything you'd need to connect Google Sheets with vMix in the video here. Let me know if you have specific questions and I'll try to clarify any points we may have missed or glossed over. Thanks for watching! PS - Would love to see what your students are producing if any of it is available publicly. Thanks for teaching these skills!

[@rochdufresne3139]

@@StreamingAlchemy Yes, it will be our pleasure to share your production! Coming up soon! Thanks for your help!

[@ezekielmakis6755]

hi from Papua New Guinea

[@HasanAlahdal]

شكرا لك

[@StreamingAlchemy]

أنت مرحب بك!