微信扫一扫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
## 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