Back to Details

raffle-winner-picker

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Raffle Winner Picker

抽奖获奖者抽取工具

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

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
  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
用户："Pick a random row from this Google Sheet to select a winner for a giveaway."
输出:
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表单的投稿导出到Sheets
  2. 输入指令："Pick a random winner from [Sheet URL]"
  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. 输入指令："Pick 10 random winners from attendees.csv"
  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. 输入指令："Randomly split this list into 4 equal teams"
  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
  • 订阅者赠品活动
  • 产品发布抽奖
  • 会议门票抽取
  • 测试人员选拔
  • 焦点小组参与者选取
  • 活动现场随机奖品分发