raffle-winner-picker
npx machina-cli add skill davepoon/buildwithclaude/raffle-winner-picker --openclawRaffle 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
Source
git clone https://github.com/davepoon/buildwithclaude/blob/main/plugins/all-skills/skills/raffle-winner-picker/SKILL.mdView on GitHub Overview
Raffle Winner Picker selects winners from lists, CSV/Excel, or Google Sheets for giveaways and contests. It guarantees fair, unbiased results with a transparent process and supports single or multiple winners while preventing duplicates.
How This Skill Works
The skill uses cryptographically secure randomness to pick one or more winners from supported sources (CSV, Excel, Google Sheets, or in-memory lists). It ensures no duplicate winners, displays winner details, and provides a verifiable selection trail for transparency.
When to Use It
- 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
Quick Start
- Step 1: Choose a source (Google Sheet URL, entries.csv, or a plain list)
- Step 2: Run the command, e.g., 'Pick N random winners from [source] (no duplicates)'
- Step 3: Review winner details and export or announce with a timestamp
Best Practices
- Document the process with a timestamp and selection method
- Publicly announce results to ensure transparency
- Check eligibility against contest rules before finalizing winners
- Have backups or runner-ups in case of ineligible winners
- Export and save winner lists for records and audits
Example Use Cases
- Newsletter subscriber giveaways
- Product launch raffles
- Conference ticket drawings
- Beta tester selection
- Random prize distribution at events
Frequently Asked Questions
Related Skills
internal-comms
davepoon/buildwithclaude
A set of resources to help me write all kinds of internal communications, using the formats that my company likes to use. Claude should use this skill whenever asked to write some sort of internal communications (status reports, leadership updates, 3P updates, company newsletters, FAQs, incident reports, project updates, etc.).
bamboohr-automation
davepoon/buildwithclaude
Automate BambooHR tasks via Rube MCP (Composio): employees, time-off, benefits, dependents, employee updates. Always search tools first for current schemas.
competitive-ads-extractor
davepoon/buildwithclaude
Extracts and analyzes competitors' ads from ad libraries (Facebook, LinkedIn, etc.) to understand what messaging, problems, and creative approaches are working. Helps inspire and improve your own ad campaigns.
content-research-writer
davepoon/buildwithclaude
Assists in writing high-quality content by conducting research, adding citations, improving hooks, iterating on outlines, and providing real-time feedback on each section. Transforms your writing process from solo effort to collaborative partnership.
developer-growth-analysis
davepoon/buildwithclaude
Analyzes your recent Claude Code chat history to identify coding patterns, development gaps, and areas for improvement, curates relevant learning resources from HackerNews, and automatically sends a personalized growth report to your Slack DMs.
docusign-automation
davepoon/buildwithclaude
Automate DocuSign tasks via Rube MCP (Composio): templates, envelopes, signatures, document management. Always search tools first for current schemas.