raffle-winner-picker

Picks random winners from lists, spreadsheets, or Google Sheets for giveaways, raffles, and contests. Ensures fair, unbiased selection with transparency.

javotillo@javotillo

Install

openclaw skills install @javotillo/raffle-winner-picker

Raffle Winner Picker

This skill randomly selects winners from lists, spreadsheets, or Google Sheets for giveaways and contests.

When to Use This Skill

Running social media giveaways
Picking raffle winners at events
Randomly selecting participants for surveys or tests
Choosing winners from contest submissions
Fair distribution of limited spots or resources
Random team assignments

What This Skill Does

Random Selection: Uses cryptographically random selection
Multiple Sources: Works with CSV, Excel, Google Sheets, or plain lists
Multiple Winners: Can pick one or multiple winners
Duplicate Prevention: Ensures the same person can't win twice
Transparent Results: Shows the selection process clearly
Winner Details: Displays all relevant information about winners

How to Use

From Google Sheets

text

Pick a random row from this Google Sheet to select a winner 
for a giveaway: [Sheet URL]

From Local File

text

Pick 3 random winners from entries.csv

From List

text

Pick a random winner from this list:
- Alice (alice@email.com)
- Bob (bob@email.com)
- Carol (carol@email.com)
...

Multiple Winners

text

Pick 5 random winners from contest-entries.xlsx, 
make sure no duplicates

Example

User: "Pick a random row from this Google Sheet to select a winner for a giveaway."

Output:

text

Accessing Google Sheet...
Total entries found: 247

Randomly selecting winner...

🎉 WINNER SELECTED! 🎉

Row #142
Name: Sarah Johnson
Email: sarah.j@email.com
Entry Date: March 10, 2024
Comment: "Love your newsletter!"

Selection method: Cryptographically random
Timestamp: 2024-03-15 14:32:18 UTC

Would you like to:
- Pick another winner (excluding Sarah)?
- Export winner details?
- Pick runner-ups?

Inspired by: Lenny's use case - picking a Sora 2 giveaway winner from his subscriber Slack community

Features

Fair Selection

Uses secure random number generation
No bias or patterns
Transparent process
Repeatable with seed (for verification)

Exclusions

text

Pick a random winner excluding previous winners: 
Alice, Bob, Carol

Weighted Selection

text

Pick a winner with weighted probability based on 
the "entries" column (1 entry = 1 ticket)

Runner-ups

text

Pick 1 winner and 3 runner-ups from the list

Example Workflows

Social Media Giveaway

Export entries from Google Form to Sheets
"Pick a random winner from [Sheet URL]"
Verify winner details
Announce publicly with timestamp

Event Raffle

Create CSV of attendee names and emails
"Pick 10 random winners from attendees.csv"
Export winner list
Email winners directly

Team Assignment

Have list of participants
"Randomly split this list into 4 equal teams"
Review assignments
Share team rosters

Tips

Document the process: Save the timestamp and method
Public announcement: Share selection details for transparency
Check eligibility: Verify winner meets contest rules
Have backups: Pick runner-ups in case winner is ineligible
Export results: Save winner list for records

Privacy & Fairness

✓ Uses cryptographically secure randomness ✓ No manipulation possible ✓ Timestamp recorded for verification ✓ Can provide seed for third-party verification ✓ Respects data privacy

Common Use Cases

Newsletter subscriber giveaways
Product launch raffles
Conference ticket drawings
Beta tester selection
Focus group participant selection
Random prize distribution at events