The Automation Agency
Internal tools & live dashboards · UK

Replace the spreadsheet
your business secretly runs on. One place to look.

A lot of businesses are one person's daily routine away from a proper system — someone opens the same six websites every morning and copies what changed into a spreadsheet, and that spreadsheet is the only record anyone has. It works until they are on holiday, or the business outgrows what one person checking by hand can keep up with. We take that routine, run it automatically, and put the result in one live view your team can trust — built on a standard database and web stack you are not locked into.

Who we build for
We build internal tools for UK businesses where one person's daily routine is the only record anyone has.
What we take off people
We replace the daily manual check and the spreadsheet nobody fully trusts with a live dashboard that collects its own data and tells you when a source has changed shape.
What it costs to start
Our fixed prices start at £300 for a chatbot and £500 for a single automation; a whole process built end to end starts at £3,000, and the written Process Audit is £1,500, credited against a custom build.
Where we are
We are based in Chesterfield, Derbyshire, and work with clients across the UK, with in-person kickoffs anywhere in the East Midlands.
The problem

Why this keeps happening.

A lot of businesses are one person's daily routine away from a proper system — someone opens the same six websites every morning and copies what's changed into a spreadsheet, and that spreadsheet is the only record anyone has. It works until that person is on holiday, or a site changes its layout, or the business grows past what one person checking by hand can keep up with. An internal tool takes that routine and runs it automatically, then shows you the result in one place instead of a shared spreadsheet nobody fully trusts.

What we build

Example workflows

  1. 01

    Public or partner websites → scraped on a schedule with Playwright → structured data written straight into your own dashboard

  2. 02

    Live dashboard → shows the current state of your business — bookings, stock, applications, leads — refreshed automatically, not a snapshot from last week

  3. 03

    Threshold or change detected → an alert goes out by email, Slack or WhatsApp the moment something needs a person's attention

  4. 04

    Several data sources → reconciled into one internal view, so nobody's cross-referencing three systems by hand to answer a simple question

  5. 05

    Staff-facing tool → replaces a shared spreadsheet or a rigid off-the-shelf app that almost fits, built instead around how your team actually works

  6. 06

    Historical data → kept and queryable, so you can see trends over time rather than just today's snapshot

From £3,000
Proof it works
PlusRooms

PlusRooms needed daily coverage of planning applications across England — previously a full working day of one person trawling council websites by hand. We built Planscope: a Playwright scraping pipeline covering 97% of London boroughs, feeding a live dashboard with alerts, refreshed on a 24-hour cycle. Nobody has to check a council website again.

97%

London borough coverage, refreshed every 24 hours

How we count — what this number measures, and what we have not finished checking.

Common questions

Answers before you ask.

Should we build a custom internal tool, or buy off-the-shelf software?+

Buy first, if something already does exactly what you need — there's no point paying to rebuild a stock-management tool that's already a solved problem. Custom is worth it once you're bending an off-the-shelf tool to do something it wasn't designed for, or once the 'software' you're actually running is a spreadsheet and someone's memory. We'll tell you honestly which side of that line you're on before quoting anything.

Why Supabase and Next.js specifically?+

Supabase gives us a proper Postgres database with authentication and real-time updates out of the box, and Next.js builds a fast, straightforward dashboard on top of it — together they get you from spreadsheet to a real internal tool without a six-month build. It's also a stack you're not locked into: a standard database and a standard web app, not a proprietary platform you can't leave.

How much does an internal tool or dashboard cost?+

A dashboard is a custom build, from £3,000, fixed price. A scraping pipeline covering many sources, with alerts and history behind it, is quoted after a scoping call — sized to what the tool has to do rather than billed by the hour. The £1,500 Process Audit puts that number in writing first if you would rather see it before committing. Credited in full against any custom build (£3,000+) if you proceed within 60 days.

What happens if it breaks or a data source changes?+

We build in monitoring so a scraping pipeline that stops matching a site's layout gets flagged rather than silently going stale. After the 30 days included with every build, the support plan (£150/mo per system) covers exactly that: watching it, and fixing it when a source changes shape. It is optional, monthly rolling, with no minimum term. The support plan begins when the 30 days of support included with every build run out. Nothing is charged before that.

Can you migrate our existing spreadsheet into a proper tool?+

Yes — that's often exactly how these projects start. We take what's in the spreadsheet, clean it up, and build the dashboard or database around it, so you don't lose the history you already have while gaining something that updates itself.

Who ends up using the tool day to day?+

Whoever currently does the manual version of the job — usually one or two people who go from checking things by hand every morning to glancing at a dashboard instead. We build the interface around what they actually need to see, not a generic admin panel.

Related services
Book now

Free 30-minute call. No pitch, no pressure.

Pick a slot below and we'll talk through your business — what's worth automating, what isn't, and what it would cost. Prefer email? Use the form.

Prefer a conversation? Call Ben

01246 923041

Mon–Fri, 9am–5.30pm

Rather write it down?

Send us the job →

Reply within 24 hours

Book a slot — instant

Two quick questions, then pick your slot

So we can come to the call with something useful rather than spending the first ten minutes working out who you are.

Or send a message

Tell us about the job

You don't need a technical plan. Describe what your team does now and what you'd like to happen instead, in your own words. We reply within 24 hours.

A useful first message answers four things:

  1. What does someone on your team do by hand at the moment?
  2. Which software does it involve? Email, spreadsheets, your accounts package — whatever you use.
  3. What would you like to happen on its own instead?
  4. What should a person still check before it goes out?

No mailing list. We won't email you unless you email us first.

We don't take subcontract, white-label or overflow work, and we don't buy SEO, backlinks, reviews or lead lists. If you're selling something, pick the last option under “Your role” and we'll know straight away.