Weekly UK Company Watchlist Alerts | Companies House Monitoring

PromptCreate

Every Monday at 8am, run a change-detection sweep over a watchlist of UK companies and email a concise brief of what changed in the last seven days. The goal is early warning on the customers, suppliers, and competitors we track: new filings, newly registered charges, director appointments and resignations, and any insolvency activity.

Start by reading the watchlist from Google Sheets using Get Values. The tab holds one row per company with its Companies House company number, the company name, and a relationship label (customer, supplier, or competitor). Company numbers are 8-character strings, so preserve any leading zeros exactly as written.

For each company number, pull the latest data from Companies House: List Filing History, Get Company Insolvency, List Company Charges, and List Company Officers. Companies House is read-only public data, so this is safe to run as often as needed.

Work out what is new or changed in the last seven days by comparing the dates on each record against today. Look for: new filings such as annual accounts or confirmation statements (use the filing dates); newly registered charges or mortgages; officer appointments or resignations (new appointment dates or newly populated resignation dates); and any insolvency cases or status changes. Because there is no stored history between runs, the seven-day window is how new activity is detected, so only treat items dated within the last week as changes.

Write the brief grouped by company and ordered by severity, most serious first. Clearly label anything that needs attention, such as an overdue filing, a new mortgage or charge, or a director resignation, and note the relationship label so the reader knows whether it is a customer, supplier, or competitor. Keep each company's entry to a few tight lines with the date of each change. Only include companies that actually had activity in the window so the email stays short and scannable; if nothing changed anywhere, say so in one line.

Send the finished brief with the Gmail Send a Message operation to the monitoring distribution list. Use a clear subject line that includes the date and a count of companies with activity, for example 'UK watchlist: 3 companies with activity this week'.

What does this prompt do?

Reads your watchlist of UK companies from a Google Sheet, covering customers, suppliers, and competitors.
Checks each company's public Companies House record for anything new in the last seven days.
Flags the things that matter most: overdue accounts, new mortgages or charges, and director resignations.
Emails a clean, ranked brief to your monitoring list every Monday morning, listing only companies that actually changed.

What do I need to use this?

A Google account with a spreadsheet listing the UK company numbers you want to watch.
A free Companies House account for access to the public company register.
A Gmail account to send the weekly brief from.
The email address of your monitoring distribution list.

How can I customize it?

Change the schedule, for example run it daily or every Monday and Thursday instead of once a week.
Adjust the lookback window, which defaults to the last seven days of activity.
Decide who receives the brief and what counts as needing attention, such as overdue filings or new charges.

FAQs

Where does the company information come from?

From Companies House, the UK's official public company register. It is read-only public data, so you only need a free account to access it, and nothing is ever changed on the register.

Will I get an email even when nothing happened?

The brief only lists companies that had activity in the last seven days, so quiet weeks stay short and scannable. If nothing changed across your whole watchlist, the email simply says so in a single line.

How do I choose which companies to monitor?

List their UK company numbers in a Google Sheet and label each one as a customer, supplier, or competitor. The brief uses those labels to group companies so you can see who is who at a glance.

What kinds of changes does it flag?

New filings such as annual accounts and confirmation statements, newly registered mortgages or charges, director appointments and resignations, and any insolvency activity. Anything that needs attention, like an overdue filing, is clearly labelled.

Can I send it to my whole team?

Yes. Point it at a shared distribution list or add several recipients so everyone who needs the weekly update receives it.

Related templates

Call overdue Xero customers with an AI collections agent

Every weekday at 10am, an AI voice agent phones your most overdue Xero accounts, logs what each customer promised, and reports back to finance in Slack.