HTUAICBeta

small-business

2 posts

WorkflowspiedinoPlaybook

I'm not a developer. I used Claude Code to build my uncle a local sales dashboard with one-click PDF export.

My uncle manages sales reps at a pharmaceutical company. He needs to see how each one is doing against budget, and then present that in a room, often while travelling. I am not a developer — my background is marketing. The obvious answers were generic BI software, or paying somebody to build a tool. Instead I directed Claude Code in plain language and built a small web app myself. The requirements came out of an actual conversation with him, not from me guessing. The figures are sensitive, so the app runs entirely in the browser: no server, no upload, works offline. He drags in the Excel export he already produces — deliberately not a live connection to the system, so nothing sensitive leaves his laptop. And the output is not only a dashboard. One click turns it into a PDF laid out as slides, because he needed something to put up in front of people, not a screen to scroll through alone.

AutomationpiedinoPlaybook

The prompt I use to turn "no website found" into an email opening that doesn't sound like a mail-merge

The easiest lead is not a business with a site that might want a redesign. It is a business with no site at all — or one that is broken, or one that has clearly been abandoned. Which means the whole pitch lives or dies on how specifically you name the gap. The reusable part is the writing step, and it works whether or not you ever automate the finding. You need three plain facts: the category, the town, and what actually happened when you checked for a website. From those, the job is to write a first paragraph that reads like you looked at that one business — not a template with the name swapped in. You can type those three facts in by hand. I built a scanner that pulls them from OpenStreetMap and then checks each site for real instead of trusting what is on file — that catches both a business with an unlisted site and a domain that is registered but dead — but the prompt does not care where the facts came from.