Daily supplier and customer insolvency risk alerts

Every weekday at 6am, run this supplier and customer risk tripwire. Read my watchlist of UK company numbers from a Google Sheets tab using Get Values. The tab has one company number per row, alongside columns for the last checked date and a flag recording the last status I was alerted about.

For each company number in the list, call Companies House Get Company Profile to read the current company status, and Companies House Get Company Insolvency to check for insolvency cases. Company numbers are 8-character zero-padded strings, so preserve any leading zeros when looking them up.

Treat a company as adverse if its status is anything other than active, for example dissolved, liquidation, administration, or receivership, or if Get Company Insolvency returns an open insolvency case. Companies that are still active with no open case are healthy, so skip them.

When a company shows an adverse status, post an alert to my finance or operations Slack channel using the Slack bot Send a Message. Name the company, its company number, its current status, and the insolvency case type where there is one, so the team can pause payments, chase receivables, or line up an alternative supplier.

After checking each company, write the checked date and the current status flag back to the sheet with Update Values. Only send a Slack alert when the adverse status is new or has changed since the last recorded flag, so the same dissolution or insolvency case is not re-alerted every morning. This is a deterministic tripwire with one known lookup per company, so it should only fire when a company actually shows an adverse status.