DIY Companies House + CRM vs a dedicated local lead workflow

For UK agency owners choosing between stitching free filings + a CRM themselves, or paying for a workflow built around fresh local signals.

This is not “DIY is stupid.” DIY is how most good agencies start.

The question is when DIY stops being clever and starts being an unpaid second product you maintain forever.

Who this is for (and who it is not)

For: UK local marketing / lead-gen agencies already exporting from Companies House, pasting into Sheets, then pushing something into a CRM or inbox.

Not for: teams with a dedicated data eng function and a custom enrichment pipeline they actually maintain. If that is you, keep building.

The DIY stack (honest version)

A common competent stack:

1. Companies House search or bulk export
2. Google Sheet / Airtable for filters
3. Manual or semi-manual enrichment (website, phone, LinkedIn)
4. CRM or shared inbox for “status”
5. Copy-paste into an email tool
6. Founder memory for what happened last week

On a quiet week, it works. On a delivery week, it rots.

What DIY gets right

• Cost of data access can be low — public filings exist for a reason
• Full control — you choose filters, fields, and tools
• Learning — you feel the market with your hands
• No vendor lock-in on day one

If you are validating a niche, DIY is often the correct first move.

Where DIY quietly taxes you

1. Assembly time is the product

The filings are free. The hours are not. Pulling, cleaning, de-duping, and deciding “is this even local service?” is the job.

2. Freshness decays in the sheet

Tuesday’s good list is next month’s stale guilt. Without a refresh habit, DIY becomes a graveyard with formulas.

3. CRM theatre replaces motion

Agencies buy bigger CRMs hoping structure creates outbound. Structure without a weekly intake ritual just documents inactivity.

4. First email still blank

Even with perfect rows, someone still writes the first line. DIY stacks often end one step before the only step that creates conversations.

5. Single point of failure

If only the founder knows the export ritual, holiday weeks = pipeline zero.

The dedicated workflow alternative (category, not pitch deck)

A dedicated local lead workflow is not “more contacts.” It is a system that keeps this loop short:

Fresh local signals → qualify → park in a desk → first outreach draft → stage movement → next week’s refresh

Judged by cycle time and completion rate, not by how many integrations you can logo-wall.

Side-by-side comparison

Neither column is “moral.” They are different cost shapes.

When you should stay DIY

Stay DIY if:

• You prospect fewer than a handful of new targets a month
• You are still choosing a niche
• Someone enjoys the data craft and has protected time
• Your CRM is already the team’s real home and stays updated
• You are not losing deals because intake is slow

When DIY is the wrong pride

Switch approach when two or more are true:

• Prospecting slips every busy delivery week
• You re-build the same sheet monthly
• First emails lag days behind finding the lead
• Nobody trusts the CRM stages
• You can name the hours lost and still call the stack “free”

Free filings plus expensive founder time is not free.

A practical migration path (no big-bang)

You do not need to burn the CRM.

1. Keep email sending and deep history where they work
2. Move weekly new local intake to a dedicated desk
3. Standardise stages to a short set (new → researching → contacted → replied → meeting → won/lost/nurture)
4. Attach first-draft outreach to the intake moment
5. Review Friday: what moved, what aged out

DIY becomes a backup research path, not the operating system.

How FoundryHQ fits

FoundryHQ is one answer in the dedicated-workflow column for UK agencies:

• Fresh newly opened and expanding local business signals
• Lead desk + simple pipeline
• AI first outreach draft
• £79/month, no free trial

It does not claim exclusive ownership of public truth. It claims a shorter path from signal to conversation.

If your DIY stack already completes that loop every week without drama, you do not need us. If the loop breaks under delivery load, that is the gap.

Failure modes on both sides

DIY failure: heroic CSV, no sends, sheet guilt. Tool failure: subscription with no weekly block — shelfware. Shared failure: no niche filter, spraying anyone with a company number.

The workflow only works if a human still decides who deserves a Tuesday.

Next step

If you want to see the dedicated loop end to end:

See how FoundryHQ runs fresh local signals → lead desk → first draft. https://foundryhq.agency

Open the desk when you are ready to work this week’s list: https://app.foundryhq.agency/login?next=/leads

Meta

• Meta title: DIY Companies House + CRM vs local lead workflow
• Meta description: Honest comparison for UK agencies: when Companies House + sheets + CRM is enough, when it becomes a tax, and what a dedicated local lead workflow changes.