Stats
Actions
Tags
From geoffrey
Generate daily CFO briefing for Ashley Murphy covering absence stats, department tickets, legislative fiscal updates, and K-12 finance news. Delivered via HTML email with absence infographic and podcast attachment.
How this skill is triggered — by the user, by Claude, or both
Slash command
/geoffrey:cfo-briefingThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
Generates a daily briefing for CFO Ashley Murphy and delivers it via:
Generates a daily briefing for CFO Ashley Murphy and delivers it via:
No Obsidian vault writing. This skill produces email-only output.
Execute these data gathering steps:
bun /Users/hagelk/non-ic-code/geoffrey/skills/redrover-manager/scripts/get_daily_summary.js today
Returns: total_absences, filled, unfilled, fill_rate, by_school, by_reason, by_position_type, unfilled_positions[]
bun /Users/hagelk/non-ic-code/geoffrey/skills/redrover-manager/scripts/get_certificated_summary.js today
Returns: same shape as 1.1 but filtered to Teacher, ESA - Certificated, CTE - Teacher position types.
Do not run a script. Subtract certificated values from all-staff values in the orchestration layer:
classified_absences = all_absences - cert_absencesclassified_filled = all_filled - cert_filledclassified_unfilled = all_unfilled - cert_unfilledclassified_fill_rate = classified_filled / classified_absences * 100 (handle divide-by-zero)bun /Users/hagelk/non-ic-code/geoffrey/skills/redrover-manager/scripts/get_weekly_summary.js 0
Provides 5-day trend context: daily averages, peak/slow days, fill rate trends. Used for "compared to this week's average" framing in the briefing.
bun /Users/hagelk/non-ic-code/geoffrey/skills/freshservice-manager/scripts/search_tickets.js "status:2 OR status:3" 9
Workspace ID: 9 (Transportation)
Returns: count, tickets[] (id, subject, status, priority, created_at, due_by)
bun /Users/hagelk/non-ic-code/geoffrey/skills/freshservice-manager/scripts/search_tickets.js "status:2 OR status:3" 6
Workspace ID: 6 (Maintenance) Returns: same shape as 1.4
bun /Users/hagelk/non-ic-code/geoffrey/skills/freshservice-manager/scripts/search_tickets.js "status:2 OR status:3" 3
Workspace ID: 3 (Employee Support Services) Returns: same shape as 1.4
bun /Users/hagelk/non-ic-code/geoffrey/skills/legislative-tracker/scripts/get_recent_bill_activity.js --last-business-day
Workflow:
get_recent_bill_activity.jsAlso pull Tier 2 finance committee bills:
bun /Users/hagelk/non-ic-code/geoffrey/skills/legislative-tracker/scripts/get_bills.js --tier 2 --format briefing
On Monday: Lookback starts on Friday (or earlier if Friday was a holiday), so includes all weekend activity.
Use WebSearch with these queries (replace [MONTH YEAR] with current month/year):
K-12 school district finance budget funding news past 24 hours [MONTH YEAR]Washington state education funding levy bond news [MONTH YEAR]WASBO Washington school business officials news [MONTH YEAR]OSPI fiscal budget allocation Washington state [MONTH YEAR]WebFetch top 3-4 articles. Extract 2-3 sentence synopses for each:
Freshness check: Verify article dates. Only include articles published within the last 48 hours. Skip older articles even if they appear in results.
Use WebSearch:
Gig Harbor WA weather today forecast
Extract:
No API calls. This is a placeholder for future integration.
Display in the briefing:
Calendar and email integration pending. Check Outlook/Google Calendar directly.
Build the briefing with these sections in order:
# CFO Daily Briefing - [DATE]
## Weather
[Current conditions, high/low, precipitation]
## CFO Calendar
*Calendar integration pending. Check Outlook/Google Calendar directly.*
## Staff Absences Dashboard
| Metric | All Staff | Certificated | Classified |
|--------|-----------|--------------|------------|
| Total Absences | X | Y | Z |
| Filled | X | Y | Z |
| Unfilled | X | Y | Z |
| Fill Rate | X% | Y% | Z% |
## Weekly Absence Trends
- This week's daily average: X absences
- Today vs average: [above/below/at average]
- Peak day this week: [day] with X absences
- Fill rate trend: [improving/declining/stable] (X% avg this week)
## Unfilled Positions
[If unfilled > 5, display attention alert]
[List unfilled positions with school, position type, and reason]
## Absences by School
| School | Total | Filled | Unfilled |
|--------|-------|--------|----------|
| ... | ... | ... | ... |
## Absences by Reason
| Reason | Count |
|--------|-------|
| ... | ... |
## Absences by Position Type
| Position Type | Count |
|---------------|-------|
| ... | ... |
## Department Tickets
### Transportation (Workspace 9) - [count] open
[List top tickets by priority with subject, status, created date]
### Maintenance (Workspace 6) - [count] open
[List top tickets by priority]
### Employee Support Services (Workspace 3) - [count] open
[List top tickets by priority]
## Legislative Fiscal Update
### FISCAL Impact Bills (Detailed)
[For each FISCAL bill with recent activity:]
**[Bill ID] - [Short Title]**
Action: [What happened]
Fiscal Impact: [Budget/funding implications]
Summary: [1-2 sentences]
### Other Education Bills (Brief)
- [Bill ID]: [Action] - [One line]
### Finance Committee Bills (Tier 2)
[Tier 2 bills from finance committees]
## K-12 Finance & WASBO/OSPI News
### [Article Title] - [Source]
[2-3 sentence synopsis with financial framing]
## Quick Stats
- Total absences: X (Cert: Y, Classified: Z)
- Fill rate: X% (Cert: Y%, Classified: Z%)
- Unfilled positions: X
- Department tickets: Transportation (X), Maintenance (Y), ESS (Z)
- Legislative bills with activity: X (Y fiscal impact)
- Finance articles: X
Transform the briefing into a conversational audio script. Address Ashley directly.
Required Sections (in order):
Opening (~80 words)
Absences Dashboard (~350 words)
Department Tickets (~200 words)
Legislative Fiscal Update (~300 words)
Finance/WASBO/OSPI News (~200 words)
Closing (~100 words)
Tone Guidelines:
CRITICAL - NO HALLUCINATION:
Save to /tmp/cfo_briefing_podcast.txt
bun /Users/hagelk/non-ic-code/geoffrey/skills/morning-briefing/scripts/apply_pronunciations.js \
--file /tmp/cfo_briefing_podcast.txt \
--guide /Users/hagelk/non-ic-code/geoffrey/skills/cfo-briefing/pronunciation_guide.json
uv run --with mlx-audio --with pydub /Users/hagelk/non-ic-code/geoffrey/skills/local-tts/scripts/generate_audio.py \
--file /tmp/cfo_briefing_podcast.txt \
--voice af_heart \
--output ~/Desktop/cfo_briefing_[DATE].mp3
Voice: af_heart (warm, professional)
Note: Replace [DATE] with YYYY-MM-DD format (e.g., cfo_briefing_2026-02-03.mp3)
Build a dynamic prompt from Red Rover data and generate an infographic.
Using the data gathered in Phase 1, construct a prompt:
Create a data dashboard infographic titled "PSD Staff Absences - [DATE]".
Main section - three large gauge/donut charts:
1. Total Absences: [X] (large number, navy background)
2. Fill Rate: [Y]% (color-coded: green if >=80%, gold if 70-79%, red if <70%)
3. Unfilled: [Z] (red accent if >5, gold if 3-5, green if <3)
Two-column comparison below the gauges:
Left column - "Certificated":
- Absences: [X]
- Filled: [Y]
- Unfilled: [Z]
- Fill Rate: [X]%
Right column - "Classified":
- Absences: [X]
- Filled: [Y]
- Unfilled: [Z]
- Fill Rate: [X]%
Bottom section - horizontal bar chart "Top 5 Schools by Absence Count":
[School 1]: [X] absences (filled portion in green, unfilled in red)
[School 2]: [X] absences
[School 3]: [X] absences
[School 4]: [X] absences
[School 5]: [X] absences
Style: Professional dashboard with PSD brand colors - navy (#003366) primary,
gold (#FFD700) accent, green (#28a745) for filled/positive, red (#dc3545) for
unfilled/negative. White background. Clean sans-serif typography. 16:9 aspect ratio.
Subtitle: "Prepared for Ashley Murphy, CFO"
uv run /Users/hagelk/non-ic-code/geoffrey/skills/image-gen/scripts/generate.py \
"[infographic prompt]" \
~/Desktop/cfo_briefing_[DATE].png \
16:9 \
2K
Settings:
~/Desktop/cfo_briefing_[DATE].pngUsing the template at skills/cfo-briefing/templates/email.html, generate the HTML email body by replacing all {{PLACEHOLDER}} values with actual data.
Template placeholders:
{{DATE}} - YYYY-MM-DD{{DAY_OF_WEEK}} - Monday, Tuesday, etc.{{DATE_FORMATTED}} - February 3, 2026{{WEATHER_TEMP}} - e.g., 45°F{{WEATHER_CONDITIONS}} - e.g., Partly Cloudy, High 48°F / Low 38°F{{TOTAL_ABSENCES}} - total all-staff absences{{FILL_RATE}} - all-staff fill rate percentage{{FILL_RATE_CLASS}} - "green" if >=80%, "gold" if 70-79%, "red" if <70%{{UNFILLED_COUNT}} - total unfilled{{DEPT_TICKETS}} - combined ticket count across all 3 departments{{ALL_ABSENCES}}, {{CERT_ABSENCES}}, {{CLASS_ABSENCES}} - breakdown totals{{ALL_FILLED}}, {{CERT_FILLED}}, {{CLASS_FILLED}} - filled counts{{ALL_UNFILLED}}, {{CERT_UNFILLED}}, {{CLASS_UNFILLED}} - unfilled counts{{ALL_FILL_RATE}}, {{CERT_FILL_RATE}}, {{CLASS_FILL_RATE}} - fill rate %{{TRANSPORT_COUNT}}, {{MAINT_COUNT}}, {{ESS_COUNT}} - per-department ticket counts{{TRANSPORT_TICKETS}}, {{MAINT_TICKETS}}, {{ESS_TICKETS}} - ticket HTML lists{{LEGISLATIVE_ITEMS}} - legislative section HTML{{FINANCE_NEWS_ITEMS}} - news section HTML{{WEEKLY_TRENDS_CONTENT}} - weekly trend summary HTML{{UNFILLED_POSITIONS_LIST}} - list of unfilled positions HTML{{CALENDAR_ITEMS}} - calendar items HTML (placeholder text for now)Conditional sections (remove block including wrapper if condition not met):
{{#IF_ABSENCE_WARNING}}...{{/IF_ABSENCE_WARNING}} - show if fill rate <70% OR unfilled >5{{ABSENCE_WARNING_TEXT}} - e.g., "Fill rate is 65% with 8 unfilled positions"{{#IF_CALENDAR}}...{{/IF_CALENDAR}} - show if calendar data available{{#IF_WEEKLY_TRENDS}}...{{/IF_WEEKLY_TRENDS}} - show if weekly data available{{#IF_UNFILLED_ALERT}}...{{/IF_UNFILLED_ALERT}} - show if unfilled >5{{#IF_LEGISLATIVE}}...{{/IF_LEGISLATIVE}} - show if legislative activity found{{#IF_FINANCE_NEWS}}...{{/IF_FINANCE_NEWS}} - show if finance news foundSave generated HTML to /tmp/cfo_briefing_email.html
cd /Users/hagelk/non-ic-code/geoffrey/skills/google-workspace && bun gmail/send_with_attachments.js psd \
--to "[email protected]" \
--subject "CFO Daily Briefing - [DATE]" \
--body-file /tmp/cfo_briefing_email.html \
--html \
--inline-image "~/Desktop/cfo_briefing_[DATE].png" \
--attachments "~/Desktop/cfo_briefing_[DATE].mp3"
Options:
--html - Treat body as HTML--inline-image - Embeds infographic at top of email (referenced as cid:briefing_image)--attachments - Podcast MP3 attached for downloadProduction recipient: [email protected] (change --to when ready for production)
Testing recipient: [email protected]
Return standardized summary:
## Summary
Generated CFO daily briefing for [DATE]
## Actions
- Red Rover all-staff absences: X total, Y filled, Z unfilled (W% fill rate)
- Red Rover certificated: X total, Y filled, Z unfilled (W% fill rate)
- Derived classified: X total, Y filled, Z unfilled (W% fill rate)
- Weekly trends: X daily avg, peak [day] with Y absences
- Transportation tickets: X open
- Maintenance tickets: X open
- Employee Support tickets: X open
- Legislative bills with activity: X (Y with fiscal impact)
- Finance news articles: X
- Generated podcast: ~/Desktop/cfo_briefing_[DATE].mp3
- Generated infographic: ~/Desktop/cfo_briefing_[DATE].png
- Email sent to: [email protected]
## Status
[Status emoji] [Complete/Partial]
## CFO Attention Items
1. [Most important item]
2. [Second most important]
3. [Third most important]
Status: Partial
Note: Red Rover data unavailable - absence section skipped
Status: Partial
Note: FreshService workspace [ID] error - [department] tickets unavailable
Status: Partial
Note: Legislative data unavailable - section skipped
Status: Partial
Note: Audio generation failed - check mlx-audio setup
Briefing sent without podcast attachment
Status: Partial
Note: Infographic generation failed - email sent without inline image
| Skill/Tool | Required For | Fallback |
|---|---|---|
| redrover-manager | Absence data | Skip absence sections |
| freshservice-manager | Department tickets | Skip ticket sections |
| legislative-tracker | Fiscal legislation | Skip legislative section |
| local-tts | Audio podcast | Email without attachment |
| image-gen | Absence infographic | Email without inline image |
| google-workspace | Email delivery | Display summary in terminal only |
| WebSearch | Weather, finance news | Skip sections |
[email protected][email protected]get_daily_summary.js todayget_certificated_summary.js todayget_weekly_summary.js 0Users can request:
npx claudepluginhub krishagel/geoffrey --plugin geoffreyProduces portfolio-level morning briefings for legal portfolio managers handling multiple matters, triaging emails, call notes, calendars into meetings, deliverables, issues, and risks as a .docx file. For multi-matter daily sweeps.
Writes internal communications including status reports, leadership updates, newsletters, FAQs, incident reports, and project updates using repeatable templates.
Generates legal briefings from email, calendar, contracts, chat, and CRM sources for daily summaries, topic research, or incident response.