ReddRadar
Agent skill
event-status-update-ptsf
Generate ProductTank SF event status reports by synthesizing Linear issues, Gmail threads, and past conversations. Use when asked about event status, speaker coordination status, what's happening with an upcoming event, event readiness, or any "what's the status of [event/speaker]" query for ProductTank SF.
Stars
163
Forks
31
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/data/ptsf-event-status-update
SKILL.md
Event Status Update Workflow
Data Sources
| Source | What to Find | How to Access |
|---|---|---|
| Linear | Issue status, blockers, timelines, checklist progress | linear-cli i list -t "Product Tank SF", linear-cli i get <ID>, linear-cli p get <ID> |
| Gmail | Speaker communications, confirmations, pending replies | search_gmail_messages with q: "from:wmfrederick+producttanksf@gmail.com OR to:wmfrederick+producttanksf@gmail.com [speaker/event name]" |
| Speaker Form Results | Speaker submissions, talk titles, bios, availability | Speaker Form — gdrive:gsheets_read spreadsheetId: 1GN2mAqlv_QRdCD4cuIplw_8IbwfjwpdlHTe7CSlcagY |
| Master Event Spreadsheet | Event calendar, venue info, budget, sponsor tracking | Master Events — gdrive:gsheets_read spreadsheetId: 1RnNx_kF0YsaiG2VlcgMO1oVs56rjKBIxtQKjVsvwq2o |
| Past Conversations | Prior context, issue IDs, decisions made | conversation_search |
Process
1. Gather Context
conversation_searchfor event/speaker name to find issue IDs and recent activity- Note the main coordination issue (e.g., PRO-42)
2. Get Linear Details
linear-cli p get <PROJECT_ID> --output jsonfor project description, event date, venue, speaker detailslinear-cli i get <ISSUE_ID> --output jsonfor main issue status, timeline, blockers, due dates- Extract progress from "Event Definition of Done Checklist"
3. Check Google Sheets
- Speaker Form Results — speaker submissions, proposed talk titles, contact info
- Master Event Spreadsheet — event dates, venue details, budget status, sponsor commitments
4. Check Recent Communications
search_gmail_messageswithq: "from:wmfrederick+producttanksf@gmail.com OR to:wmfrederick+producttanksf@gmail.com [speaker/event] after:[7-10 days ago]"- Note last contact date, what's confirmed vs pending
5. Synthesize Using Template Below
Output Template
markdown
## Event Status: **[Status]** ([Brief Context])
**Event Date:** [Date, Time]
**Speaker:** [Name] - "[Talk Title]"
**Expected Attendance:** [Number]
### ✅ What's Confirmed:
- [Speaker details, budget, sponsors, locked-in logistics]
### 🔴 What's Blocked:
[Timeline context first (e.g., "30 days behind schedule"), then numbered blockers with issue IDs]
### 📅 Last Communication:
**[Date]**: [Summary]
**Next action needed:** [Specific action with name and deliverable]
Status Labels
- Confirmed - All major pieces locked in
- On Track - Minor details pending, on schedule
- At Risk - Behind schedule but recoverable
- Blocked - Cannot proceed without external action
- On Hold - Paused pending decision
Key Principles
- Lead with status assessment, not details
- Include specific dates, names, dollar amounts
- State timeline gaps explicitly (e.g., "30 days behind")
- End with concrete next step (who does what)
- Focus on recent 7-10 days of activity
Didn't find tool you were looking for?