aashari/mail-meetings

Mail Meetings — Calendar Invites and Meeting Emails

Period: $ARGUMENTS (default: last 7 days)

Query

DB="$HOME/Library/Mail/V10/MailData/Envelope Index"
SINCE=$(($(date +%s) - 604800))  # 7 days; adjust per $ARGUMENTS

sqlite3 "$DB" "
SELECT datetime(m.date_received,'unixepoch','localtime') as dt,
       s.subject, a.address as sender, a.comment as name,
       mb.url as mailbox, m.ROWID, m.read
FROM messages m
JOIN subjects  s  ON m.subject = s.ROWID
JOIN addresses a  ON m.sender  = a.ROWID
JOIN mailboxes mb ON m.mailbox = mb.ROWID
WHERE m.date_received >= ${SINCE}
  AND m.deleted = 0
  AND mb.url NOT LIKE '%Spam%' AND mb.url NOT LIKE '%Trash%'
  AND (
    s.subject LIKE '%invitation%'
    OR s.subject LIKE '%invite%'
    OR s.subject LIKE '%meeting%'
    OR s.subject LIKE '%standup%'
    OR s.subject LIKE '%retro%'
    OR s.subject LIKE '%sync%'
    OR s.subject LIKE '%call%'
    OR s.subject LIKE '%agenda%'
    OR s.subject LIKE '%(Updated invitation)%'
    OR s.subject LIKE '%has invited you%'
    OR s.subject LIKE '%calendar%'
    OR s.subject LIKE '%@ %'
    OR a.address LIKE '%calendar%'
    OR a.address LIKE '%gemini-notes%'
    OR a.address LIKE '%meet-recordings%'
  )
ORDER BY m.date_received DESC;" 2>/dev/null

Step 2: Categorize meeting emails

Parse bodies to extract:

• New invites: "You have been invited to..." — extract meeting title, date/time, organizer
• Updated invites: time or attendee changes
• Cancelled meetings: "has been cancelled"
• Meeting notes/summaries: from Gemini Notes, Otter.ai, Notion, etc.
• Agendas: ahead of meetings

python3 ~/.claude/skills/_mail-shared/parser.py <ROWID1> <ROWID2> ...

Step 3: For upcoming meetings, extract key fields

From invite body, find:

• Meeting title
• Date and time (look for @, on [date], time patterns)
• Organizer
• Video link (Zoom, Google Meet, Teams URLs)
• Location

Output Format

Group by type:

Upcoming Meetings (invites received): | Meeting | When | Organizer | Link | |---|---|---|---|

Updated/Changed Meetings: [list changes]

Meeting Notes received: [list summaries with key decisions/action items extracted]

Cancelled: [list cancellations]

For each meeting note, pull out "Suggested next steps" or "Action items" sections if present.