Lead Tracker
Demo build of a lead-tracking dashboard for freelance outreach. The Today queue answers the daily question — who needs contacting right now — while a pipeline board moves each lead through eight stages from New to Won or Lost. Every lead carries contact details, the problem you spotted, a score, notes, and a next-action date. State lives in localStorage, and an optional Google Sheets sync works through a Google Apps Script the app generates for you to paste into your sheet. Demo mode seeds 25 fictional leads so there's something to explore before you add your own.
Full case study: A CRM the size of the problem: localStorage, 8 stages, and a pasteable Apps Scriptread →
01 — PROBLEM
Freelance outreach dies in a spreadsheet — no sense of what's due today, no pipeline view, and follow-ups slip.
02 — APPROACH
Built a dashboard around the working question. A Today queue surfaces leads whose next action is due, a board tracks each lead through eight stages from New to Won or Lost, and a details view holds notes and follow-up dates. Data persists in localStorage, with optional Google Sheets sync through an Apps Script you paste from inside the app.
03 — OUTCOME
A demo build that ships with 25 fictional seed leads so the dashboard is explorable immediately. Switching off demo mode gives you an empty tracker backed by the same storage and sync.