Quick overview
This workflow runs daily to monitor a UK company watchlist via the Companies House Public Data API, sending staged deadline reminders, overdue repeats, filing confirmations, and status-change alerts to Gmail, Slack, or SMTP, and optionally appending an audit log to Google Sheets.
How it works
- Runs daily at 08:00 (Europe/London) or on manual trigger and parses the watchlist and reminder settings.
- Looks up each company in the Companies House API and handles common API errors (for example 401, 404, and rate limiting).
- When a due date moves forward since the previous run, fetches recent filing history from Companies House to include as evidence.
- Calculates accounts and confirmation statement reminder stages (for example 30/14/7/1 days), weekly overdue repeats, filing-confirmed events, and strike-off/liquidation or other status changes, while deduplicating notifications using stored state.
- If there is anything new to report (or an optional weekly digest), routes the message to the enabled channels (Gmail, Slack, or SMTP) and formats the content as text or HTML.
- If Google Sheets logging is enabled, appends one audit-log row per event (or per company for a digest/baseline) to a “Filings” sheet.
Setup
- Create a free Companies House REST API key and add it as an HTTP Basic Auth credential (API key as username, blank password) for the Companies House API requests.
- Populate the Settings watchlist with company numbers (optionally including a label and per-company warning window) and adjust reminderDays, overdueRepeatDays, and notifyChannels as needed.
- Enable and configure at least one notification channel (Gmail, Slack, or SMTP) by adding credentials and setting the recipient email address or Slack channel.
- To log to Google Sheets, enable the Google Sheets node, connect your Google account, and set the target spreadsheet URL/ID and ensure a “Filings” tab exists.
- (Optional) Enable the error-alert Gmail or Slack node and set this workflow as its own Error workflow in n8n workflow settings to receive failure notifications.
Additional info
Also from this creator: Send UK food hygiene and FSA ratings alerts to Gmail, Slack or Google Sheets · Plan UK bank holiday reminders and digests with GOV.UK, Gmail and Slack.