Weekly UK company watchlist alerts from Companies House

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'.