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

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

From Local File

Pick 3 random winners from entries.csv

From List

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

Multiple Winners

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:

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

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

Weighted Selection

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

Runner-ups

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