home / skills / composiohq / awesome-claude-skills / raffle-winner-picker

raffle-winner-picker skill

/raffle-winner-picker

This skill selects random winners from lists, spreadsheets, or Google Sheets using cryptographic randomness to ensure fair, transparent raffles and giveaways.

This is most likely a fork of the raffle-winner-picker skill from composiohq
npx playbooks add skill composiohq/awesome-claude-skills --skill raffle-winner-picker

Review the files below or copy the command above to add this skill to your agents.

Files (1)
SKILL.md
3.7 KB
---
name: raffle-winner-picker
description: Picks random winners from lists, spreadsheets, or Google Sheets for giveaways, raffles, and contests. Ensures fair, unbiased selection with transparency.
---

# 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

1. **Random Selection**: Uses cryptographically random selection
2. **Multiple Sources**: Works with CSV, Excel, Google Sheets, or plain lists
3. **Multiple Winners**: Can pick one or multiple winners
4. **Duplicate Prevention**: Ensures the same person can't win twice
5. **Transparent Results**: Shows the selection process clearly
6. **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 ([email protected])
- Bob ([email protected])
- Carol ([email protected])
...
```

### 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: [email protected]
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
1. Export entries from Google Form to Sheets
2. "Pick a random winner from [Sheet URL]"
3. Verify winner details
4. Announce publicly with timestamp

### Event Raffle
1. Create CSV of attendee names and emails
2. "Pick 10 random winners from attendees.csv"
3. Export winner list
4. Email winners directly

### Team Assignment
1. Have list of participants
2. "Randomly split this list into 4 equal teams"
3. Review assignments
4. 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

Overview

This skill picks random winners from lists, spreadsheets, or Google Sheets for giveaways, raffles, and contests. It enforces fair, unbiased selection using cryptographically secure randomness and records timestamps and selection details for transparency. The tool supports single or multiple winners, exclusions, weighting, and exportable results for auditability.

How this skill works

The skill reads entries from CSV, Excel, Google Sheets, or plain text lists and converts them into a standardized entry set. It performs cryptographically secure random draws, prevents duplicate winners, and can apply exclusions or weightings based on a ticket count column. Results include winner details, selection method, timestamp, and optional seed for reproducibility or third-party verification.

When to use it

  • Running social media or newsletter giveaways
  • Picking raffle winners at live events
  • Selecting participants for surveys, tests, or beta programs
  • Allocating limited spots or random team assignments
  • Choosing runner-ups or backups in case of ineligible winners

Best practices

  • Document and save the selection timestamp, method, and seed for transparency
  • Verify eligibility rules before announcing winners and keep a backup list of runner-ups
  • Export and archive winner details (CSV or spreadsheet) for records and audits
  • Use exclusions to remove previous winners or ineligible entries before drawing
  • When using weighted entries, confirm the 'entries' column values are integers and validated

Example use cases

  • Pick 1 winner from a Google Sheet of 2,000 newsletter subscribers and export the winner row with timestamp
  • Draw 10 winners from attendees.csv for a conference raffle and generate a downloadable winners list
  • Select 3 runner-ups alongside a primary winner, ensuring no duplicates
  • Randomly split a list of participants into 4 balanced teams for an event or workshop
  • Run a weighted draw where the 'entries' column grants multiple tickets per participant

FAQ

Can I exclude past winners or specific emails?

Yes. Provide a list of exclusions or mark entries in the sheet; the skill will remove them before drawing.

Is the selection verifiable after the draw?

Yes. The skill records a timestamp and can output the cryptographic seed and method used so results can be independently verified.

Can I pick multiple winners without duplicates?

Absolutely. The skill ensures no duplicate winners and supports drawing multiple winners and runner-ups in one run.