🌴 BasecampPulse

What we built

This project builds an automated weekly reporting tool that connects to Visit Greater Palm Springs' Basecamp account via API, pulls all to-do data, and generates a clean, readable summary report organized by department. Managers receive a plain-language digest highlighting overdue items by aging bucket (7, 14, 30+ days), unassigned tasks, and missing due dates. This eliminates manual report-building and helps leadership spot bottlenecks before they escalate.

The blind spot

Basecamp's built-in reporting only shows a single undifferentiated list of all overdue to-dos across every project and department, forcing managers to either wade through a massive combined list or manually run person-by-person reports.

• No way to view overdue items by department
• No way to identify aging tasks at a glance
• Unassigned and undated to-dos stay hidden
• Hours of manual report-building every week

A lightweight Python automation

Authenticate with the Basecamp 3 API, fetch all to-dos across projects, enrich them with assignee and project/department metadata, then classify each item by overdue aging bucket. An AI layer reads the structured data and writes a plain-language executive summary. The report renders as a clean HTML digest — delivered on a schedule or on-demand through a Streamlit dashboard managers can trigger and preview in the browser.

What managers see

• Overdue breakdown by department and aging bucket (1–7, 8–14, 15–30, 30+ days)
• Due-status view — 3 due today, 8 due this week, 14 upcoming — so nothing slips next
• Risk lists: unassigned, missing due dates, and critical 30+ day items with direct Basecamp links
• My To-Dos view — each signed-in user sees their own tasks
• AI-written executive briefing + export to PDF / Excel / CSV

Six views, one click each

From raw data to a manager's memo

Claude reads the structured to-do data and writes a plain-language executive briefing — no chart-reading required. A live example from the current account:

• Situation overview: 65%+ of tracked to-dos overdue; heaviest backlogs in Corporate Communications, Comms-PR, and Destination Experiences.
• Urgent (30+ days): 21 items past a month — the oldest 172, 165, and 158 days overdue.
• Top contributors flagged for 1:1s: Julie Sinclair (11), Rob Osterberg (8), Colleen (7).
• Recommended actions: assign the 6 unassigned tasks today and add due dates to the 2 undated items.

How it works

1. Authenticate — OAuth2 with the Basecamp 3 API; token cached and auto-refreshed (volume-persisted on Railway).
2. Fetch & classify — pull every to-do, compute overdue status and aging buckets, flag unassigned / undated items.
3. Enrich — map each assignee to a department via a maintained people directory (14 teams & sub-teams).
4. Summarize — an AI layer drafts a plain-language executive briefing from the structured data.
5. Deliver — Streamlit dashboard with Google sign-in & email allowlist, deployed on Railway.

The stack

Secrets supplied per-environment; tokens persist on a Railway volume across restarts.