1---2name: event-status-update-ptsf3description: 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.4---5
6# Event Status Update Workflow
7
8## Data Sources
9
10| Source | What to Find | How to Access |
11|--------|--------------|---------------|
12| **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>` |
13| **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]"` |
14| **Speaker Form Results** | Speaker submissions, talk titles, bios, availability | [Speaker Form](https://docs.google.com/spreadsheets/d/1GN2mAqlv_QRdCD4cuIplw_8IbwfjwpdlHTe7CSlcagY/edit?gid=206355470#gid=206355470) — `gdrive:gsheets_read` spreadsheetId: `1GN2mAqlv_QRdCD4cuIplw_8IbwfjwpdlHTe7CSlcagY` |
15| **Master Event Spreadsheet** | Event calendar, venue info, budget, sponsor tracking | [Master Events](https://docs.google.com/spreadsheets/d/1RnNx_kF0YsaiG2VlcgMO1oVs56rjKBIxtQKjVsvwq2o/edit?gid=2#gid=2) — `gdrive:gsheets_read` spreadsheetId: `1RnNx_kF0YsaiG2VlcgMO1oVs56rjKBIxtQKjVsvwq2o` |
16| **Past Conversations** | Prior context, issue IDs, decisions made | `conversation_search` |
17
18## Process
19
20### 1. Gather Context
21- `conversation_search` for event/speaker name to find issue IDs and recent activity
22- Note the main coordination issue (e.g., PRO-42)
23
24### 2. Get Linear Details
25- `linear-cli p get <PROJECT_ID> --output json` for project description, event date, venue, speaker details
26- `linear-cli i get <ISSUE_ID> --output json` for main issue status, timeline, blockers, due dates
27- Extract progress from "Event Definition of Done Checklist"
28
29### 3. Check Google Sheets
30- **Speaker Form Results** — speaker submissions, proposed talk titles, contact info
31- **Master Event Spreadsheet** — event dates, venue details, budget status, sponsor commitments
32
33### 4. Check Recent Communications
34- `search_gmail_messages` with `q: "from:wmfrederick+producttanksf@gmail.com OR to:wmfrederick+producttanksf@gmail.com [speaker/event] after:[7-10 days ago]"`
35- Note last contact date, what's confirmed vs pending
36
37### 5. Synthesize Using Template Below
38
39## Output Template
40
41```markdown
42## Event Status: **[Status]** ([Brief Context])
43
44**Event Date:** [Date, Time]
45**Speaker:** [Name] - "[Talk Title]"
46**Expected Attendance:** [Number]
47
48### ✅ What's Confirmed:
49- [Speaker details, budget, sponsors, locked-in logistics]
50
51### 🔴 What's Blocked:
52[Timeline context first (e.g., "30 days behind schedule"), then numbered blockers with issue IDs]
53
54### 📅 Last Communication:
55**[Date]**: [Summary]
56
57**Next action needed:** [Specific action with name and deliverable]
58```
59
60## Status Labels
61- **Confirmed** - All major pieces locked in
62- **On Track** - Minor details pending, on schedule
63- **At Risk** - Behind schedule but recoverable
64- **Blocked** - Cannot proceed without external action
65- **On Hold** - Paused pending decision
66
67## Key Principles
68- Lead with status assessment, not details
69- Include specific dates, names, dollar amounts
70- State timeline gaps explicitly (e.g., "30 days behind")
71- End with concrete next step (who does what)
72- Focus on recent 7-10 days of activity
majiayu000