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.