Inbound Package Log & Pickup Notification: Stop Packages Piling Up Unclaimed
Log every inbound package with a photo, fuzzy-match the recipient against your employee directory, email them to come get it, and capture a confirmed pickup — so nothing sits in the mailroom for weeks.
A web tool where mailroom staff snap a photo of each package label, the tool matches the recipient to your directory and emails them to come get it, reminders chase uncollected packages, and a staffer confirms each pickup with a signature before it's marked Collected — plus an aging report and CSV export.
Before you start
- A Supabase account (free)
- A Vercel account (free)
- A Resend account (free)
- An employee directory (name, email, department/floor) as a CSV or sheet
- A phone or tablet at the mailroom desk to photograph labels
- Claude Code or any AI coding agent
The problem this kills
A package lands at the front desk. Someone scribbles a name on a sticky note, stacks it on the pile, and hopes the recipient walks by. Half the time the name on the label is wrong, abbreviated, or belongs to someone in a different building. Perishables go bad. Laptops and checks sit in an open pile for two weeks. When someone finally asks "did my thing arrive?", nobody can say when it came in, who signed for it, or where it went.
It's a small job that quietly turns into chaos: no record of what came in, no proof anyone picked it up, and a recipient who never even knew their package was waiting. You don't need a warehouse system to fix this, and you don't need to be a developer to build the fix.
What you'll build
A simple internal web tool for the mailroom desk. A staffer snaps a photo of the package label, the tool reads the recipient name and fuzzy-matches it against your employee directory (so "J. Smith - Acctg" still finds Jane Smith in Accounting), and logs the carrier and tracking number. It instantly emails the recipient that a package is waiting, with the floor or pickup point. When the recipient (or a proxy) comes to collect, staff pull up the package, confirm the match, and capture a pickup signature or photo before the package is marked Collected. Anything nobody picks up gets a reminder email, and an aging report shows you what's been sitting too long. Names that don't match anyone hold in a pending queue for a human to assign by hand.
What's inside the Implementation Plan
The downloadable plan is a step-by-step file you paste into an AI coding agent. It opens by interviewing you about your business — how packages arrive and who logs them, where your employee directory lives and exactly what its columns are called, how recipient names show up on labels, your typical and peak daily volume, your pickup and ID rules, and the messy cases (interns, contractors, "deliver to floor 4," packages for people who left) — and then it tailors the data model, the matching, and every later step to your answers. This is not a generic template; the agent reflects a short spec back to you and waits for your thumbs-up before it builds anything. From there it walks the agent through the directory import, the photo-and-log desk screen, the fuzzy match, the recipient notification, the pending queue, the signed pickup confirmation, reminders, the aging report, and the CSV export — each step with a ready-to-copy prompt. There's also a fallback so you can build the whole thing today even with no link to your HR system.
The governance it includes (this is the point)
Even a mailroom log needs real controls, and this one ships with them: login so only your team can use it, row-level security so you only ever see your own organization's packages, a complete audit trail of who logged, notified, and released every package and when, a hard human gate so a package can't be marked Collected until a staffer confirms the recipient and captures a signature, and duplicate guards keyed on the tracking number so the same package can't be logged twice. Unmatched recipients hold in a pending queue instead of firing a wrong-person email.
Who it's for
Mailroom staff, receptionists, and facilities or office admins who are the unofficial keeper of the package pile and want a record, a notification, and proof of pickup without buying enterprise software. If you can describe how a package gets from your front desk to the right person's hands, you can build this.
You've got this — start with the plan, paste the first prompt, answer the interview, and you'll be logging your first package the same afternoon.