Daily Review Skill

Generate comprehensive daily performance reviews with AI coaching insights.

Features

| Feature | Source | Status | |---------|--------|--------| | Emails sent | Gmail API | ✅ | | Slack messages | Slack API | ✅ | | X.com mentions | Bird CLI | ✅ | | Meetings attended | Fireflies (speaker verified) | ✅ | | Git commits | git log | ✅ | | Docs modified | Google Drive API | ✅ | | Screen Time | macOS knowledgeC.db | ✅ | | ActivityWatch | AW API | ✅ |

Usage

bash
# Run daily review for today
~/clawd/skills/daily-review/scripts/daily-review.sh

# Run for specific date
~/clawd/skills/daily-review/scripts/daily-review.sh 2026-01-15

Sample Output

🏆 Daily Performance Review - 2026-01-15
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📬 COMMUNICATION
  • Emails sent: 6
  • Slack messages: 203
  • X.com mentions: 5

📅 MEETINGS (Fireflies - speaker verified)
  • CEO Chat (70 min)
  • Meeting with Perfectos (27 min)
  • US Squad Standup (27 min)
  Total: 3 meetings (~2.0 hrs)

💻 OUTPUT
  • Git commits: 6
  • Docs modified: 20
  • Messages to Ada: 73

⏱️ FOCUS TIME
  Screen Time: 9.7 hrs
  • Atlas: 203min
  • Slack: 163min
  • Telegram: 45min
  
  ActivityWatch: 8.5 hrs
  • Telegram: 120min
  • Ghostty: 90min
  • Chrome: 45min

Requirements

APIs & Services

• Gmail: Google Workspace service account or gog OAuth
• Slack: Slack API token (user_token for search)
• Fireflies: API key for meeting transcripts
• Google Drive: Service account for docs tracking

Tools

• Bird CLI: For X.com/Twitter (requires auth_token + ct0 cookies)
• ActivityWatch: Local app tracking (http://localhost:5600)

macOS (for Screen Time)

• SSH access to Mac
• get_screentime.py script for knowledgeC.db queries

Installation

1. Copy skill to your clawd workspace:

bash
cp -r daily-review ~/clawd/skills/

1. Install dependencies:

bash
# Bird CLI (on Mac)
cd ~/Code && git clone https://github.com/steipete/bird.git
cd bird && npm install && npm run build:dist

# ActivityWatch
# Download from https://activitywatch.net/

1. Configure secrets:

bash
# Bird (X.com)
cat > ~/clawd/secrets/bird.env << 'EOF'
AUTH_TOKEN=your_auth_token
CT0=your_ct0
EOF

# Fireflies
echo "your_api_key" > ~/clawd/secrets/fireflies.key

# Slack
echo '{"user_token": "xoxp-xxx"}' > ~/clawd/secrets/slack-super-ada.json

1. Add cron job for daily 09:00 review:

bash
clawdbot cron add --name "daily-review" --schedule "0 9 * * *"

Screen Time Query

The skill queries macOS Screen Time directly from knowledgeC.db:

python
SELECT 
  ZVALUESTRING as app,
  SUM(ZENDDATE - ZSTARTDATE) as seconds
FROM ZOBJECT 
WHERE ZSTREAMNAME = '/app/usage' 
AND date(ZSTARTDATE + 978307200, 'unixepoch') = '2026-01-15'
GROUP BY ZVALUESTRING
ORDER BY seconds DESC

Fireflies Speaker Verification

Meetings are verified by checking if user actually spoke (not just invited):

graphql
{
  transcripts(limit: 30) {
    title dateString duration
    sentences { speaker_name }
  }
}

Only meetings where speaker_name contains user's name are counted.

License

MIT