Great tutorial! I found 2 bugs in the software which may have caused people following issues. If your Sheet where your cell is has a "space" in its name or no characters only numbers, it won't work. Sheet 1 and 180 only worked with the SET function for me. When I added a new page or renamed one without spaces and had characters in it, SET INCREASE and DECREASE worked fine. Also, the cell should have your sheet name in the beginning. I thought "Control" was a function, but it was actually the name of your sheet yes? :) Sheet5!C3 worked for me. I reported the bugs to companion. Thanks for the tutorial again, everything else worked like a charm!!
Heres a tricky question. I have some scripts that trigger google sheet manipulation (copy and paste column and move them around) when a cell is edit (onEdit script) When i change the cell value manually it triggers the script, but when i change the cell value via the companion action, it doesnt trigger the script. Its like the value has changed but the script doesnt know about it and then isnt triggered. Any ideas why?
@@adamngakiri I'll have to do some testing myself to figure this out, but I'm wondering whether changes that are made via the API aren't classed as changes by a user which I'm pretty sure is what the onEdit script looks for, are you able to provide me with the script so I can test today? If so, email it to jmurton@jakeyboyproductions.com
Hi thanks for the video it really helped. Doyou perhaps know why only the first 4 variables are available to me, I can't in any form pull data from Google Sheets, only send
Have you setup an API key for Google sheets? It's one thing I think I missed from the video, without an API key I don't think you'll be able to pull data
Would this module make it possible for Stream Deck button text to be populated from a Google Sheet? For example, I use a Google Sheet as a vMix data source to centrally manage my lower third names/data… It would be awesome if my Stream Deck buttons could also pull their text labels dynamically from the same Google Sheet… So if I modified the sheet to replace Paul’s lower third data with Sally’s, both my vMix title graphic AND stream deck button that triggers it would change from “Paul” to “Sally.”
Yes, that is something I missed out in the video, but under companions tab of "variables", the modules gives you examples on how to turn your datasheet into variables for use within button names! For example: imgur.com/MwTWN4U in this image, I have it so all of the team names dynamically update and also the scores on the right side dynamically update to the values of the teams that were taking part in those days.
@@JakeyBoyPro so just to clarify, I could use player numers that are on a google sheet - and use these numbers to populate the titles on the stream deck buttons? At the moment I am haing to manually enter these over many sheets for each different game with all the player numbers. i could use this to populate the titles from a data source?
@adamngakiri yes, you can have companion set the value in the cell to a specific number and have that number then update as the title of the button if required
Hi, thanks for the step by step. Until 6:11 everything is fine. But @6:11 you are selecting your spreadsheet, which appear. Mine doesnt appear (no choice under "select spreadsheet". Any idea why it doesnt display the file ?
Hi Arnaud, Have you completed the step from 4:11 onwards? You have to add the spreadsheet ID into the bitfocus module in order for it to see the spreadsheet.
@@arnaudbessat This only applies if you're adding multiple Google Sheets to your config, so only a space is required at the end if you're adding a 2nd Spreadsheet ID
![Easiest Google sheets integration to OBS w/ FREE API plugin [Tutorial]](/img/n.gif)
Very very clever ! Vrry thorough process and explanation. Learned a lot. Thank you sir
Definitely thank you for this guide!!
Great tutorial! I found 2 bugs in the software which may have caused people following issues. If your Sheet where your cell is has a "space" in its name or no characters only numbers, it won't work. Sheet 1 and 180 only worked with the SET function for me. When I added a new page or renamed one without spaces and had characters in it, SET INCREASE and DECREASE worked fine.
Also, the cell should have your sheet name in the beginning. I thought "Control" was a function, but it was actually the name of your sheet yes? :) Sheet5!C3 worked for me. I reported the bugs to companion. Thanks for the tutorial again, everything else worked like a charm!!
Yeah, I discovered the sheet name bug a while ago, took me forever to diagnose it lol and correct, my sheet name was control in this example!
Heres a tricky question. I have some scripts that trigger google sheet manipulation (copy and paste column and move them around) when a cell is edit (onEdit script)
When i change the cell value manually it triggers the script, but when i change the cell value via the companion action, it doesnt trigger the script. Its like the value has changed but the script doesnt know about it and then isnt triggered. Any ideas why?
@@adamngakiri I'll have to do some testing myself to figure this out, but I'm wondering whether changes that are made via the API aren't classed as changes by a user which I'm pretty sure is what the onEdit script looks for, are you able to provide me with the script so I can test today? If so, email it to jmurton@jakeyboyproductions.com
Hi thanks for the video it really helped. Doyou perhaps know why only the first 4 variables are available to me, I can't in any form pull data from Google Sheets, only send
Have you setup an API key for Google sheets? It's one thing I think I missed from the video, without an API key I don't think you'll be able to pull data
@@JakeyBoyPro yes I have, I already have multiple that I've set up for use with vMix
Would this module make it possible for Stream Deck button text to be populated from a Google Sheet? For example, I use a Google Sheet as a vMix data source to centrally manage my lower third names/data… It would be awesome if my Stream Deck buttons could also pull their text labels dynamically from the same Google Sheet… So if I modified the sheet to replace Paul’s lower third data with Sally’s, both my vMix title graphic AND stream deck button that triggers it would change from “Paul” to “Sally.”
Yes, that is something I missed out in the video, but under companions tab of "variables", the modules gives you examples on how to turn your datasheet into variables for use within button names! For example: imgur.com/MwTWN4U in this image, I have it so all of the team names dynamically update and also the scores on the right side dynamically update to the values of the teams that were taking part in those days.
@@JakeyBoyPro so just to clarify, I could use player numers that are on a google sheet - and use these numbers to populate the titles on the stream deck buttons? At the moment I am haing to manually enter these over many sheets for each different game with all the player numbers. i could use this to populate the titles from a data source?
@adamngakiri yes, you can have companion set the value in the cell to a specific number and have that number then update as the title of the button if required
Hi, thanks for the step by step. Until 6:11 everything is fine. But @6:11 you are selecting your spreadsheet, which appear. Mine doesnt appear (no choice under "select spreadsheet". Any idea why it doesnt display the file ?
Hi Arnaud,
Have you completed the step from 4:11 onwards? You have to add the spreadsheet ID into the bitfocus module in order for it to see the spreadsheet.
@@JakeyBoyPro I think I did it ( @4:39 ). Space separated ? have you put spaces before and after the ID ?
@@arnaudbessat This only applies if you're adding multiple Google Sheets to your config, so only a space is required at the end if you're adding a 2nd Spreadsheet ID
@@JakeyBoyPro Got it for multiple spreadsheets. ---- Still doesnt work for me, the sheet's url/ID is good, but I cant select the spreadsheet :(
@@arnaudbessat Do you have the spreadsheet set to "Anyone with the link can view/edit" if you don't own the sheet yourself?