본문으로 건너뛰기
cccskills
무료GitHub에 공개

raffle-winner-picker

Picks random winners from lists, spreadsheets, or Google Sheets for giveaways, raffles, and contests. Ensures fair, unbiased selection with transparency.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

연동 도구Google SheetsExcel
설치 방법 보기

포함된 파일(1)

  • SKILL.md3.7 KB

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

  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 (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

  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

리뷰

아직 리뷰가 없습니다. 사용해 본 소감을 남겨 주세요.

댓글

로그인 없이 쓸 수 있습니다. 사용 후기, 질문, 작동하지 않은 환경 등을 편하게 남겨 주세요.

아직 댓글이 없습니다. 첫 댓글을 남겨 보세요.

보내면 바로 공개됩니다. 이메일 주소나 전화번호 같은 개인 정보는 쓰지 마세요. URL은 2개까지입니다.

0 / 1,000자

이 양식은 reCAPTCHA로 보호되며 Google 개인정보처리방침 및 서비스 약관이 적용됩니다.

같은 저장소의 스킬

Create forensically sound bit-for-bit disk images using dd and dcfldd while preserving evidence integrity through hash verification.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

micsapp/micstec-skills42026년 3월 20일 업데이트

Creating algorithmic art using p5.js with seeded randomness and interactive parameter exploration. Use this when users request creating art using code, generative art, algorithmic art, flow fields, or particle systems. Create original algorithmic art rather than copying existing artists' work to avoid copyright violations.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

micsapp/micstec-skills42026년 3월 20일 업데이트

Detect dangerous ACL misconfigurations in Active Directory using ldap3 to identify GenericAll, WriteDACL, and WriteOwner abuse paths

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

micsapp/micstec-skills42026년 3월 20일 업데이트

Perform static analysis of Android APK malware samples using apktool for decompilation, jadx for Java source recovery, and androguard for permission analysis, manifest inspection, and suspicious API call detection.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

micsapp/micstec-skills42026년 3월 20일 업데이트

Parses API Gateway access logs (AWS API Gateway, Kong, Nginx) to detect BOLA/IDOR attacks, rate limit bypass, credential scanning, and injection attempts. Uses pandas for statistical analysis of request patterns and anomaly detection. Use when investigating API abuse or building API-specific threat detection rules.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

micsapp/micstec-skills42026년 3월 20일 업데이트

Analyze advanced persistent threat (APT) group techniques using MITRE ATT&CK Navigator to create layered heatmaps of adversary TTPs for detection gap analysis and threat-informed defense.

한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.

micsapp/micstec-skills42026년 3월 20일 업데이트

micsapp의 스킬 모두 보기

이 스킬의 문제 신고