Spread Sheet Guide

What is Spread Sheet?#

Spread Sheet is an OBS widget feature that detects donation messages and automatically adds donation amounts to a spreadsheet-style table. When a donor enters a trigger word within the set time (default 13 seconds) after donating, the cell value changes by the donation amount.

Table Structure Setup#

• Set the number of rows and columns.
• Set the number of fixed columns. (Fixed from left, used as row headers)
• Click the ‘Apply Table Structure’ button to generate the table in preview.
• You can directly enter header (column title) and fixed column values.

Trigger Word Setup#

• Click a cell in the preview where the value should change.
• Enter a word in the trigger word settings panel and click the ‘Add’ button.
• You can set multiple trigger words for a single cell.
• If the ‘Subtract’ checkbox is selected, the donation amount is deducted when the word is detected.
• Trigger detection time: Set the time window to detect trigger words after a donation (1-60 sec, default 13 sec).
• Min donation count: Only donations at or above this amount are reflected in the table.
• Reference platform: Converts donations from multiple platforms to a single reference standard.

Style Settings & Create URL#

• Customize font, color, border, background opacity, etc. as desired.
• Once setup is complete, the URL is generated automatically.
• Copy the generated URL using the ‘Copy URL’ button.
• Paste the URL in OBS browser source to use.

How It Works#

1. A viewer sends a donation. (Star Balloons, Super Chat, etc.)

2. The donor enters a trigger word within the set time (default 13 seconds) after donating.

3. The donation amount is automatically added (or subtracted) to the cell with that trigger word.

4. The table updates in real-time in OBS.

Creative Spread Sheet Ideas#

• Voting/poll system: Column headers ‘Chicken vs Pizza vs Burger’, trigger words for each menu name - instant donation-powered live poll
• Bingo game: Fill a 5x5 table with missions and let viewers complete bingo squares via donations + trigger words
• Challenge progress bar: Show mission progress like ‘Sing a Song (0/50)’ in real-time
• Team battle: Split into two teams where donations add points to each team’s score - viewer engagement explodes!

When changes are not reflected in the URL#

Double-click the source with the URL in OBS, check the ‘Refresh browser when scene becomes active’ checkbox, and click the ‘Refresh cache of current page’ button.