Agent skill
raffle-winner-picker
Picks random winners from lists, spreadsheets, or Google Sheets for giveaways, raffles, and contests. Ensures fair, unbiased selection with transparency.
Install this agent skill to your Project
npx add-skill https://github.com/lifangda/claude-plugins/tree/main/cli-tool/skills-library/utility-automation/raffle-winner-picker
SKILL.md
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
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
metabolomics-workbench-database
Access NIH Metabolomics Workbench via REST API (4,200+ studies). Query metabolites, RefMet nomenclature, MS/NMR data, m/z searches, study metadata, for metabolomics and biomarker discovery.
zinc-database
Access ZINC (230M+ purchasable compounds). Search by ZINC ID/SMILES, similarity searches, 3D-ready structures for docking, analog discovery, for virtual screening and drug discovery.
drugbank-database
Access and analyze comprehensive drug information from the DrugBank database including drug properties, interactions, targets, pathways, chemical structures, and pharmacology data. This skill should be used when working with pharmaceutical data, drug discovery research, pharmacology studies, drug-drug interaction analysis, target identification, chemical similarity searches, ADMET predictions, or any task requiring detailed drug and drug target information from DrugBank.
pubmed-database
Direct REST API access to PubMed. Advanced Boolean/MeSH queries, E-utilities API, batch processing, citation management. For Python workflows, prefer biopython (Bio.Entrez). Use this for direct HTTP/REST work or custom API implementations.
reactome-database
Query Reactome REST API for pathway analysis, enrichment, gene-pathway mapping, disease pathways, molecular interactions, expression analysis, for systems biology studies.
alphafold-database
Access AlphaFold's 200M+ AI-predicted protein structures. Retrieve structures by UniProt ID, download PDB/mmCIF files, analyze confidence metrics (pLDDT, PAE), for drug discovery and structural biology.
Didn't find tool you were looking for?