跳到正文
cccskills
免费在 GitHub 公开

raffle-winner-picker

Draw one or more winners from plain lists, CSV, Excel, or Google Sheets. Avoid duplicate winners, exclude past winners, choose alternates, and show the selection method and timestamp for a clear record.

中文简介正在准备中。当前显示英语简介。

原文查看原文说明

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

集成工具Google SheetsExcel
查看安装方法

适用场景

  • Drawing winners for social media giveaways
  • Selecting prize winners from an event attendee list
  • Choosing participants for surveys or tests
  • Splitting participants into random teams

包含的文件(1)

  • SKILL.md3.7 KB

SKILL.md(原文)

安装前可以查看交给 AI 代理的指令内容。

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 / 1000 字

此表单受 reCAPTCHA 保护,适用 Google 的隐私权政策和服务条款。

同一仓库的技能

Handle ActiveCampaign contact and marketing tasks through Rube MCP, a connection for agent tools. Find or create contacts, manage tags and subscriptions, enroll contacts in existing automated workflows, and create follow-up tasks.

中文简介正在准备中。当前显示英语简介。

  • Finding or registering contacts
  • Adding or removing contact tags
  • Subscribing contacts to lists or unsubscribing them
davepoon/buildwithclaude36712026年10月20日 更新

Research competitors’ live Meta and Google ads to identify opening hooks, offers, calls to action, and landing pages. Receive a sourced creative brief and up to three test ideas adapted to your product.

中文简介正在准备中。当前显示英语简介。

  • Find angles for new ad copy
  • Plan creative tests using competitor ads
  • Choose a landing page message
davepoon/buildwithclaude36712026年10月20日 更新

Add website or app tracking, then use command-line tools to review traffic, signups, drop-off, and returning users across projects. Run A/B tests, which compare alternative headlines or buttons, and inspect results to guide changes.

中文简介正在准备中。当前显示英语简介。

  • Adding page-view and key-action tracking
  • Reviewing traffic and referral sources across projects
  • Finding where visitors drop out before signup or purchase
davepoon/buildwithclaude36712026年10月20日 更新

Establish rules for when an AI agent should recall past context and save lasting decisions, corrections, preferences, and failures. Works with Markdown files or memory services, preserving decision history and surfacing conflicting records.

中文简介正在准备中。当前显示英语简介。

  • Carry project conventions into the next session
  • Save user corrections and lasting preferences
  • Record failed approaches and their causes
davepoon/buildwithclaude36712026年10月20日 更新

Audit local AI coding-agent sessions with agenttrace to identify spending, token use, tool failures, and operational problems. Produce readable or structured reports and define pass-or-fail thresholds for automated continuous integration checks.

中文简介正在准备中。当前显示英语简介。

  • Investigating session costs and token waste
  • Finding repeated tool failures and retries
  • Exporting session reports as Markdown or JSON
davepoon/buildwithclaude36712026年10月20日 更新

Audit saved agent sessions for access to private files and evidence that secret values entered an agent's context. Get findings without displaying secrets, identify keys needing rotation, and inspect Claude Code or Codex sessions in a local report.

中文简介正在准备中。当前显示英语简介。

  • Check whether an agent accessed .env files
  • Identify keys that may need rotation
  • Audit private-file access by subagents
davepoon/buildwithclaude36712026年10月20日 更新

查看 davepoon 的全部技能

报告此技能的问题