Raffle Winner Picker

What Is Raffle Winner Picker?

Raffle Winner Picker is a Claude Code skill designed to automate and ensure fairness in selecting winners for giveaways, raffles, contests, and similar activities. By integrating with lists, spreadsheets (CSV or Excel), or Google Sheets, this skill leverages cryptographically secure randomization techniques to pick winners transparently and without bias. Whether you are conducting a social media giveaway, distributing limited resources, or assigning teams, Raffle Winner Picker provides a reliable and repeatable process for unbiased winner selection.

Why Use Raffle Winner Picker?

Manual winner selection processes are prone to human error, bias, and lack of transparency. For organizations and developers running contests or distributing rewards, ensuring the integrity of the selection process is critical to maintaining trust with participants. Raffle Winner Picker addresses these concerns by offering:

• Fairness: Uses cryptographically random algorithms for unbiased selection.
• Transparency: Clearly documents the process and the criteria used for winner selection.
• Efficiency: Automates the process, saving time and reducing administrative overhead.
• Flexibility: Works across different data sources, including local files, plain lists, and cloud-based spreadsheets.
• Scalability: Handles large datasets and multiple simultaneous winners without issue.

How to Get Started

Raffle Winner Picker is available as a Claude Code skill and can be integrated into your workflow with minimal setup. The source code and detailed documentation are available on GitHub.

Example 1:

Picking from a Google Sheet

To select a random winner from a Google Sheet, simply provide the sheet's URL:

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

Example 2:

Picking from a Local File

To pick multiple winners from a local CSV file, use:

Pick 3 random winners from entries.csv

Example 3:

Picking from a Plain List

For direct list-based selection, format your request like this:

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

Example 4:

Multiple Winners with Duplicate Prevention

To pick several winners and ensure no duplicates, specify your requirements:

Pick 5 random winners from contest-entries.xlsx, making sure no one wins twice.

Key Features

• Cryptographically Secure Random Selection: Utilizes secure random algorithms to ensure unbiased results, resistant to prediction or manipulation.
• Multi-Source Compatibility: Accepts input from CSV, Excel, Google Sheets, and plain text lists, making it suitable for a range of use cases.
• Multiple Winner Support: Allows selection of one or more winners in a single operation, streamlining large contests.
• Duplicate Prevention: Ensures the same participant cannot be selected more than once per draw, maintaining fairness.
• Transparent Process: Clearly displays the selection process, including the input list and the randomly chosen winners, fostering trust among participants.
• Detailed Winner Information: Outputs relevant data (such as names and emails) for each winner, as available from the source.

import random
import pandas as pd

## Example:

Selecting 3 winners from a CSV
df = pd.read_csv('entries.csv')
winners = df.sample(n=3, random_state=random.SystemRandom().randint(0, 1_000_000))
print(winners)

Best Practices

• Clean Your Data: Ensure your input lists or spreadsheets are free from duplicates and contain all necessary information (e.g., names, contact details).
• Use Secure Data Sources: If importing from Google Sheets, ensure appropriate access permissions and avoid exposing sensitive data.
• Set Clear Rules: Define and communicate selection criteria (number of winners, eligibility, etc.) before running the raffle to avoid disputes.
• Document the Process: Keep records of input lists, selection commands, and results to support transparency and potential audits.
• Prevent Duplicate Wins: Always enable or check for duplicate prevention, especially for multi-winner draws.

Important Notes

• Privacy Considerations: Ensure compliance with data privacy laws (such as GDPR) when handling participant information.
• Randomness Assurance: The skill leverages cryptographically secure methods, but the quality of randomness is partially dependent on the integrity of the environment where the skill runs.
• Integration Limits: When working with large Google Sheets or files, be aware of API rate limits and file size constraints.
• Result Validation: Always validate the output, especially in high-stakes or regulated environments, to confirm that winners are eligible and that no errors occurred during data import or processing.
• Open Source Contribution: As an open-source tool, users are encouraged to contribute improvements or report issues via the project's GitHub repository.

By adopting Raffle Winner Picker, you can confidently manage raffles, contests, and giveaways with fairness, transparency, and efficiency.