How to Get New UK Company Registrations in Google Sheets Every Morning (n8n)

Description and use

Automated daily ingestion of new UK company registrations into Google Sheets using n8n and Apify, eliminating the need to maintain a scraper.

Problem

Refreshing the UK Companies House register by hand every morning is impractical for busy teams.

Outcome

Automated daily ingestion of new UK company registrations into Google Sheets, enabling sector filtering via SIC codes without maintaining a scraper.

Workflow

• Download the n8n workflow JSON from the examples repository.
• Import the workflow into n8n and create a Header Auth credential for the Apify API token.
• Configure the request body with sector keyword, since date, and maxResults.
• Assign the Apify credential to the Run the Actor node.
• Set the Google Sheets append node with the target spreadsheet URL and sheet name.
• Schedule the workflow to run every morning at 07:00.
• The workflow appends one row per new company to the sheet.

Evidence

Fresh company registrations are one of the clearest B2B signals in the UK: a new incorporation in your sector means a new budget, a new vendor to approach, a new compliance file.

Source

This workflow runs the UK Companies House Data Scraper at 07:00 every morning and appends every match to a Google Sheet: one row per company, no scraper to maintain.

Source

No Companies House API key required: the Actor uses one internally (you can pass your own free key through the optional apiKey input if you prefer).

Source

The request body ships as: {"mode":"search","query":"software development","since":"2026-10-01","maxResults":100}

Source

2.50 USD per 1,000 valid results, plus 0.00005 USD per run start.

Source