Back to Details

raffle-winner-picker

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Raffle Winner Picker

Raffle Winner Picker

This skill randomly selects winners from lists, spreadsheets, or Google Sheets for giveaways and contests.
本Skill可从列表、电子表格或Google Sheets中随机抽取赠品活动和竞赛的获奖者。

When to Use This Skill

何时使用本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

本Skill的功能

  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
  1. 随机选择：使用加密安全的随机选择算法
  2. 多数据源支持：兼容CSV、Excel、Google Sheets或纯文本列表
  3. 多获奖者抽取：可抽取1名或多名获奖者
  4. 防重复机制：确保同一人不会重复中奖
  5. 结果透明：清晰展示选择过程
  6. 获奖者详情展示：显示获奖者的所有相关信息

How to Use

使用方法

From Google Sheets

从Google Sheets抽取

Pick a random row from this Google Sheet to select a winner 
for a giveaway: [Sheet URL]
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
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)
...
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
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
用户："从这个Google Sheet中随机抽取一行，选出赠品活动的获奖者。"
输出:
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?
灵感来源：Lenny的使用场景——从他的订阅者Slack社区中抽取Sora 2赠品活动的获奖者

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
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)
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
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
  1. 将Google Form中的参赛数据导出到Sheets
  2. 输入指令："从[表格链接]中随机抽取一名获奖者"
  3. 验证获奖者信息
  4. 附带时间戳公开发布结果

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
  1. 创建包含参会者姓名和邮箱的CSV文件
  2. 输入指令："从attendees.csv中随机抽取10名获奖者"
  3. 导出获奖者名单
  4. 直接向获奖者发送邮件

Team Assignment

团队分配

  1. Have list of participants
  2. "Randomly split this list into 4 equal teams"
  3. Review assignments
  4. Share team rosters
  1. 准备参与者列表
  2. 输入指令："将此列表随机分成4个均等的团队"
  3. 查看分配结果
  4. 共享团队名单

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
  • 通讯订阅者赠品活动
  • 产品发布抽奖
  • 会议门票抽取
  • 测试人员选拔
  • 焦点小组参与者选拔
  • 活动现场随机奖品分发