See llms.txt for all machine-readable content.

Back to Templates

Send staged Companies House filing reminders with Gmail, Slack and Sheets

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

  1. Runs daily at 08:00 (Europe/London) or on manual trigger and parses the watchlist and reminder settings.
  2. Looks up each company in the Companies House API and handles common API errors (for example 401, 404, and rate limiting).
  3. When a due date moves forward since the previous run, fetches recent filing history from Companies House to include as evidence.
  4. 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.
  5. 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.
  6. 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

  1. 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.
  2. Populate the Settings watchlist with company numbers (optionally including a label and per-company warning window) and adjust reminderDays, overdueRepeatDays, and notifyChannels as needed.
  3. Enable and configure at least one notification channel (Gmail, Slack, or SMTP) by adding credentials and setting the recipient email address or Slack channel.
  4. 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.
  5. (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.