SpreadSheet_to_OBS

SpreadSheet_to_OBSv1

Send Spreadsheet data to OBS text source
Currently only work on the first column of the spreadsheet (the sheet must be named "Feuille 1" sorry lol)

Requirement :

• Windows 10
• OBS Studio
• obs-websocket from @LePalakis

Setup :

• Follow step and create credentials in Google API Console
• Step by step screenshot
• Download the .json file, rename it service_account.json and copy into the script folder.

Edit Config:

Open config.ini

[DEFAULT]
url = https://docs.google.com/spreadsheets/d/url123456
timer_refresh = 5
max_row = 2
obswebsocket_ip = localhost
obswebsocket_port = 4444
obswebsocket_pw = password

• url : Replace URL with a spreadsheet host in your own Google Drive (currently doesn't work on a spreadsheet not owned by your account)
• timer_refresh : number of seconds beetween refresh (don't put a low value or you will be blocked by Google API)
• max_row : number of row/text fields sends to OBS
• obswebsocket_ip = IP/Localhost
• obswebsocket_port = Port
• obswebsocket_pw = Password

Usage :

• Launch OBS
• Launch Script or .exe
• Edit the name of your text source in OBS to work properly with the script, must be 1_TXT / 2_TXT etc... (don't edit text name in the script)
• Click Start

Example video

Follow me :

• @Prosperelucel
• Prospere on Twitch
• My Discord
• Buy me a coffee