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

技能功能

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

随机选取：使用加密安全的随机算法进行选取
多数据源支持：兼容CSV、Excel、Google Sheets或纯文本列表
多获奖者选取：可抽取1名或多名获奖者
防重复机制：确保同一人不会重复获奖
结果透明：清晰展示选取过程
获奖者详情：显示获奖者的所有相关信息

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

社交媒体赠品活动

Export entries from Google Form to Sheets
"Pick a random winner from [Sheet URL]"
Verify winner details
Announce publicly with timestamp

将Google表单的投稿导出到Sheets
输入指令："Pick a random winner from [Sheet URL]"
验证获奖者详情
附上时间戳公开发布结果

Event Raffle

活动抽奖

Create CSV of attendee names and emails
"Pick 10 random winners from attendees.csv"
Export winner list
Email winners directly

创建包含参会者姓名和邮箱的CSV文件
输入指令："Pick 10 random winners from attendees.csv"
导出获奖者列表
直接邮件通知获奖者

Team Assignment

团队分配

Have list of participants
"Randomly split this list into 4 equal teams"
Review assignments
Share team rosters

准备参与者列表
输入指令："Randomly split this list into 4 equal teams"
查看分配结果
分享团队名单

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

订阅者赠品活动
产品发布抽奖
会议门票抽取
测试人员选拔
焦点小组参与者选取
活动现场随机奖品分发